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.HR_DATA_PUMP dependencies on DBMS_SQL

Line 73: * for DBMS_SQL cursors. It is now used to cache the

69:
70: /*
71: * The following data structure holds information for
72: * the API wrapper modules. This was primarily a cache
73: * for DBMS_SQL cursors. It is now used to cache the
74: * SQL call string.
75: * Note that in this first version, no upper limit is
76: * being put on the size of the cache.
77: * This might need alteration in future versions.

Line 1337: (p_failed_lines in dbms_sql.number_table

1333: * UPDATE HR_PUMP_BATCH_LINES LINE_STATUS.
1334: * INSERT rows into HR_PUMP_BATCH_EXCEPTIONS.
1335: */
1336: procedure update_range_results
1337: (p_failed_lines in dbms_sql.number_table
1338: ,p_exc_ids in dbms_sql.number_table
1339: ,p_exc_text in dbms_sql.varchar2_table
1340: ,p_ls_ids in dbms_sql.number_table
1341: ,p_ls_statuses in dbms_sql.varchar2s

Line 1338: ,p_exc_ids in dbms_sql.number_table

1334: * INSERT rows into HR_PUMP_BATCH_EXCEPTIONS.
1335: */
1336: procedure update_range_results
1337: (p_failed_lines in dbms_sql.number_table
1338: ,p_exc_ids in dbms_sql.number_table
1339: ,p_exc_text in dbms_sql.varchar2_table
1340: ,p_ls_ids in dbms_sql.number_table
1341: ,p_ls_statuses in dbms_sql.varchar2s
1342: ) is

Line 1339: ,p_exc_text in dbms_sql.varchar2_table

1335: */
1336: procedure update_range_results
1337: (p_failed_lines in dbms_sql.number_table
1338: ,p_exc_ids in dbms_sql.number_table
1339: ,p_exc_text in dbms_sql.varchar2_table
1340: ,p_ls_ids in dbms_sql.number_table
1341: ,p_ls_statuses in dbms_sql.varchar2s
1342: ) is
1343: lbound binary_integer;

Line 1340: ,p_ls_ids in dbms_sql.number_table

1336: procedure update_range_results
1337: (p_failed_lines in dbms_sql.number_table
1338: ,p_exc_ids in dbms_sql.number_table
1339: ,p_exc_text in dbms_sql.varchar2_table
1340: ,p_ls_ids in dbms_sql.number_table
1341: ,p_ls_statuses in dbms_sql.varchar2s
1342: ) is
1343: lbound binary_integer;
1344: ubound binary_integer;

Line 1341: ,p_ls_statuses in dbms_sql.varchar2s

1337: (p_failed_lines in dbms_sql.number_table
1338: ,p_exc_ids in dbms_sql.number_table
1339: ,p_exc_text in dbms_sql.varchar2_table
1340: ,p_ls_ids in dbms_sql.number_table
1341: ,p_ls_statuses in dbms_sql.varchar2s
1342: ) is
1343: lbound binary_integer;
1344: ubound binary_integer;
1345: nrows binary_integer;

Line 1425: ,p_exc_ids in out nocopy dbms_sql.number_table

1421: (p_multi_msg_error in boolean
1422: ,p_module_package in varchar2
1423: ,p_module_name in varchar2
1424: ,p_batch_line_id in number
1425: ,p_exc_ids in out nocopy dbms_sql.number_table
1426: ,p_exc_text in out nocopy dbms_sql.varchar2_table
1427: ) is
1428: l_message varchar2(4000);
1429: l_msg_index number;

Line 1426: ,p_exc_text in out nocopy dbms_sql.varchar2_table

1422: ,p_module_package in varchar2
1423: ,p_module_name in varchar2
1424: ,p_batch_line_id in number
1425: ,p_exc_ids in out nocopy dbms_sql.number_table
1426: ,p_exc_text in out nocopy dbms_sql.varchar2_table
1427: ) is
1428: l_message varchar2(4000);
1429: l_msg_index number;
1430: l_which_msg number := fnd_msg_pub.g_first;

Line 1542: l_failed_lines dbms_sql.number_table;

1538: --
1539: -- List of HR_PUMP_BATCH_LINES rows previously in error. This is
1540: -- used to delete existing exception lines.
1541: --
1542: l_failed_lines dbms_sql.number_table;
1543:
1544: --
1545: -- Exceptions list. This is used to update HR_PUMP_BATCH_EXCEPTIONS.
1546: --

Line 1547: l_exc_ids dbms_sql.number_table;

1543:
1544: --
1545: -- Exceptions list. This is used to update HR_PUMP_BATCH_EXCEPTIONS.
1546: --
1547: l_exc_ids dbms_sql.number_table;
1548: l_exc_text dbms_sql.varchar2_table;
1549:
1550: --
1551: -- List for holding HR_PUMP_BATCH_LINES LINE_STATUS. This is used

Line 1548: l_exc_text dbms_sql.varchar2_table;

1544: --
1545: -- Exceptions list. This is used to update HR_PUMP_BATCH_EXCEPTIONS.
1546: --
1547: l_exc_ids dbms_sql.number_table;
1548: l_exc_text dbms_sql.varchar2_table;
1549:
1550: --
1551: -- List for holding HR_PUMP_BATCH_LINES LINE_STATUS. This is used
1552: -- to update the LINE_STATUS column.

Line 1554: l_ls_statuses dbms_sql.varchar2s;

1550: --
1551: -- List for holding HR_PUMP_BATCH_LINES LINE_STATUS. This is used
1552: -- to update the LINE_STATUS column.
1553: --
1554: l_ls_statuses dbms_sql.varchar2s;
1555: l_ls_ids dbms_sql.number_table;
1556: l_ls_link_start number;
1557: l_ls_pos number;
1558:

Line 1555: l_ls_ids dbms_sql.number_table;

1551: -- List for holding HR_PUMP_BATCH_LINES LINE_STATUS. This is used
1552: -- to update the LINE_STATUS column.
1553: --
1554: l_ls_statuses dbms_sql.varchar2s;
1555: l_ls_ids dbms_sql.number_table;
1556: l_ls_link_start number;
1557: l_ls_pos number;
1558:
1559: --