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

Line 231: l_cdl_rowid_tab PA_PLSQL_DATATYPES.RowIdTabTyp;

227: l_NoOfRecordsDel NUMBER;
228: l_MRC_NoOfRecordsDel NUMBER;
229: x_MRC_NoOfRecordsIns NUMBER;
230: l_commit_size NUMBER;
231: l_cdl_rowid_tab PA_PLSQL_DATATYPES.RowIdTabTyp;
232: l_cdl_rowid_tab_empty PA_PLSQL_DATATYPES.RowIdTabTyp;
233: exp_ind NUMBER;
234: l_fetch_complete BOOLEAN := FALSE;
235: cursor cdl_open_projects is

Line 232: l_cdl_rowid_tab_empty PA_PLSQL_DATATYPES.RowIdTabTyp;

228: l_MRC_NoOfRecordsDel NUMBER;
229: x_MRC_NoOfRecordsIns NUMBER;
230: l_commit_size NUMBER;
231: l_cdl_rowid_tab PA_PLSQL_DATATYPES.RowIdTabTyp;
232: l_cdl_rowid_tab_empty PA_PLSQL_DATATYPES.RowIdTabTyp;
233: exp_ind NUMBER;
234: l_fetch_complete BOOLEAN := FALSE;
235: cursor cdl_open_projects is
236: select cdl.rowid

Line 589: l_cc_dist_rowid_tab PA_PLSQL_DATATYPES.RowIdTabTyp;

585: l_MRC_NoOfRecordsDel NUMBER;
586: x_MRC_NoOfRecordsIns NUMBER;
587: l_commit_size NUMBER;
588: /*performance changes starts*/
589: l_cc_dist_rowid_tab PA_PLSQL_DATATYPES.RowIdTabTyp;
590: l_cc_dist_rowid_tab_empty PA_PLSQL_DATATYPES.RowIdTabTyp;
591: exp_ind NUMBER;
592: l_fetch_complete BOOLEAN := FALSE;
593:

Line 590: l_cc_dist_rowid_tab_empty PA_PLSQL_DATATYPES.RowIdTabTyp;

586: x_MRC_NoOfRecordsIns NUMBER;
587: l_commit_size NUMBER;
588: /*performance changes starts*/
589: l_cc_dist_rowid_tab PA_PLSQL_DATATYPES.RowIdTabTyp;
590: l_cc_dist_rowid_tab_empty PA_PLSQL_DATATYPES.RowIdTabTyp;
591: exp_ind NUMBER;
592: l_fetch_complete BOOLEAN := FALSE;
593:
594: cursor c_open_cc_lines is

Line 932: l_exp_comm_rowid_tab PA_PLSQL_DATATYPES.RowIdTabTyp;

928: l_NoOfRecordsIns NUMBER;
929: l_NoOfRecordsDel NUMBER;
930: /*performance changes starts*/
931: l_commit_size NUMBER;
932: l_exp_comm_rowid_tab PA_PLSQL_DATATYPES.RowIdTabTyp;
933: l_exp_comm_rowid_tab_empty PA_PLSQL_DATATYPES.RowIdTabTyp;
934: exp_ind NUMBER;
935: l_fetch_complete BOOLEAN := FALSE;
936:

Line 933: l_exp_comm_rowid_tab_empty PA_PLSQL_DATATYPES.RowIdTabTyp;

929: l_NoOfRecordsDel NUMBER;
930: /*performance changes starts*/
931: l_commit_size NUMBER;
932: l_exp_comm_rowid_tab PA_PLSQL_DATATYPES.RowIdTabTyp;
933: l_exp_comm_rowid_tab_empty PA_PLSQL_DATATYPES.RowIdTabTyp;
934: exp_ind NUMBER;
935: l_fetch_complete BOOLEAN := FALSE;
936:
937: Cursor c_open_exp_comm is

Line 1174: l_exp_adj_rowid_tab PA_PLSQL_DATATYPES.RowIdTabTyp;

1170: l_NoOfRecordsIns NUMBER;
1171: l_NoOfRecordsDel NUMBER;
1172: l_commit_size NUMBER;
1173: /*performance changes starts*/
1174: l_exp_adj_rowid_tab PA_PLSQL_DATATYPES.RowIdTabTyp;
1175: l_exp_adj_rowid_tab_empty PA_PLSQL_DATATYPES.RowIdTabTyp;
1176: exp_ind NUMBER;
1177: l_fetch_complete BOOLEAN := FALSE;
1178:

Line 1175: l_exp_adj_rowid_tab_empty PA_PLSQL_DATATYPES.RowIdTabTyp;

1171: l_NoOfRecordsDel NUMBER;
1172: l_commit_size NUMBER;
1173: /*performance changes starts*/
1174: l_exp_adj_rowid_tab PA_PLSQL_DATATYPES.RowIdTabTyp;
1175: l_exp_adj_rowid_tab_empty PA_PLSQL_DATATYPES.RowIdTabTyp;
1176: exp_ind NUMBER;
1177: l_fetch_complete BOOLEAN := FALSE;
1178:
1179: cursor c_open_exp_adj is

Line 2331: l_ei_rowid_tab PA_PLSQL_DATATYPES.RowIDTabTyp;

2327: l_NoOfRecordsDel NUMBER;
2328: l_MRC_NoOfRecordsDel NUMBER;
2329: x_MRC_NoOfRecordsIns NUMBER;
2330: l_commit_size NUMBER;
2331: l_ei_rowid_tab PA_PLSQL_DATATYPES.RowIDTabTyp;
2332: l_ei_rowid_tab_empty PA_PLSQL_DATATYPES.RowIDTabTyp;
2333: l_fetch_complete BOOLEAN := FALSE;
2334: exp_ind NUMBER;
2335: l_exp_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 2332: l_ei_rowid_tab_empty PA_PLSQL_DATATYPES.RowIDTabTyp;

2328: l_MRC_NoOfRecordsDel NUMBER;
2329: x_MRC_NoOfRecordsIns NUMBER;
2330: l_commit_size NUMBER;
2331: l_ei_rowid_tab PA_PLSQL_DATATYPES.RowIDTabTyp;
2332: l_ei_rowid_tab_empty PA_PLSQL_DATATYPES.RowIDTabTyp;
2333: l_fetch_complete BOOLEAN := FALSE;
2334: exp_ind NUMBER;
2335: l_exp_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2336: l_exp_item_id_tab_empty PA_PLSQL_DATATYPES.IdTabTyp;

Line 2335: l_exp_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

2331: l_ei_rowid_tab PA_PLSQL_DATATYPES.RowIDTabTyp;
2332: l_ei_rowid_tab_empty PA_PLSQL_DATATYPES.RowIDTabTyp;
2333: l_fetch_complete BOOLEAN := FALSE;
2334: exp_ind NUMBER;
2335: l_exp_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2336: l_exp_item_id_tab_empty PA_PLSQL_DATATYPES.IdTabTyp;
2337: l_request_id NUMBER;
2338:
2339: cursor c_exp_open_projects is

Line 2336: l_exp_item_id_tab_empty PA_PLSQL_DATATYPES.IdTabTyp;

2332: l_ei_rowid_tab_empty PA_PLSQL_DATATYPES.RowIDTabTyp;
2333: l_fetch_complete BOOLEAN := FALSE;
2334: exp_ind NUMBER;
2335: l_exp_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2336: l_exp_item_id_tab_empty PA_PLSQL_DATATYPES.IdTabTyp;
2337: l_request_id NUMBER;
2338:
2339: cursor c_exp_open_projects is
2340: select rowid,expenditure_item_id from pa_expenditure_items_all ei

Line 3556: l_exp_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

3552: from pa_expenditure_items_all ei
3553: where ei.transferred_from_exp_item_id is not null
3554: and ei.project_id = p_project_id;
3555:
3556: l_exp_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
3557: l_exp_item_id_tab_emp PA_PLSQL_DATATYPES.IdTabTyp;
3558:
3559: begin
3560:

Line 3557: l_exp_item_id_tab_emp PA_PLSQL_DATATYPES.IdTabTyp;

3553: where ei.transferred_from_exp_item_id is not null
3554: and ei.project_id = p_project_id;
3555:
3556: l_exp_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
3557: l_exp_item_id_tab_emp PA_PLSQL_DATATYPES.IdTabTyp;
3558:
3559: begin
3560:
3561: