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

Line 3069: l_start_mr_tbl dbms_sql.varchar2_table;

3065:
3066: l_upd_ue_cnt NUMBER;
3067: l_add_ue_cnt NUMBER;
3068:
3069: l_start_mr_tbl dbms_sql.varchar2_table;
3070: l_csi_ii_tbl dbms_sql.number_table;
3071:
3072: l_old_start_lc_ue_tbl dbms_sql.number_table;
3073: l_old_loop_seq_tbl dbms_sql.number_table;

Line 3070: l_csi_ii_tbl dbms_sql.number_table;

3066: l_upd_ue_cnt NUMBER;
3067: l_add_ue_cnt NUMBER;
3068:
3069: l_start_mr_tbl dbms_sql.varchar2_table;
3070: l_csi_ii_tbl dbms_sql.number_table;
3071:
3072: l_old_start_lc_ue_tbl dbms_sql.number_table;
3073: l_old_loop_seq_tbl dbms_sql.number_table;
3074: l_old_mr_title dbms_sql.varchar2_table;

Line 3072: l_old_start_lc_ue_tbl dbms_sql.number_table;

3068:
3069: l_start_mr_tbl dbms_sql.varchar2_table;
3070: l_csi_ii_tbl dbms_sql.number_table;
3071:
3072: l_old_start_lc_ue_tbl dbms_sql.number_table;
3073: l_old_loop_seq_tbl dbms_sql.number_table;
3074: l_old_mr_title dbms_sql.varchar2_table;
3075: l_match_tbl dbms_sql.varchar2_table;
3076:

Line 3073: l_old_loop_seq_tbl dbms_sql.number_table;

3069: l_start_mr_tbl dbms_sql.varchar2_table;
3070: l_csi_ii_tbl dbms_sql.number_table;
3071:
3072: l_old_start_lc_ue_tbl dbms_sql.number_table;
3073: l_old_loop_seq_tbl dbms_sql.number_table;
3074: l_old_mr_title dbms_sql.varchar2_table;
3075: l_match_tbl dbms_sql.varchar2_table;
3076:
3077: --l_start_lc_ue_tbl nbr_tbl_type;

Line 3074: l_old_mr_title dbms_sql.varchar2_table;

3070: l_csi_ii_tbl dbms_sql.number_table;
3071:
3072: l_old_start_lc_ue_tbl dbms_sql.number_table;
3073: l_old_loop_seq_tbl dbms_sql.number_table;
3074: l_old_mr_title dbms_sql.varchar2_table;
3075: l_match_tbl dbms_sql.varchar2_table;
3076:
3077: --l_start_lc_ue_tbl nbr_tbl_type;
3078:

Line 3075: l_match_tbl dbms_sql.varchar2_table;

3071:
3072: l_old_start_lc_ue_tbl dbms_sql.number_table;
3073: l_old_loop_seq_tbl dbms_sql.number_table;
3074: l_old_mr_title dbms_sql.varchar2_table;
3075: l_match_tbl dbms_sql.varchar2_table;
3076:
3077: --l_start_lc_ue_tbl nbr_tbl_type;
3078:
3079: l_old_start_lc_ue_seq NUMBER;

Line 3085: l_ue_id_tbl dbms_sql.number_table;

3081:
3082: l_min_due_date DATE;
3083: l_min_ue_id NUMBER;
3084:
3085: l_ue_id_tbl dbms_sql.number_table;
3086: l_ue_id1_tbl dbms_sql.number_table;
3087:
3088: type rowidArray IS TABLE OF rowid index by binary_integer;
3089: l_rowid rowidArray;

Line 3086: l_ue_id1_tbl dbms_sql.number_table;

3082: l_min_due_date DATE;
3083: l_min_ue_id NUMBER;
3084:
3085: l_ue_id_tbl dbms_sql.number_table;
3086: l_ue_id1_tbl dbms_sql.number_table;
3087:
3088: type rowidArray IS TABLE OF rowid index by binary_integer;
3089: l_rowid rowidArray;
3090: l_index number;

Line 3469: l_start_mr_tbl dbms_sql.varchar2_table;

