通过API审批PR和PO

最新推荐文章于 2023-10-08 12:04:01 发布

刚木

最新推荐文章于 2023-10-08 12:04:01 发布

阅读量759

点赞数 1

本文链接：https://blog.csdn.net/q290245786/article/details/106687183

版权

DECLARE
  char1 VARCHAR2(10);
  char2 VARCHAR2(10);
  out1 VARCHAR2(100);
  out2 VARCHAR2(100);
  po_id NUMBER;
  type_po VARCHAR2(20);
BEGIN
  po_document_action_pvt.do_approve(146407, --参数 po_header_id,
                                    'PO',
                                    'STANDARD',
                                    char1,
                                    char2,
                                    out1,
                                    out2);
  COMMIT;
EXCEPTION
  WHEN OTHERS THEN
    ROLLBACK;
    NULL;
END;

DECLARE
  char1 VARCHAR2(10);
  char2 VARCHAR2(10);
  out1 VARCHAR2(100);
  out2 VARCHAR2(100);
  po_id NUMBER;
  type_po VARCHAR2(20);
BEGIN
  MO_GLOBAL.set_policy_context('S',81);
  po_document_action_pvt.do_approve(143631, --参数 单据ID,
                                    'REQUISITION',
                                    'PURCHASE',
                                    char1,
                                    char2,
                                    out1,
                                    out2);
  COMMIT;
EXCEPTION
  WHEN OTHERS THEN
    ROLLBACK;
    NULL;
END;