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.PAAPIMP_PKG dependencies on PA_PLSQL_DATATYPES

Line 4002: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;

3998: l_project_id NUMBER :=0;
3999: l_pa_addflag VARCHAR2(1):=NULL;
4000: l_prev_proj_id NUMBER :=0;
4001:
4002: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
4003: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
4004: -- l_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp; --NEW
4005: -- l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
4006: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp; --NEW --check with Ajay if its declared as number type

Line 4003: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;

3999: l_pa_addflag VARCHAR2(1):=NULL;
4000: l_prev_proj_id NUMBER :=0;
4001:
4002: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
4003: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
4004: -- l_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp; --NEW
4005: -- l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
4006: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp; --NEW --check with Ajay if its declared as number type
4007: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 4004: -- l_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp; --NEW

4000: l_prev_proj_id NUMBER :=0;
4001:
4002: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
4003: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
4004: -- l_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp; --NEW
4005: -- l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
4006: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp; --NEW --check with Ajay if its declared as number type
4007: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
4008: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;

Line 4005: -- l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;

4001:
4002: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
4003: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
4004: -- l_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp; --NEW
4005: -- l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
4006: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp; --NEW --check with Ajay if its declared as number type
4007: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
4008: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
4009: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 4006: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp; --NEW --check with Ajay if its declared as number type

4002: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
4003: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
4004: -- l_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp; --NEW
4005: -- l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
4006: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp; --NEW --check with Ajay if its declared as number type
4007: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
4008: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
4009: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
4010: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;

Line 4007: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

4003: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
4004: -- l_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp; --NEW
4005: -- l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
4006: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp; --NEW --check with Ajay if its declared as number type
4007: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
4008: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
4009: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
4010: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
4011: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 4008: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;

4004: -- l_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp; --NEW
4005: -- l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
4006: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp; --NEW --check with Ajay if its declared as number type
4007: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
4008: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
4009: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
4010: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
4011: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
4012: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;

Line 4009: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

4005: -- l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
4006: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp; --NEW --check with Ajay if its declared as number type
4007: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
4008: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
4009: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
4010: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
4011: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
4012: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
4013: l_assets_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;

Line 4010: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;

4006: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp; --NEW --check with Ajay if its declared as number type
4007: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
4008: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
4009: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
4010: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
4011: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
4012: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
4013: l_assets_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
4014:

Line 4011: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

4007: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
4008: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
4009: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
4010: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
4011: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
4012: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
4013: l_assets_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
4014:
4015: CURSOR txn_intf_rec (p_txn_src IN VARCHAR2,

Line 4012: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;

4008: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
4009: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
4010: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
4011: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
4012: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
4013: l_assets_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
4014:
4015: CURSOR txn_intf_rec (p_txn_src IN VARCHAR2,
4016: p_batch_name IN VARCHAR2,

Line 4013: l_assets_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;

4009: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
4010: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
4011: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
4012: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
4013: l_assets_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
4014:
4015: CURSOR txn_intf_rec (p_txn_src IN VARCHAR2,
4016: p_batch_name IN VARCHAR2,
4017: p_interface_id IN NUMBER) IS

Line 7077: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;

7073:
7074: l_pa_addflag VARCHAR2(1):=NULL;
7075: l_rows_tiebacked NUMBER :=0;
7076:
7077: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7078: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7079: l_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7080: l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7081: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 7078: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;

7074: l_pa_addflag VARCHAR2(1):=NULL;
7075: l_rows_tiebacked NUMBER :=0;
7076:
7077: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7078: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7079: l_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7080: l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7081: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7082: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;

Line 7079: l_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp;

7075: l_rows_tiebacked NUMBER :=0;
7076:
7077: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7078: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7079: l_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7080: l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7081: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7082: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
7083: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 7080: l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;

7076:
7077: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7078: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7079: l_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7080: l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7081: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7082: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
7083: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
7084: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;

Line 7081: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

7077: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7078: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7079: l_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7080: l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7081: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7082: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
7083: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
7084: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
7085: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 7082: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;

7078: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7079: l_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7080: l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7081: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7082: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
7083: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
7084: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
7085: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
7086: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;

Line 7083: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

7079: l_sys_ref3_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7080: l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7081: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7082: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
7083: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
7084: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
7085: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
7086: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
7087: l_rcv_acct_evt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes

Line 7084: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;

7080: l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
7081: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7082: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
7083: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
7084: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
7085: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
7086: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
7087: l_rcv_acct_evt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
7088: l_dr_ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes

Line 7085: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

7081: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7082: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
7083: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
7084: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
7085: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
7086: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
7087: l_rcv_acct_evt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
7088: l_dr_ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
7089:

Line 7086: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;

7082: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
7083: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
7084: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
7085: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
7086: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
7087: l_rcv_acct_evt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
7088: l_dr_ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
7089:
7090: CURSOR txn_intf_rec (p_txn_src IN VARCHAR2,

Line 7087: l_rcv_acct_evt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes

7083: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
7084: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
7085: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
7086: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
7087: l_rcv_acct_evt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
7088: l_dr_ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
7089:
7090: CURSOR txn_intf_rec (p_txn_src IN VARCHAR2,
7091: p_batch_name IN VARCHAR2,

Line 7088: l_dr_ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes

7084: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
7085: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
7086: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
7087: l_rcv_acct_evt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
7088: l_dr_ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
7089:
7090: CURSOR txn_intf_rec (p_txn_src IN VARCHAR2,
7091: p_batch_name IN VARCHAR2,
7092: p_interface_id IN NUMBER) IS

Line 8482: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;

8478: l_project_id NUMBER :=0;
8479: l_pa_addflag VARCHAR2(1):=NULL;
8480: l_prev_proj_id NUMBER :=0;
8481:
8482: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
8483: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
8484: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp; --confirm if this is number type in interface table
8485: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8486: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;

Line 8483: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;

8479: l_pa_addflag VARCHAR2(1):=NULL;
8480: l_prev_proj_id NUMBER :=0;
8481:
8482: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
8483: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
8484: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp; --confirm if this is number type in interface table
8485: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8486: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
8487: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 8484: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp; --confirm if this is number type in interface table

8480: l_prev_proj_id NUMBER :=0;
8481:
8482: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
8483: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
8484: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp; --confirm if this is number type in interface table
8485: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8486: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
8487: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
8488: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;

Line 8485: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

8481:
8482: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
8483: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
8484: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp; --confirm if this is number type in interface table
8485: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8486: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
8487: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
8488: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
8489: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 8486: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;

8482: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
8483: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
8484: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp; --confirm if this is number type in interface table
8485: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8486: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
8487: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
8488: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
8489: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
8490: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;

Line 8487: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

8483: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
8484: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp; --confirm if this is number type in interface table
8485: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8486: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
8487: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
8488: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
8489: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
8490: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
8491: l_assets_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;

Line 8488: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;

8484: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp; --confirm if this is number type in interface table
8485: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8486: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
8487: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
8488: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
8489: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
8490: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
8491: l_assets_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
8492:

Line 8489: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

8485: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8486: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
8487: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
8488: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
8489: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
8490: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
8491: l_assets_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
8492:
8493: CURSOR txn_intf_rec (p_txn_src IN VARCHAR2,

Line 8490: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;

8486: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
8487: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
8488: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
8489: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
8490: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
8491: l_assets_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
8492:
8493: CURSOR txn_intf_rec (p_txn_src IN VARCHAR2,
8494: p_batch_name IN VARCHAR2,

Line 8491: l_assets_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;

8487: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
8488: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
8489: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
8490: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
8491: l_assets_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
8492:
8493: CURSOR txn_intf_rec (p_txn_src IN VARCHAR2,
8494: p_batch_name IN VARCHAR2,
8495: p_interface_id IN NUMBER) IS

Line 10771: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;

10767: l_project_id NUMBER :=0;
10768: l_pa_addflag VARCHAR2(1):=NULL;
10769: l_prev_proj_id NUMBER :=0;
10770:
10771: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
10772: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
10773: l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
10774: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp;
10775: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 10772: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;

10768: l_pa_addflag VARCHAR2(1):=NULL;
10769: l_prev_proj_id NUMBER :=0;
10770:
10771: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
10772: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
10773: l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
10774: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp;
10775: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
10776: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;

Line 10773: l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;

10769: l_prev_proj_id NUMBER :=0;
10770:
10771: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
10772: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
10773: l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
10774: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp;
10775: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
10776: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
10777: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 10774: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp;

10770:
10771: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
10772: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
10773: l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
10774: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp;
10775: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
10776: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
10777: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
10778: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;

Line 10775: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

10771: l_sys_ref1_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
10772: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
10773: l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
10774: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp;
10775: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
10776: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
10777: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
10778: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
10779: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 10776: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;

10772: l_sys_ref2_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
10773: l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
10774: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp;
10775: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
10776: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
10777: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
10778: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
10779: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
10780: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;

Line 10777: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

10773: l_sys_ref4_tbl PA_PLSQL_DATATYPES.Char15TabTyp;
10774: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp;
10775: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
10776: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
10777: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
10778: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
10779: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
10780: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
10781: l_assets_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;

Line 10778: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;

10774: l_sys_ref5_tbl PA_PLSQL_DATATYPES.IdTabTyp;
10775: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
10776: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
10777: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
10778: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
10779: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
10780: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
10781: l_assets_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
10782:

Line 10779: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

10775: l_txn_src_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
10776: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
10777: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
10778: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
10779: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
10780: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
10781: l_assets_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
10782:
10783: CURSOR txn_intf_rec (p_txn_src IN VARCHAR2,

Line 10780: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;

10776: l_batch_name_tbl PA_PLSQL_DATATYPES.Char50TabTyp;
10777: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
10778: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
10779: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
10780: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
10781: l_assets_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
10782:
10783: CURSOR txn_intf_rec (p_txn_src IN VARCHAR2,
10784: p_batch_name IN VARCHAR2,

Line 10781: l_assets_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;

10777: l_interface_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
10778: l_txn_status_code_tbl PA_PLSQL_DATATYPES.Char2TabTyp;
10779: l_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
10780: l_pa_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
10781: l_assets_addflag_tbl PA_PLSQL_DATATYPES.CHAR1TabTyp;
10782:
10783: CURSOR txn_intf_rec (p_txn_src IN VARCHAR2,
10784: p_batch_name IN VARCHAR2,
10785: p_interface_id IN NUMBER) IS