3465:
3466: l_upd_ue_cnt NUMBER;
3467: l_add_ue_cnt NUMBER;
3468:
3469: l_start_mr_tbl dbms_sql.varchar2_table;
3470: l_csi_ii_tbl dbms_sql.number_table;
3471:
3472: l_old_start_lc_ue_tbl dbms_sql.number_table;
3473: l_old_loop_seq_tbl dbms_sql.number_table;

Line 3470: l_csi_ii_tbl dbms_sql.number_table;

3466: l_upd_ue_cnt NUMBER;
3467: l_add_ue_cnt NUMBER;
3468:
3469: l_start_mr_tbl dbms_sql.varchar2_table;
3470: l_csi_ii_tbl dbms_sql.number_table;
3471:
3472: l_old_start_lc_ue_tbl dbms_sql.number_table;
3473: l_old_loop_seq_tbl dbms_sql.number_table;
3474: l_old_mr_title dbms_sql.varchar2_table;

Line 3472: l_old_start_lc_ue_tbl dbms_sql.number_table;

3468:
3469: l_start_mr_tbl dbms_sql.varchar2_table;
3470: l_csi_ii_tbl dbms_sql.number_table;
3471:
3472: l_old_start_lc_ue_tbl dbms_sql.number_table;
3473: l_old_loop_seq_tbl dbms_sql.number_table;
3474: l_old_mr_title dbms_sql.varchar2_table;
3475: l_match_tbl dbms_sql.varchar2_table;
3476:

Line 3473: l_old_loop_seq_tbl dbms_sql.number_table;

3469: l_start_mr_tbl dbms_sql.varchar2_table;
3470: l_csi_ii_tbl dbms_sql.number_table;
3471:
3472: l_old_start_lc_ue_tbl dbms_sql.number_table;
3473: l_old_loop_seq_tbl dbms_sql.number_table;
3474: l_old_mr_title dbms_sql.varchar2_table;
3475: l_match_tbl dbms_sql.varchar2_table;
3476:
3477: --l_start_lc_ue_tbl nbr_tbl_type;

Line 3474: l_old_mr_title dbms_sql.varchar2_table;

3470: l_csi_ii_tbl dbms_sql.number_table;
3471:
3472: l_old_start_lc_ue_tbl dbms_sql.number_table;
3473: l_old_loop_seq_tbl dbms_sql.number_table;
3474: l_old_mr_title dbms_sql.varchar2_table;
3475: l_match_tbl dbms_sql.varchar2_table;
3476:
3477: --l_start_lc_ue_tbl nbr_tbl_type;
3478:

Line 3475: l_match_tbl dbms_sql.varchar2_table;

3471:
3472: l_old_start_lc_ue_tbl dbms_sql.number_table;
3473: l_old_loop_seq_tbl dbms_sql.number_table;
3474: l_old_mr_title dbms_sql.varchar2_table;
3475: l_match_tbl dbms_sql.varchar2_table;
3476:
3477: --l_start_lc_ue_tbl nbr_tbl_type;
3478:
3479: l_old_start_lc_ue_seq NUMBER;

Line 3485: l_ue_id_tbl dbms_sql.number_table;

3481:
3482: l_min_due_date DATE;
3483: l_min_ue_id NUMBER;
3484:
3485: l_ue_id_tbl dbms_sql.number_table;
3486: l_ue_id1_tbl dbms_sql.number_table;
3487:
3488: type rowidArray IS TABLE OF rowid index by binary_integer;
3489: l_rowid rowidArray;

Line 3486: l_ue_id1_tbl dbms_sql.number_table;

3482: l_min_due_date DATE;
3483: l_min_ue_id NUMBER;
3484:
3485: l_ue_id_tbl dbms_sql.number_table;
3486: l_ue_id1_tbl dbms_sql.number_table;
3487:
3488: type rowidArray IS TABLE OF rowid index by binary_integer;
3489: l_rowid rowidArray;
3490: l_index number;

Line 3493: l_get_start_ue_tbl dbms_sql.number_table;

3489: l_rowid rowidArray;
3490: l_index number;
3491: l_loop_1_start_lc_ue_id number;
3492: l_chain_start_ue_id number;
3493: l_get_start_ue_tbl dbms_sql.number_table;
3494:
3495: BEGIN
3496: l_upd_ue_cnt := 0;
3497: l_add_ue_cnt := 0;