APPS.PAY_NO_RULES dependencies on DBMS_SQL

Line 971: sqlstr DBMS_SQL.VARCHAR2S;

967: temp VARCHAR2(100);
968: cntr NUMBER;
969: l_uom VARCHAR2(240);
970: l_cntr_sql NUMBER;
971: sqlstr DBMS_SQL.VARCHAR2S;
972: csr NUMBER;
973: ret NUMBER;
974:
975: ---------------

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

975: ---------------
976:
977: -- Private Procedure to build dynamic sql
978:
979: PROCEDURE build_sql(p_sqlstr_tab IN OUT NOCOPY DBMS_SQL.VARCHAR2S,
980: p_cntr IN OUT NOCOPY NUMBER,
981: p_string VARCHAR2) AS
982:
983: l_proc_name varchar2(100);

Line 1340: csr := DBMS_SQL.OPEN_CURSOR;

1336: build_sql(sqlstr, l_cntr_sql, ' END LOOP; ');
1337: -- end new
1338: build_sql(sqlstr, l_cntr_sql, ' END LOOP; End; ');
1339: --
1340: csr := DBMS_SQL.OPEN_CURSOR;
1341: DBMS_SQL.PARSE(csr
1342: ,sqlstr
1343: ,sqlstr.first()
1344: ,sqlstr.last()

Line 1341: DBMS_SQL.PARSE(csr

1337: -- end new
1338: build_sql(sqlstr, l_cntr_sql, ' END LOOP; End; ');
1339: --
1340: csr := DBMS_SQL.OPEN_CURSOR;
1341: DBMS_SQL.PARSE(csr
1342: ,sqlstr
1343: ,sqlstr.first()
1344: ,sqlstr.last()
1345: ,FALSE

Line 1346: ,DBMS_SQL.V7);

1342: ,sqlstr
1343: ,sqlstr.first()
1344: ,sqlstr.last()
1345: ,FALSE
1346: ,DBMS_SQL.V7);
1347: ret := DBMS_SQL.EXECUTE(csr);
1348: DBMS_SQL.CLOSE_CURSOR(csr);
1349: --
1350: end if;

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

1343: ,sqlstr.first()
1344: ,sqlstr.last()
1345: ,FALSE
1346: ,DBMS_SQL.V7);
1347: ret := DBMS_SQL.EXECUTE(csr);
1348: DBMS_SQL.CLOSE_CURSOR(csr);
1349: --
1350: end if;
1351: --hr_utility.trace_off();

Line 1348: DBMS_SQL.CLOSE_CURSOR(csr);

1344: ,sqlstr.last()
1345: ,FALSE
1346: ,DBMS_SQL.V7);
1347: ret := DBMS_SQL.EXECUTE(csr);
1348: DBMS_SQL.CLOSE_CURSOR(csr);
1349: --
1350: end if;
1351: --hr_utility.trace_off();
1352: