eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PAYROLL_XML_EXTRACT_PKG dependencies on DBMS_SQL

Line 499: P_SQLSTR_TAB IN OUT NOCOPY dbms_sql.varchar2s,

495: *****************************************************************************/
496:
497: PROCEDURE BUILD_SQL
498: (
499: P_SQLSTR_TAB IN OUT NOCOPY dbms_sql.varchar2s,
500: P_CNTR IN OUT NOCOPY number,
501: P_STRING varchar2
502: ) AS
503: l_proc_name varchar2(100);

Line 590: sqlstr dbms_sql.varchar2s;

586: AND paa.assignment_action_id=cp_assgn_action_id;
587: lt_per_bgId_value number;
588: /*14105250 -- End*/
589: l_proc_name varchar2(100);
590: sqlstr dbms_sql.varchar2s;
591: l_cntr_sql number;
592: l_xml BLOB;
593: csr number;
594: ret number;

Line 1090: csr := dbms_sql.open_cursor;

1086: FOR cntr IN sqlstr.first()..sqlstr.last() LOOP
1087: hr_utility_trace(sqlstr(cntr));
1088: END LOOP;
1089:
1090: csr := dbms_sql.open_cursor;
1091: dbms_sql.parse (csr,
1092: sqlstr,
1093: sqlstr.first(),
1094: sqlstr.last(),

Line 1091: dbms_sql.parse (csr,

1087: hr_utility_trace(sqlstr(cntr));
1088: END LOOP;
1089:
1090: csr := dbms_sql.open_cursor;
1091: dbms_sql.parse (csr,
1092: sqlstr,
1093: sqlstr.first(),
1094: sqlstr.last(),
1095: false,

Line 1096: dbms_sql.v7);

1092: sqlstr,
1093: sqlstr.first(),
1094: sqlstr.last(),
1095: false,
1096: dbms_sql.v7);
1097: dbms_sql.bind_variable (csr,
1098: ':l_action_context_id',
1099: p_action_context_id);
1100: dbms_sql.bind_variable (csr,

Line 1097: dbms_sql.bind_variable (csr,

1093: sqlstr.first(),
1094: sqlstr.last(),
1095: false,
1096: dbms_sql.v7);
1097: dbms_sql.bind_variable (csr,
1098: ':l_action_context_id',
1099: p_action_context_id);
1100: dbms_sql.bind_variable (csr,
1101: ':l_action_information_id',

Line 1100: dbms_sql.bind_variable (csr,

1096: dbms_sql.v7);
1097: dbms_sql.bind_variable (csr,
1098: ':l_action_context_id',
1099: p_action_context_id);
1100: dbms_sql.bind_variable (csr,
1101: ':l_action_information_id',
1102: p_action_information_id);
1103: ret := dbms_sql.execute(csr);
1104: dbms_sql.close_cursor(csr);

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

1099: p_action_context_id);
1100: dbms_sql.bind_variable (csr,
1101: ':l_action_information_id',
1102: p_action_information_id);
1103: ret := dbms_sql.execute(csr);
1104: dbms_sql.close_cursor(csr);
1105:
1106: IF g_xml_table.count() <> 0 THEN
1107: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);

Line 1104: dbms_sql.close_cursor(csr);

1100: dbms_sql.bind_variable (csr,
1101: ':l_action_information_id',
1102: p_action_information_id);
1103: ret := dbms_sql.execute(csr);
1104: dbms_sql.close_cursor(csr);
1105:
1106: IF g_xml_table.count() <> 0 THEN
1107: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);
1108: FOR cntr IN g_xml_table.first()..g_xml_table.last() LOOP

Line 1335: sqlstr dbms_sql.varchar2s;

1331: filtering undesired ADDRESS DETAILS archived at payroll action
1332: level (action_context_type = 'PA') by the payroll archiver.*/
1333:
1334: l_proc_name varchar2(100);
1335: sqlstr dbms_sql.varchar2s;
1336: l_cntr_sql number;
1337: l_xml BLOB;
1338: csr number;
1339: ret number;

Line 1642: csr := dbms_sql.open_cursor;

1638: hr_utility_trace(sqlstr(cntr));
1639: END LOOP;
1640: hr_utility_trace ('The dyn SQL ends.');
1641:
1642: csr := dbms_sql.open_cursor;
1643: dbms_sql.parse (csr,
1644: sqlstr,
1645: sqlstr.first(),
1646: sqlstr.last(),

Line 1643: dbms_sql.parse (csr,

1639: END LOOP;
1640: hr_utility_trace ('The dyn SQL ends.');
1641:
1642: csr := dbms_sql.open_cursor;
1643: dbms_sql.parse (csr,
1644: sqlstr,
1645: sqlstr.first(),
1646: sqlstr.last(),
1647: false,

Line 1648: dbms_sql.v7);

1644: sqlstr,
1645: sqlstr.first(),
1646: sqlstr.last(),
1647: false,
1648: dbms_sql.v7);
1649:
1650: begin
1651: dbms_sql.bind_variable (csr,
1652: ':l_action_context_id',

Line 1651: dbms_sql.bind_variable (csr,

1647: false,
1648: dbms_sql.v7);
1649:
1650: begin
1651: dbms_sql.bind_variable (csr,
1652: ':l_action_context_id',
1653: p_action_context_id);
1654: dbms_sql.bind_variable (csr,
1655: ':l_pre_payment_id',

Line 1654: dbms_sql.bind_variable (csr,

1650: begin
1651: dbms_sql.bind_variable (csr,
1652: ':l_action_context_id',
1653: p_action_context_id);
1654: dbms_sql.bind_variable (csr,
1655: ':l_pre_payment_id',
1656: p_pre_payment_id);
1657: exception when others then hr_utility_trace('exception in binding variables, procedure generate third party.'); end;
1658: ret := dbms_sql.execute(csr);

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

1654: dbms_sql.bind_variable (csr,
1655: ':l_pre_payment_id',
1656: p_pre_payment_id);
1657: exception when others then hr_utility_trace('exception in binding variables, procedure generate third party.'); end;
1658: ret := dbms_sql.execute(csr);
1659: dbms_sql.close_cursor(csr);
1660:
1661: IF g_xml_table.count() <> 0 THEN
1662: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);

Line 1659: dbms_sql.close_cursor(csr);

1655: ':l_pre_payment_id',
1656: p_pre_payment_id);
1657: exception when others then hr_utility_trace('exception in binding variables, procedure generate third party.'); end;
1658: ret := dbms_sql.execute(csr);
1659: dbms_sql.close_cursor(csr);
1660:
1661: IF g_xml_table.count() <> 0 THEN
1662: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);
1663: FOR cntr IN g_xml_table.first()..g_xml_table.last() LOOP