APPS.PAY_PAYROLL_XML_EXTRACT_PKG dependencies on DBMS_SQL

Line 438: P_SQLSTR_TAB IN OUT NOCOPY dbms_sql.varchar2s,

434: *****************************************************************************/
435:
436: PROCEDURE BUILD_SQL
437: (
438: P_SQLSTR_TAB IN OUT NOCOPY dbms_sql.varchar2s,
439: P_CNTR IN OUT NOCOPY number,
440: P_STRING varchar2
441: ) AS
442: l_proc_name varchar2(100);

Line 519: sqlstr dbms_sql.varchar2s;

515: filtering undesired ADDRESS DETAILS archived at payroll action
516: level (action_context_type = 'PA') by the payroll archiver.*/
517:
518: l_proc_name varchar2(100);
519: sqlstr dbms_sql.varchar2s;
520: l_cntr_sql number;
521: l_xml BLOB;
522: csr number;
523: ret number;

Line 873: csr := dbms_sql.open_cursor;

869: FOR cntr IN sqlstr.first()..sqlstr.last() LOOP
870: hr_utility_trace(sqlstr(cntr));
871: END LOOP;
872:
873: csr := dbms_sql.open_cursor;
874: dbms_sql.parse (csr,
875: sqlstr,
876: sqlstr.first(),
877: sqlstr.last(),

Line 874: dbms_sql.parse (csr,

870: hr_utility_trace(sqlstr(cntr));
871: END LOOP;
872:
873: csr := dbms_sql.open_cursor;
874: dbms_sql.parse (csr,
875: sqlstr,
876: sqlstr.first(),
877: sqlstr.last(),
878: false,

Line 879: dbms_sql.v7);

875: sqlstr,
876: sqlstr.first(),
877: sqlstr.last(),
878: false,
879: dbms_sql.v7);
880: dbms_sql.bind_variable (csr,
881: ':l_action_context_id',
882: p_action_context_id);
883: dbms_sql.bind_variable (csr,

Line 880: dbms_sql.bind_variable (csr,

876: sqlstr.first(),
877: sqlstr.last(),
878: false,
879: dbms_sql.v7);
880: dbms_sql.bind_variable (csr,
881: ':l_action_context_id',
882: p_action_context_id);
883: dbms_sql.bind_variable (csr,
884: ':l_action_information_id',

Line 883: dbms_sql.bind_variable (csr,

879: dbms_sql.v7);
880: dbms_sql.bind_variable (csr,
881: ':l_action_context_id',
882: p_action_context_id);
883: dbms_sql.bind_variable (csr,
884: ':l_action_information_id',
885: p_action_information_id);
886: ret := dbms_sql.execute(csr);
887: dbms_sql.close_cursor(csr);

Line 886: ret := dbms_sql.execute(csr);

882: p_action_context_id);
883: dbms_sql.bind_variable (csr,
884: ':l_action_information_id',
885: p_action_information_id);
886: ret := dbms_sql.execute(csr);
887: dbms_sql.close_cursor(csr);
888:
889: IF g_xml_table.count() <> 0 THEN
890: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);

Line 887: dbms_sql.close_cursor(csr);

883: dbms_sql.bind_variable (csr,
884: ':l_action_information_id',
885: p_action_information_id);
886: ret := dbms_sql.execute(csr);
887: dbms_sql.close_cursor(csr);
888:
889: IF g_xml_table.count() <> 0 THEN
890: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);
891: FOR cntr IN g_xml_table.first()..g_xml_table.last() LOOP