APPS.PAY_NO_RULES dependencies on DBMS_SQL

Line 958: sqlstr DBMS_SQL.VARCHAR2S;

954: temp VARCHAR2(100);
955: cntr NUMBER;
956: l_uom VARCHAR2(240);
957: l_cntr_sql NUMBER;
958: sqlstr DBMS_SQL.VARCHAR2S;
959: csr NUMBER;
960: ret NUMBER;
961:
962: ---------------

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

962: ---------------
963:
964: -- Private Procedure to build dynamic sql
965:
966: PROCEDURE build_sql(p_sqlstr_tab IN OUT NOCOPY DBMS_SQL.VARCHAR2S,
967: p_cntr IN OUT NOCOPY NUMBER,
968: p_string VARCHAR2) AS
969:
970: l_proc_name varchar2(100);

Line 1327: csr := DBMS_SQL.OPEN_CURSOR;

1323: build_sql(sqlstr, l_cntr_sql, ' END LOOP; ');
1324: -- end new
1325: build_sql(sqlstr, l_cntr_sql, ' END LOOP; End; ');
1326: --
1327: csr := DBMS_SQL.OPEN_CURSOR;
1328: DBMS_SQL.PARSE(csr
1329: ,sqlstr
1330: ,sqlstr.first()
1331: ,sqlstr.last()

Line 1328: DBMS_SQL.PARSE(csr

1324: -- end new
1325: build_sql(sqlstr, l_cntr_sql, ' END LOOP; End; ');
1326: --
1327: csr := DBMS_SQL.OPEN_CURSOR;
1328: DBMS_SQL.PARSE(csr
1329: ,sqlstr
1330: ,sqlstr.first()
1331: ,sqlstr.last()
1332: ,FALSE

Line 1333: ,DBMS_SQL.V7);

1329: ,sqlstr
1330: ,sqlstr.first()
1331: ,sqlstr.last()
1332: ,FALSE
1333: ,DBMS_SQL.V7);
1334: ret := DBMS_SQL.EXECUTE(csr);
1335: DBMS_SQL.CLOSE_CURSOR(csr);
1336: --
1337: end if;

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

1330: ,sqlstr.first()
1331: ,sqlstr.last()
1332: ,FALSE
1333: ,DBMS_SQL.V7);
1334: ret := DBMS_SQL.EXECUTE(csr);
1335: DBMS_SQL.CLOSE_CURSOR(csr);
1336: --
1337: end if;
1338: --hr_utility.trace_off();

Line 1335: DBMS_SQL.CLOSE_CURSOR(csr);

1331: ,sqlstr.last()
1332: ,FALSE
1333: ,DBMS_SQL.V7);
1334: ret := DBMS_SQL.EXECUTE(csr);
1335: DBMS_SQL.CLOSE_CURSOR(csr);
1336: --
1337: end if;
1338: --hr_utility.trace_off();
1339: