APPS.PAY_DK_RULES dependencies on DBMS_SQL

Line 345: sqlstr DBMS_SQL.VARCHAR2S;

341: temp varchar2(100);
342: cntr number;
343: l_uom varchar2(240);
344: l_cntr_sql NUMBER;
345: sqlstr DBMS_SQL.VARCHAR2S;
346: csr NUMBER;
347: ret NUMBER;
348:
349: ---------------

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

349: ---------------
350:
351: -- Private Procedure to build dynamic sql
352:
353: PROCEDURE build_sql(p_sqlstr_tab IN OUT NOCOPY DBMS_SQL.VARCHAR2S,
354: p_cntr IN OUT NOCOPY NUMBER,
355: p_string VARCHAR2) AS
356:
357: l_proc_name varchar2(100);

Line 564: csr := DBMS_SQL.OPEN_CURSOR;

560: build_sql(sqlstr, l_cntr_sql, ' END LOOP; ');
561: -- end new
562: build_sql(sqlstr, l_cntr_sql, ' END LOOP; End; ');
563: --
564: csr := DBMS_SQL.OPEN_CURSOR;
565: DBMS_SQL.PARSE(csr
566: ,sqlstr
567: ,sqlstr.first()
568: ,sqlstr.last()

Line 565: DBMS_SQL.PARSE(csr

561: -- end new
562: build_sql(sqlstr, l_cntr_sql, ' END LOOP; End; ');
563: --
564: csr := DBMS_SQL.OPEN_CURSOR;
565: DBMS_SQL.PARSE(csr
566: ,sqlstr
567: ,sqlstr.first()
568: ,sqlstr.last()
569: ,FALSE

Line 570: ,DBMS_SQL.V7);

566: ,sqlstr
567: ,sqlstr.first()
568: ,sqlstr.last()
569: ,FALSE
570: ,DBMS_SQL.V7);
571: ret := DBMS_SQL.EXECUTE(csr);
572: DBMS_SQL.CLOSE_CURSOR(csr);
573:
574: hr_utility.trace('BALANCE DETAILS : end ');

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

567: ,sqlstr.first()
568: ,sqlstr.last()
569: ,FALSE
570: ,DBMS_SQL.V7);
571: ret := DBMS_SQL.EXECUTE(csr);
572: DBMS_SQL.CLOSE_CURSOR(csr);
573:
574: hr_utility.trace('BALANCE DETAILS : end ');
575: --

Line 572: DBMS_SQL.CLOSE_CURSOR(csr);

568: ,sqlstr.last()
569: ,FALSE
570: ,DBMS_SQL.V7);
571: ret := DBMS_SQL.EXECUTE(csr);
572: DBMS_SQL.CLOSE_CURSOR(csr);
573:
574: hr_utility.trace('BALANCE DETAILS : end ');
575: --
576: end if;