APPS.PAY_FI_RULES dependencies on DBMS_SQL

Line 779: sqlstr DBMS_SQL.VARCHAR2S;

775:
776: l_xml CLOB;
777: cntr_flex_col NUMBER;
778: l_flex_col_num NUMBER;
779: sqlstr DBMS_SQL.VARCHAR2S;
780: csr NUMBER;
781: ret NUMBER;
782: l_cntr_sql NUMBER;
783: l_total_pay NUMBER;

Line 788: PROCEDURE build_sql(p_sqlstr_tab IN OUT NOCOPY DBMS_SQL.VARCHAR2S,

784: l_total_earnings NUMBER;
785: l_total_deductions NUMBER;
786:
787:
788: PROCEDURE build_sql(p_sqlstr_tab IN OUT NOCOPY DBMS_SQL.VARCHAR2S,
789: p_cntr IN OUT NOCOPY NUMBER,
790: p_string VARCHAR2) AS
791: --
792: l_proc_name varchar2(100);

Line 887: csr := DBMS_SQL.OPEN_CURSOR;

883: END LOOP;
884: build_sql(sqlstr, l_cntr_sql, ' pay_fi_rules.load_xml(''CE'', NULL, ''BALANCE DETAILS'', NULL); ');
885: build_sql(sqlstr, l_cntr_sql, ' END LOOP; End; ');
886: --
887: csr := DBMS_SQL.OPEN_CURSOR;
888: DBMS_SQL.PARSE(csr
889: ,sqlstr
890: ,sqlstr.first()
891: ,sqlstr.last()

Line 888: DBMS_SQL.PARSE(csr

884: build_sql(sqlstr, l_cntr_sql, ' pay_fi_rules.load_xml(''CE'', NULL, ''BALANCE DETAILS'', NULL); ');
885: build_sql(sqlstr, l_cntr_sql, ' END LOOP; End; ');
886: --
887: csr := DBMS_SQL.OPEN_CURSOR;
888: DBMS_SQL.PARSE(csr
889: ,sqlstr
890: ,sqlstr.first()
891: ,sqlstr.last()
892: ,FALSE

Line 893: ,DBMS_SQL.V7);

889: ,sqlstr
890: ,sqlstr.first()
891: ,sqlstr.last()
892: ,FALSE
893: ,DBMS_SQL.V7);
894: ret := DBMS_SQL.EXECUTE(csr);
895: DBMS_SQL.CLOSE_CURSOR(csr);
896:
897:

Line 894: ret := DBMS_SQL.EXECUTE(csr);

890: ,sqlstr.first()
891: ,sqlstr.last()
892: ,FALSE
893: ,DBMS_SQL.V7);
894: ret := DBMS_SQL.EXECUTE(csr);
895: DBMS_SQL.CLOSE_CURSOR(csr);
896:
897:
898:

Line 895: DBMS_SQL.CLOSE_CURSOR(csr);

891: ,sqlstr.last()
892: ,FALSE
893: ,DBMS_SQL.V7);
894: ret := DBMS_SQL.EXECUTE(csr);
895: DBMS_SQL.CLOSE_CURSOR(csr);
896:
897:
898:
899: