APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on DBMS_SQL

Line 3808: p_sqlstr_tab IN OUT NOCOPY DBMS_SQL.VARCHAR2S,

3804:
3805: END archive_data;
3806:
3807: PROCEDURE build_sql(
3808: p_sqlstr_tab IN OUT NOCOPY DBMS_SQL.VARCHAR2S,
3809: p_cntr IN OUT NOCOPY NUMBER,
3810: p_string VARCHAR2)
3811:
3812: IS

Line 3908: sqlstr DBMS_SQL.VARCHAR2S;

3904:
3905: lt_per_bgId_value NUMBER;
3906:
3907: lv_procedure_name VARCHAR2(100);
3908: sqlstr DBMS_SQL.VARCHAR2S;
3909: l_cntr_sql NUMBER;
3910: l_xml BLOB;
3911: csr NUMBER;
3912: ret NUMBER;

Line 4414: csr := dbms_sql.open_cursor;

4410: FOR cntr IN sqlstr.first()..sqlstr.last() LOOP
4411: hr_utility.trace(sqlstr(cntr));
4412: END LOOP;
4413:
4414: csr := dbms_sql.open_cursor;
4415: dbms_sql.parse (csr,
4416: sqlstr,
4417: sqlstr.first(),
4418: sqlstr.last(),

Line 4415: dbms_sql.parse (csr,

4411: hr_utility.trace(sqlstr(cntr));
4412: END LOOP;
4413:
4414: csr := dbms_sql.open_cursor;
4415: dbms_sql.parse (csr,
4416: sqlstr,
4417: sqlstr.first(),
4418: sqlstr.last(),
4419: false,

Line 4420: dbms_sql.v7);

4416: sqlstr,
4417: sqlstr.first(),
4418: sqlstr.last(),
4419: false,
4420: dbms_sql.v7);
4421: dbms_sql.bind_variable (csr,
4422: ':l_action_context_id',
4423: p_action_context_id);
4424: dbms_sql.bind_variable (csr,

Line 4421: dbms_sql.bind_variable (csr,

4417: sqlstr.first(),
4418: sqlstr.last(),
4419: false,
4420: dbms_sql.v7);
4421: dbms_sql.bind_variable (csr,
4422: ':l_action_context_id',
4423: p_action_context_id);
4424: dbms_sql.bind_variable (csr,
4425: ':l_action_information_id',

Line 4424: dbms_sql.bind_variable (csr,

4420: dbms_sql.v7);
4421: dbms_sql.bind_variable (csr,
4422: ':l_action_context_id',
4423: p_action_context_id);
4424: dbms_sql.bind_variable (csr,
4425: ':l_action_information_id',
4426: p_action_information_id);
4427: ret := dbms_sql.execute(csr);
4428: dbms_sql.close_cursor(csr);

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

4423: p_action_context_id);
4424: dbms_sql.bind_variable (csr,
4425: ':l_action_information_id',
4426: p_action_information_id);
4427: ret := dbms_sql.execute(csr);
4428: dbms_sql.close_cursor(csr);
4429:
4430: IF pay_payroll_xml_extract_pkg.g_xml_table.count() <> 0 THEN
4431: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);

Line 4428: dbms_sql.close_cursor(csr);

4424: dbms_sql.bind_variable (csr,
4425: ':l_action_information_id',
4426: p_action_information_id);
4427: ret := dbms_sql.execute(csr);
4428: dbms_sql.close_cursor(csr);
4429:
4430: IF pay_payroll_xml_extract_pkg.g_xml_table.count() <> 0 THEN
4431: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);
4432: FOR cntr IN pay_payroll_xml_extract_pkg.g_xml_table.first()..pay_payroll_xml_extract_pkg.g_xml_table.last() LOOP