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 2836: insert into Pa_Expend_item_Adj_Activities

2832: into l_request_id
2833: from dual ;
2834:
2835: FORALL exp_ind IN l_exp_item_id_tab.FIRST .. l_exp_item_id_tab.LAST
2836: insert into Pa_Expend_item_Adj_Activities
2837: ( expenditure_item_id,
2838: activity_date,
2839: last_update_date,
2840: last_updated_by,

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

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

Line 2991: insert into Pa_Expend_item_Adj_Activities

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

Line 3025: insert into Pa_Expend_item_Adj_Activities

3021: from pa_purge_projects pp
3022: where pp.project_id = ei.project_id
3023: and pp.purge_batch_id = p_purge_batch_id ) ;
3024: else
3025: insert into Pa_Expend_item_Adj_Activities
3026: ( expenditure_item_id,
3027: activity_date,
3028: last_update_date,
3029: last_updated_by,

Line 3452: from Pa_Expend_item_Adj_Activities eia,

3448: ei.posted_acct_burdened_cost,
3449: ei.adjustment_type
3450: from pa_expenditure_items_all ei
3451: where ei.expenditure_item_id in ( select ei1.transferred_from_exp_item_id
3452: from Pa_Expend_item_Adj_Activities eia,
3453: pa_expenditure_items_all ei1
3454: where ei1.expenditure_item_id = eia.expenditure_item_id
3455: and eia.request_id = l_request_id
3456: and eia.exception_activity_code= 'SOURCE PURGED'

Line 3467: from Pa_Expend_item_Adj_Activities eia,

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

Line 3482: from Pa_Expend_item_Adj_Activities eia

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

Line 3607: insert into Pa_Expend_item_Adj_Activities

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