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_EXPEND_ITEM_ADJ_ACTIVITIES

Line 1182: pa_expend_item_adj_activities eia1

1178:
1179: cursor c_open_exp_adj is
1180: Select eia1.rowid
1181: from pa_expenditure_items_all ei,
1182: pa_expend_item_adj_activities eia1
1183: where ei.expenditure_item_date <= p_txn_to_date
1184: and ei.expenditure_item_id = eia1.expenditure_item_id
1185: and ei.project_id = p_project_id;
1186:

Line 1190: pa_expend_item_adj_activities eia1

1186:
1187: cursor c_close_exp_adj is
1188: Select eia1.rowid
1189: from pa_expenditure_items_all ei,
1190: pa_expend_item_adj_activities eia1
1191: where ei.expenditure_item_id = eia1.expenditure_item_id
1192: and ei.project_id = p_project_id;
1193:
1194: begin

Line 1278: from pa_expend_item_adj_activities eia

1274: eia.program_update_date,
1275: p_purge_batch_id,
1276: p_purge_release,
1277: p_project_id
1278: from pa_expend_item_adj_activities eia
1279: where eia.rowid = l_exp_adj_rowid_tab(exp_ind);
1280: End If; /* if p_archive_flag = 'Y' */
1281: l_NoOfRecordsIns := SQL%ROWCOUNT ;
1282:

Line 1284: x_err_stage := 'PA_ExpendItemAdjActivities: Before deleting records from pa_expend_item_adj_activities' ;

1280: End If; /* if p_archive_flag = 'Y' */
1281: l_NoOfRecordsIns := SQL%ROWCOUNT ;
1282:
1283:
1284: x_err_stage := 'PA_ExpendItemAdjActivities: Before deleting records from pa_expend_item_adj_activities' ;
1285:
1286: FORALL exp_ind IN l_exp_adj_rowid_tab.FIRST .. l_exp_adj_rowid_tab.LAST
1287: DELETE from pa_expend_item_adj_activities eia
1288: where eia.rowid = l_exp_adj_rowid_tab(exp_ind);

Line 1287: DELETE from pa_expend_item_adj_activities eia

1283:
1284: x_err_stage := 'PA_ExpendItemAdjActivities: Before deleting records from pa_expend_item_adj_activities' ;
1285:
1286: FORALL exp_ind IN l_exp_adj_rowid_tab.FIRST .. l_exp_adj_rowid_tab.LAST
1287: DELETE from pa_expend_item_adj_activities eia
1288: where eia.rowid = l_exp_adj_rowid_tab(exp_ind);
1289:
1290: l_NoOfRecordsDel := SQL%ROWCOUNT;
1291: /*s22 start of comment for performance changes

Line 1294: pa_expend_item_adj_activities eia1

1290: l_NoOfRecordsDel := SQL%ROWCOUNT;
1291: /*s22 start of comment for performance changes
1292: ( select eia1.rowid
1293: from pa_expenditure_items_all ei,
1294: pa_expend_item_adj_activities eia1
1295: where ei.expenditure_item_date <= p_txn_to_date
1296: and ei.expenditure_item_id = eia1.expenditure_item_id
1297: and ei.project_id = p_project_id
1298: and rownum < p_commit_size

Line 1339: from pa_expend_item_adj_activities eia

1335: eia.program_update_date,
1336: p_purge_batch_id,
1337: p_purge_release,
1338: p_project_id
1339: from pa_expend_item_adj_activities eia
1340: where (eia.rowid ) in
1341: ( select eia1.rowid
1342: from pa_expenditure_items_all ei,
1343: pa_expend_item_adj_activities eia1

Line 1343: pa_expend_item_adj_activities eia1

1339: from pa_expend_item_adj_activities eia
1340: where (eia.rowid ) in
1341: ( select eia1.rowid
1342: from pa_expenditure_items_all ei,
1343: pa_expend_item_adj_activities eia1
1344: where ei.expenditure_item_id = eia1.expenditure_item_id
1345: and ei.project_id = p_project_id
1346: and rownum < p_commit_size
1347: ) ;

Line 1358: x_err_stage := 'PA_ExpendItemAdjActivities: Before deleting records from pa_expend_item_adj_activities';

1354: -- selected because if archive option is selected the the records
1355: -- being purged will be those records which are already archived.
1356: -- table and
1357:
1358: x_err_stage := 'PA_ExpendItemAdjActivities: Before deleting records from pa_expend_item_adj_activities';
1359: delete from pa_expend_item_adj_activities eia
1360: where (eia.expenditure_item_id, eia.activity_date ) in
1361: ( select eiar.expenditure_item_id, eiar.activity_date
1362: from PA_EXP_ITEM_ADJ_ACT_AR eiar

Line 1359: delete from pa_expend_item_adj_activities eia

1355: -- being purged will be those records which are already archived.
1356: -- table and
1357:
1358: x_err_stage := 'PA_ExpendItemAdjActivities: Before deleting records from pa_expend_item_adj_activities';
1359: delete from pa_expend_item_adj_activities eia
1360: where (eia.expenditure_item_id, eia.activity_date ) in
1361: ( select eiar.expenditure_item_id, eiar.activity_date
1362: from PA_EXP_ITEM_ADJ_ACT_AR eiar
1363: where eiar.purge_project_id = p_project_id

Line 1375: x_err_stage := 'PA_ExpendItemAdjActivities: Before deleting records from pa_expend_item_adj_activities' ;

1371:
1372: -- If the archive option is not selected then the delete will
1373: -- be based on the commit size.
1374:
1375: x_err_stage := 'PA_ExpendItemAdjActivities: Before deleting records from pa_expend_item_adj_activities' ;
1376: if p_txn_to_date is NOT NULL then
1377: delete from pa_expend_item_adj_activities eia
1378: where (eia.rowid ) in
1379: ( select eia1.rowid

Line 1377: delete from pa_expend_item_adj_activities eia

1373: -- be based on the commit size.
1374:
1375: x_err_stage := 'PA_ExpendItemAdjActivities: Before deleting records from pa_expend_item_adj_activities' ;
1376: if p_txn_to_date is NOT NULL then
1377: delete from pa_expend_item_adj_activities eia
1378: where (eia.rowid ) in
1379: ( select eia1.rowid
1380: from pa_expenditure_items_all ei,
1381: pa_expend_item_adj_activities eia1

Line 1381: pa_expend_item_adj_activities eia1

1377: delete from pa_expend_item_adj_activities eia
1378: where (eia.rowid ) in
1379: ( select eia1.rowid
1380: from pa_expenditure_items_all ei,
1381: pa_expend_item_adj_activities eia1
1382: where ei.expenditure_item_date <= p_txn_to_date
1383: and ei.expenditure_item_id = eia1.expenditure_item_id
1384: and ei.project_id = p_project_id
1385: and rownum < p_commit_size

Line 1389: delete from pa_expend_item_adj_activities eia

1385: and rownum < p_commit_size
1386: ) ;
1387:
1388: else
1389: delete from pa_expend_item_adj_activities eia
1390: where (eia.rowid ) in
1391: ( select eia1.rowid
1392: from pa_expenditure_items_all ei,
1393: pa_expend_item_adj_activities eia1

Line 1393: pa_expend_item_adj_activities eia1

1389: delete from pa_expend_item_adj_activities eia
1390: where (eia.rowid ) in
1391: ( select eia1.rowid
1392: from pa_expenditure_items_all ei,
1393: pa_expend_item_adj_activities eia1
1394: where ei.expenditure_item_id = eia1.expenditure_item_id
1395: and ei.project_id = p_project_id
1396: and rownum < p_commit_size
1397: ) ;

Line 1423: 'PA_EXPEND_ITEM_ADJ_ACTIVITIES',

1419: x_err_stage := 'PA_ExpendItemAdjActivities: Commiting the transaction' ;
1420: If l_NoOfRecordsDel > 0 Then
1421: Pa_Purge.CommitProcess(p_purge_batch_id,
1422: p_project_id,
1423: 'PA_EXPEND_ITEM_ADJ_ACTIVITIES',
1424: l_NoOfRecordsIns,
1425: l_NoOfRecordsDel,
1426: x_err_code,
1427: x_err_stack,

Line 2832: insert into Pa_Expend_item_Adj_Activities

2828: into l_request_id
2829: from dual ;
2830:
2831: FORALL exp_ind IN l_exp_item_id_tab.FIRST .. l_exp_item_id_tab.LAST
2832: insert into Pa_Expend_item_Adj_Activities
2833: ( expenditure_item_id,
2834: activity_date,
2835: last_update_date,
2836: last_updated_by,

Line 2985: x_err_stage := 'PA_ExpItemsSrcPurge: Before inserting audit records into Pa_Expend_item_Adj_Activities';

2981: Select Pa_Expend_Item_Adj_Act_s.nextval
2982: into l_request_id
2983: from dual ;
2984: -- l_request_id := Pa_Expend_Item_Adj_Act_s.nextval ;
2985: x_err_stage := 'PA_ExpItemsSrcPurge: Before inserting audit records into Pa_Expend_item_Adj_Activities';
2986: if p_txn_to_date is NOT NULL then
2987: insert into Pa_Expend_item_Adj_Activities
2988: ( expenditure_item_id,
2989: activity_date,

Line 2987: insert into Pa_Expend_item_Adj_Activities

2983: from dual ;
2984: -- l_request_id := Pa_Expend_Item_Adj_Act_s.nextval ;
2985: x_err_stage := 'PA_ExpItemsSrcPurge: Before inserting audit records into Pa_Expend_item_Adj_Activities';
2986: if p_txn_to_date is NOT NULL then
2987: insert into Pa_Expend_item_Adj_Activities
2988: ( expenditure_item_id,
2989: activity_date,
2990: last_update_date,
2991: last_updated_by,

Line 3021: insert into Pa_Expend_item_Adj_Activities

3017: from pa_purge_projects pp
3018: where pp.project_id = ei.project_id
3019: and pp.purge_batch_id = p_purge_batch_id ) ;
3020: else
3021: insert into Pa_Expend_item_Adj_Activities
3022: ( expenditure_item_id,
3023: activity_date,
3024: last_update_date,
3025: last_updated_by,

Line 3448: from Pa_Expend_item_Adj_Activities eia,

3444: ei.posted_acct_burdened_cost,
3445: ei.adjustment_type
3446: from pa_expenditure_items_all ei
3447: where ei.expenditure_item_id in ( select ei1.transferred_from_exp_item_id
3448: from Pa_Expend_item_Adj_Activities eia,
3449: pa_expenditure_items_all ei1
3450: where ei1.expenditure_item_id = eia.expenditure_item_id
3451: and eia.request_id = l_request_id
3452: and eia.exception_activity_code= 'SOURCE PURGED'

Line 3463: from Pa_Expend_item_Adj_Activities eia,

3459:
3460: x_err_stage := 'PA_ExpItemsSrcPurge: Deleting records into pa_expenditure_items_all';
3461: delete from pa_expenditure_items_all ei
3462: where ei.expenditure_item_id in ( select ei1.transferred_from_exp_item_id
3463: from Pa_Expend_item_Adj_Activities eia,
3464: pa_expenditure_items_all ei1
3465: where ei1.expenditure_item_id = eia.expenditure_item_id
3466: and eia.request_id = l_request_id
3467: and eia.exception_activity_code= 'SOURCE PURGED'

Line 3478: from Pa_Expend_item_Adj_Activities eia

3474: x_err_stage := 'PA_ExpItemsSrcPurge: Deleting the links between expenditure items' ;
3475: update pa_expenditure_items_all ei
3476: set ei.transferred_from_exp_item_id = NULL
3477: where ei.expenditure_item_id in ( select eia.expenditure_item_id
3478: from Pa_Expend_item_Adj_Activities eia
3479: where eia.request_id = l_request_id
3480: and eia.exception_activity_code= 'SOURCE PURGED')
3481: and ei.transferred_from_exp_item_id is not null ;
3482:

Line 3603: insert into Pa_Expend_item_Adj_Activities

3599: -- l_request_id := Pa_Expend_Item_Adj_Act_s.nextval ;
3600: x_err_stage := 'PA_ExpItemsDestPurge: Before inserting audit records ' ;
3601: /* if p_txn_to_date is NOT NULL then */
3602: FORALL l_exp_ind IN l_exp_item_id_tab.FIRST .. l_exp_item_id_tab.LAST
3603: insert into Pa_Expend_item_Adj_Activities
3604: ( expenditure_item_id,
3605: activity_date,
3606: last_update_date,
3607: last_updated_by,