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_PJR_TXNS dependencies on PA_PURGE

Line 1: Package body PA_PURGE_PJR_TXNS AS

1: Package body PA_PURGE_PJR_TXNS AS
2: /* $Header: PAXPJRPB.pls 120.1 2005/08/19 17:16:54 mwasowic noship $ */
3: -- Start of comments
4: -- API name : PA_REQUIREMENTS_PURGE
5: -- Type : Public

Line 114: pa_purge_pjr_txns.pa_forecast_items_purge( p_purge_batch_id =>p_purge_batch_id,

110: pa_debug.debug(' About to purge Forecast Items and Forecast Item Details ') ;
111: x_err_stage := 'About to purge forecast items for project '||to_char(p_project_id) ;
112:
113:
114: pa_purge_pjr_txns.pa_forecast_items_purge( p_purge_batch_id =>p_purge_batch_id,
115: p_project_id =>p_project_id,
116: p_purge_release =>p_purge_release,
117: p_assignment_id_tab =>l_requirement_id_tab,
118: p_archive_flag =>p_archive_flag,

Line 129: pa_purge_pjr_txns.pa_schedules_purge( p_purge_batch_id =>p_purge_batch_id,

125: pa_debug.debug(' About to purge schedules, schedule history and schedule exceptions data ') ;
126: x_err_stage := 'About to purge schedules data for project '||to_char(p_project_id) ;
127:
128:
129: pa_purge_pjr_txns.pa_schedules_purge( p_purge_batch_id =>p_purge_batch_id,
130: p_project_id =>p_project_id,
131: p_purge_release =>p_purge_release,
132: p_assignment_id_tab =>l_requirement_id_tab,
133: p_archive_flag =>p_archive_flag,

Line 144: pa_purge_pjr_txns.pa_candidates_purge( p_purge_batch_id =>p_purge_batch_id,

140:
141: pa_debug.debug(' About to purge candidate and candidate reviews data ') ;
142: x_err_stage := 'About to purge candidate and candidate reviws for project '||to_char(p_project_id) ;
143:
144: pa_purge_pjr_txns.pa_candidates_purge( p_purge_batch_id =>p_purge_batch_id,
145: p_project_id =>p_project_id,
146: p_purge_release =>p_purge_release,
147: p_assignment_id_tab =>l_requirement_id_tab,
148: p_archive_flag =>p_archive_flag,

Line 158: pa_purge_pjr_txns.pa_advertisements_purge( p_purge_batch_id =>p_purge_batch_id,

154:
155: pa_debug.debug(' About to purge advertisements data ') ;
156: x_err_stage := 'About to purge advertisements data for project '||to_char(p_project_id) ;
157:
158: pa_purge_pjr_txns.pa_advertisements_purge( p_purge_batch_id =>p_purge_batch_id,
159: p_project_id =>p_project_id,
160: p_purge_release =>p_purge_release,
161: p_assignment_id_tab =>l_requirement_id_tab,
162: p_archive_flag =>p_archive_flag,

Line 172: pa_purge_pjr_txns.pa_project_assignment_purge( p_purge_batch_id =>p_purge_batch_id,

168:
169: pa_debug.debug(' About to purge requirement and its history data ') ;
170: x_err_stage := 'About to purge requirement and its history '||to_char(p_project_id) ;
171:
172: pa_purge_pjr_txns.pa_project_assignment_purge( p_purge_batch_id =>p_purge_batch_id,
173: p_project_id =>p_project_id,
174: p_purge_release =>p_purge_release,
175: p_assignment_id_tab =>l_requirement_id_tab,
176: p_archive_flag =>p_archive_flag,

Line 240: pa_purge_pjr_txns.pa_forecast_items_purge( p_purge_batch_id =>p_purge_batch_id,

236:
237: pa_debug.debug(' About to purge Forecast Items and Forecast Item Details ') ;
238: x_err_stage := 'About to purge forecast items for project '||to_char(p_project_id) ;
239:
240: pa_purge_pjr_txns.pa_forecast_items_purge( p_purge_batch_id =>p_purge_batch_id,
241: p_project_id =>p_project_id,
242: p_purge_release =>p_purge_release,
243: p_assignment_id_tab =>l_requirement_id_tab,
244: p_archive_flag =>p_archive_flag,

Line 255: pa_purge_pjr_txns.pa_schedules_purge( p_purge_batch_id =>p_purge_batch_id,

251: pa_debug.debug(' About to purge schedules, schedule history and schedule exceptions data ') ;
252: x_err_stage := 'About to purge sschedules data for project '||to_char(p_project_id) ;
253:
254:
255: pa_purge_pjr_txns.pa_schedules_purge( p_purge_batch_id =>p_purge_batch_id,
256: p_project_id =>p_project_id,
257: p_purge_release =>p_purge_release,
258: p_assignment_id_tab =>l_requirement_id_tab,
259: p_archive_flag =>p_archive_flag,

Line 270: pa_purge_pjr_txns.pa_candidates_purge( p_purge_batch_id =>p_purge_batch_id,

266:
267: pa_debug.debug(' About to purge candidate and candidate reviews data ') ;
268: x_err_stage := 'About to purge candidate and candidate reviws for project '||to_char(p_project_id) ;
269:
270: pa_purge_pjr_txns.pa_candidates_purge( p_purge_batch_id =>p_purge_batch_id,
271: p_project_id =>p_project_id,
272: p_purge_release =>p_purge_release,
273: p_assignment_id_tab =>l_requirement_id_tab,
274: p_archive_flag =>p_archive_flag,

Line 284: pa_purge_pjr_txns.pa_advertisements_purge( p_purge_batch_id =>p_purge_batch_id,

280:
281: pa_debug.debug(' About to purge advertisements data ') ;
282: x_err_stage := 'About to purge advertisements data for project '||to_char(p_project_id) ;
283:
284: pa_purge_pjr_txns.pa_advertisements_purge( p_purge_batch_id =>p_purge_batch_id,
285: p_project_id =>p_project_id,
286: p_purge_release =>p_purge_release,
287: p_assignment_id_tab =>l_requirement_id_tab,
288: p_archive_flag =>p_archive_flag,

Line 298: pa_purge_pjr_txns.pa_project_assignment_purge( p_purge_batch_id =>p_purge_batch_id,

294:
295: pa_debug.debug(' About to purge requirement and its history data ') ;
296: x_err_stage := 'About to purge requirement and its history '||to_char(p_project_id) ;
297:
298: pa_purge_pjr_txns.pa_project_assignment_purge( p_purge_batch_id =>p_purge_batch_id,
299: p_project_id =>p_project_id,
300: p_purge_release =>p_purge_release,
301: p_assignment_id_tab =>l_requirement_id_tab,
302: p_archive_flag =>p_archive_flag,

Line 328: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_REQUIREMENTS_PURGE' );

324: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
325: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
326:
327: WHEN OTHERS THEN
328: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_REQUIREMENTS_PURGE' );
329: pa_debug.debug('Error stage is '||x_err_stage );
330: pa_debug.debug('Error stack is '||x_err_stack );
331: pa_debug.debug(SQLERRM);
332: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 435: pa_purge_pjr_txns.pa_forecast_items_purge( p_purge_batch_id =>p_purge_batch_id,

431:
432: pa_debug.debug(' About to purge Forecast Items and Forecast Item Details ') ;
433: x_err_stage := 'About to purge forecast items for project '||to_char(p_project_id) ;
434:
435: pa_purge_pjr_txns.pa_forecast_items_purge( p_purge_batch_id =>p_purge_batch_id,
436: p_project_id =>p_project_id,
437: p_purge_release =>p_purge_release,
438: p_assignment_id_tab =>l_assignment_id_tab,
439: p_archive_flag =>p_archive_flag,

Line 450: pa_purge_pjr_txns.pa_schedules_purge( p_purge_batch_id =>p_purge_batch_id,

446: pa_debug.debug(' About to purge schedules, schedule history and schedule exceptions data ') ;
447: x_err_stage := 'About to purge sschedules data for project '||to_char(p_project_id) ;
448:
449:
450: pa_purge_pjr_txns.pa_schedules_purge( p_purge_batch_id =>p_purge_batch_id,
451: p_project_id =>p_project_id,
452: p_purge_release =>p_purge_release,
453: p_assignment_id_tab =>l_assignment_id_tab,
454: p_archive_flag =>p_archive_flag,

Line 466: pa_purge_pjr_txns.pa_assignment_conflicts_purge( p_purge_batch_id =>p_purge_batch_id,

462: pa_debug.debug(' About to purge assignment conflicts history data ') ;
463: x_err_stage := 'About to purge assignment conflicts history '||to_char(p_project_id) ;
464:
465:
466: pa_purge_pjr_txns.pa_assignment_conflicts_purge( p_purge_batch_id =>p_purge_batch_id,
467: p_project_id =>p_project_id,
468: p_purge_release =>p_purge_release,
469: p_assignment_id_tab =>l_assignment_id_tab,
470: p_archive_flag =>p_archive_flag,

Line 481: pa_purge_pjr_txns.pa_project_parties_purge( p_purge_batch_id =>p_purge_batch_id,

477:
478: pa_debug.debug(' About to purge pa_project_parties data related to assignments') ;
479: x_err_stage := 'About to purge assignment related project parties data'||to_char(p_project_id) ;
480:
481: pa_purge_pjr_txns.pa_project_parties_purge( p_purge_batch_id =>p_purge_batch_id,
482: p_project_id =>p_project_id,
483: p_purge_release =>p_purge_release,
484: p_assignment_id_tab =>l_assignment_id_tab,
485: p_archive_flag =>p_archive_flag,

Line 495: pa_purge_pjr_txns.pa_project_assignment_purge( p_purge_batch_id =>p_purge_batch_id,

491:
492: pa_debug.debug(' About to purge assignments and its history data ') ;
493: x_err_stage := 'About to purge assignments and its history '||to_char(p_project_id) ;
494:
495: pa_purge_pjr_txns.pa_project_assignment_purge( p_purge_batch_id =>p_purge_batch_id,
496: p_project_id =>p_project_id,
497: p_purge_release =>p_purge_release,
498: p_assignment_id_tab =>l_assignment_id_tab,
499: p_archive_flag =>p_archive_flag,

Line 564: pa_purge_pjr_txns.pa_forecast_items_purge( p_purge_batch_id =>p_purge_batch_id,

560:
561: pa_debug.debug(' About to purge Forecast Items and Forecast Item Details ') ;
562: x_err_stage := 'About to purge forecast items for project '||to_char(p_project_id) ;
563:
564: pa_purge_pjr_txns.pa_forecast_items_purge( p_purge_batch_id =>p_purge_batch_id,
565: p_project_id =>p_project_id,
566: p_purge_release =>p_purge_release,
567: p_assignment_id_tab =>l_assignment_id_tab,
568: p_archive_flag =>p_archive_flag,

Line 579: pa_purge_pjr_txns.pa_schedules_purge( p_purge_batch_id =>p_purge_batch_id,

575: pa_debug.debug(' About to purge schedules, schedule history and schedule exceptions data ') ;
576: x_err_stage := 'About to purge sschedules data for project '||to_char(p_project_id) ;
577:
578:
579: pa_purge_pjr_txns.pa_schedules_purge( p_purge_batch_id =>p_purge_batch_id,
580: p_project_id =>p_project_id,
581: p_purge_release =>p_purge_release,
582: p_assignment_id_tab =>l_assignment_id_tab,
583: p_archive_flag =>p_archive_flag,

Line 595: pa_purge_pjr_txns.pa_assignment_conflicts_purge( p_purge_batch_id =>p_purge_batch_id,

591: pa_debug.debug(' About to purge assignment conflicts history data ') ;
592: x_err_stage := 'About to purge assignment conflicts history '||to_char(p_project_id) ;
593:
594:
595: pa_purge_pjr_txns.pa_assignment_conflicts_purge( p_purge_batch_id =>p_purge_batch_id,
596: p_project_id =>p_project_id,
597: p_purge_release =>p_purge_release,
598: p_assignment_id_tab =>l_assignment_id_tab,
599: p_archive_flag =>p_archive_flag,

Line 610: pa_purge_pjr_txns.pa_project_parties_purge( p_purge_batch_id =>p_purge_batch_id,

606:
607: pa_debug.debug(' About to purge pa_project_parties data related to assignments') ;
608: x_err_stage := 'About to purge assignment related project parties data'||to_char(p_project_id) ;
609:
610: pa_purge_pjr_txns.pa_project_parties_purge( p_purge_batch_id =>p_purge_batch_id,
611: p_project_id =>p_project_id,
612: p_purge_release =>p_purge_release,
613: p_assignment_id_tab =>l_assignment_id_tab,
614: p_archive_flag =>p_archive_flag,

Line 624: pa_purge_pjr_txns.pa_project_assignment_purge( p_purge_batch_id =>p_purge_batch_id,

620:
621: pa_debug.debug(' About to purge assignments and its history data ') ;
622: x_err_stage := 'About to purge assignments and its history '||to_char(p_project_id) ;
623:
624: pa_purge_pjr_txns.pa_project_assignment_purge( p_purge_batch_id =>p_purge_batch_id,
625: p_project_id =>p_project_id,
626: p_purge_release =>p_purge_release,
627: p_assignment_id_tab =>l_assignment_id_tab,
628: p_archive_flag =>p_archive_flag,

Line 654: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ASSIGNMENTS_PURGE' );

650: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
651: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
652:
653: WHEN OTHERS THEN
654: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ASSIGNMENTS_PURGE' );
655: pa_debug.debug('Error stage is '||x_err_stage );
656: pa_debug.debug('Error stack is '||x_err_stack );
657: pa_debug.debug(SQLERRM);
658: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 723: Pa_Purge_Pjr_Txns.pa_wf_purge ( p_purge_batch_id =>p_purge_batch_id,

719:
720: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;
721: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
722:
723: Pa_Purge_Pjr_Txns.pa_wf_purge ( p_purge_batch_id =>p_purge_batch_id,
724: p_project_id =>p_project_id,
725: p_purge_release =>p_purge_release,
726: p_entity_key_tab =>p_assignment_id_tab,
727: p_wf_type_code =>'FORECAST_GENERATION',

Line 1212: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited. This also creates a record in the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.

1208: END LOOP;
1209: Close cur_forecast_items;
1210: END LOOP;
1211:
1212: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited. This also creates a record in the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.
1213: The procedure is called once for pa_forecast_items and once for pa_forecast_item_details */
1214:
1215: pa_purge.CommitProcess(p_purge_batch_id,
1216: p_project_id,

Line 1215: pa_purge.CommitProcess(p_purge_batch_id,

1211:
1212: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited. This also creates a record in the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.
1213: The procedure is called once for pa_forecast_items and once for pa_forecast_item_details */
1214:
1215: pa_purge.CommitProcess(p_purge_batch_id,
1216: p_project_id,
1217: 'PA_FORECAST_ITEMS',
1218: l_nos_fi_inserted,
1219: l_nos_fi_deleted,

Line 1225: pa_purge.CommitProcess(p_purge_batch_id,

1221: x_err_stack,
1222: x_err_stage
1223: ) ;
1224:
1225: pa_purge.CommitProcess(p_purge_batch_id,
1226: p_project_id,
1227: 'PA_FORECAST_ITEM_DETAILS',
1228: l_nos_fid_inserted,
1229: l_nos_fid_deleted,

Line 1235: pa_purge.CommitProcess(p_purge_batch_id,

1231: x_err_stack,
1232: x_err_stage
1233: ) ;
1234:
1235: pa_purge.CommitProcess(p_purge_batch_id,
1236: p_project_id,
1237: 'PA_FI_AMOUNT_DETAILS',
1238: /* l_nos_fid_inserted, bug 2480653 */
1239: /* l_nos_fid_deleted, bug 2480653 */

Line 1255: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_COSTING_MAIN_PURGE' );

1251: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1252: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1253:
1254: WHEN OTHERS THEN
1255: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_COSTING_MAIN_PURGE' );
1256: pa_debug.debug('Error stage is '||x_err_stage );
1257: pa_debug.debug('Error stack is '||x_err_stack );
1258: pa_debug.debug(SQLERRM);
1259: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 1619: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.

1615:
1616: END LOOP;
1617:
1618: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited. This also creates a record in
1619: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.
1620: The procedure is called pa_schedules, pa_schedule_except_history and pa_schedules_history tables */
1621:
1622: pa_purge.CommitProcess(p_purge_batch_id,
1623: p_project_id,

Line 1622: pa_purge.CommitProcess(p_purge_batch_id,

1618: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited. This also creates a record in
1619: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.
1620: The procedure is called pa_schedules, pa_schedule_except_history and pa_schedules_history tables */
1621:
1622: pa_purge.CommitProcess(p_purge_batch_id,
1623: p_project_id,
1624: 'PA_SCHEDULES',
1625: l_nos_schedule_inserted,
1626: l_nos_schedule_deleted,

Line 1632: pa_purge.CommitProcess(p_purge_batch_id,

1628: x_err_stack,
1629: x_err_stage
1630: ) ;
1631:
1632: pa_purge.CommitProcess(p_purge_batch_id,
1633: p_project_id,
1634: 'PA_SCHEDULES_HISTORY',
1635: l_nos_schedule_his_inserted,
1636: l_nos_schedule_his_deleted,

Line 1642: pa_purge.CommitProcess(p_purge_batch_id,

1638: x_err_stack,
1639: x_err_stage
1640: ) ;
1641:
1642: pa_purge.CommitProcess(p_purge_batch_id,
1643: p_project_id,
1644: 'PA_SCHEDULE_EXCEPT_HISTORY',
1645: l_nos_schedule_exp_inserted,
1646: l_nos_schedule_exp_deleted,

Line 1660: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_SCHEDULES_PURGE' );

1656: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1657: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1658:
1659: WHEN OTHERS THEN
1660: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_SCHEDULES_PURGE' );
1661: pa_debug.debug('Error stage is '||x_err_stage );
1662: pa_debug.debug('Error stack is '||x_err_stack );
1663: pa_debug.debug(SQLERRM);
1664: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 1726: Pa_Purge_Pjr_Txns.pa_wf_purge ( p_purge_batch_id =>p_purge_batch_id,

1722:
1723: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;
1724: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
1725:
1726: Pa_Purge_Pjr_Txns.pa_wf_purge ( p_purge_batch_id =>p_purge_batch_id,
1727: p_project_id =>p_project_id,
1728: p_purge_release =>p_purge_release,
1729: p_entity_key_tab =>p_assignment_id_tab,
1730: p_wf_type_code =>'CANDIDATE',

Line 1940: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.

1936:
1937: END LOOP;
1938:
1939: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited. This also creates a record in
1940: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.
1941: The procedure is called pa_schedules, pa_schedule_except_history and pa_schedules_history tables */
1942:
1943: pa_purge.CommitProcess(p_purge_batch_id,
1944: p_project_id,

Line 1943: pa_purge.CommitProcess(p_purge_batch_id,

1939: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited. This also creates a record in
1940: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.
1941: The procedure is called pa_schedules, pa_schedule_except_history and pa_schedules_history tables */
1942:
1943: pa_purge.CommitProcess(p_purge_batch_id,
1944: p_project_id,
1945: 'PA_CANDIDATES',
1946: l_nos_candidate_inserted,
1947: l_nos_candidate_deleted,

Line 1953: pa_purge.CommitProcess(p_purge_batch_id,

1949: x_err_stack,
1950: x_err_stage
1951: ) ;
1952:
1953: pa_purge.CommitProcess(p_purge_batch_id,
1954: p_project_id,
1955: 'PA_CANDIDATE_REVIEWS',
1956: l_nos_candidate_rev_inserted,
1957: l_nos_candidate_rev_deleted,

Line 1970: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_CANDIDATES_PURGE');

1966: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1967: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1968:
1969: WHEN OTHERS THEN
1970: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_CANDIDATES_PURGE');
1971: pa_debug.debug('Error stage is '||x_err_stage );
1972: pa_debug.debug('Error stack is '||x_err_stack );
1973: pa_debug.debug(SQLERRM);
1974: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 2111: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.

2107: l_nos_conflicts_deleted :=l_nos_conflicts_deleted + SQL%ROWCOUNT;
2108: END LOOP;
2109:
2110: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited. This also creates a record in
2111: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.
2112: The procedure is called pa_schedules, pa_schedule_except_history and pa_schedules_history tables */
2113:
2114: pa_purge.CommitProcess(p_purge_batch_id,
2115: p_project_id,

Line 2114: pa_purge.CommitProcess(p_purge_batch_id,

2110: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited. This also creates a record in
2111: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.
2112: The procedure is called pa_schedules, pa_schedule_except_history and pa_schedules_history tables */
2113:
2114: pa_purge.CommitProcess(p_purge_batch_id,
2115: p_project_id,
2116: 'PA_ASSIGNMENT_CONFLICT_HIST',
2117: l_nos_conflicts_inserted,
2118: l_nos_conflicts_deleted,

Line 2133: Pa_Purge_Pjr_Txns.pa_wf_purge ( p_purge_batch_id =>p_purge_batch_id,

2129:
2130: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;
2131: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
2132:
2133: Pa_Purge_Pjr_Txns.pa_wf_purge ( p_purge_batch_id =>p_purge_batch_id,
2134: p_project_id =>p_project_id,
2135: p_purge_release =>p_purge_release,
2136: p_entity_key_tab =>l_project_id_tab,
2137: p_wf_type_code =>'OVERCOMMITMENT',

Line 2151: Pa_Purge_Pjr_Txns.pa_wf_key_purge ( p_purge_batch_id =>p_purge_batch_id,

2147:
2148: Pa_Debug.DEBUG(' About to purge workflow process ') ;
2149: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
2150:
2151: Pa_Purge_Pjr_Txns.pa_wf_key_purge ( p_purge_batch_id =>p_purge_batch_id,
2152: p_project_id =>p_project_id,
2153: p_purge_release =>p_purge_release,
2154: p_entity_key2 =>'SELF_OVERCOMMITMENT',
2155: p_wf_type_code =>'OVERCOMMITMENT',

Line 2170: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ASSIGNMENT_CONFLICTS_PURGE' );

2166: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2167: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2168:
2169: WHEN OTHERS THEN
2170: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ASSIGNMENT_CONFLICTS_PURGE' );
2171: pa_debug.debug('Error stage is '||x_err_stage );
2172: pa_debug.debug('Error stack is '||x_err_stack );
2173: pa_debug.debug(SQLERRM);
2174: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 2228: Pa_Purge_Pjr_Txns.pa_wf_mass_purge ( p_purge_batch_id =>p_purge_batch_id,

2224:
2225: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;
2226: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
2227:
2228: Pa_Purge_Pjr_Txns.pa_wf_mass_purge ( p_purge_batch_id =>p_purge_batch_id,
2229: p_project_id =>p_project_id,
2230: p_purge_release =>p_purge_release,
2231: p_object_id_tab =>p_assignment_id_tab,
2232: p_item_type =>'PARMATRX',

Line 2244: Pa_Purge_Pjr_Txns.pa_wf_purge ( p_purge_batch_id =>p_purge_batch_id,

2240:
2241: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;
2242: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
2243:
2244: Pa_Purge_Pjr_Txns.pa_wf_purge ( p_purge_batch_id =>p_purge_batch_id,
2245: p_project_id =>p_project_id,
2246: p_purge_release =>p_purge_release,
2247: p_entity_key_tab =>p_assignment_id_tab,
2248: p_wf_type_code =>'ASSIGNMENT_APPROVAL',

Line 2260: Pa_Purge_Pjr_Txns.pa_wf_key_purge ( p_purge_batch_id =>p_purge_batch_id,

2256:
2257: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;
2258: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
2259:
2260: Pa_Purge_Pjr_Txns.pa_wf_key_purge ( p_purge_batch_id =>p_purge_batch_id,
2261: p_project_id =>p_project_id,
2262: p_purge_release =>p_purge_release,
2263: p_entity_key2 =>'0',
2264: p_wf_type_code =>'APPLY_TEAM_TEMPLATE',

Line 2276: Pa_Purge_Pjr_Txns.pa_wf_mass_asgn_purge ( p_purge_batch_id =>p_purge_batch_id,

2272:
2273: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;
2274: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
2275:
2276: Pa_Purge_Pjr_Txns.pa_wf_mass_asgn_purge ( p_purge_batch_id =>p_purge_batch_id,
2277: p_project_id =>p_project_id,
2278: p_purge_release =>p_purge_release,
2279: p_object_id_tab =>p_assignment_id_tab,
2280: p_wf_type_code =>'MASS_ASSIGNMENT_APPROVAL',

Line 2713: pa_purge.CommitProcess(p_purge_batch_id,

2709:
2710: END LOOP;
2711:
2712:
2713: pa_purge.CommitProcess(p_purge_batch_id,
2714: p_project_id,
2715: 'PA_PROJECT_ASSIGNMENTS',
2716: l_nos_assignments_inserted,
2717: l_nos_assignments_deleted,

Line 2723: pa_purge.CommitProcess(p_purge_batch_id,

2719: x_err_stack,
2720: x_err_stage
2721: ) ;
2722:
2723: pa_purge.CommitProcess(p_purge_batch_id,
2724: p_project_id,
2725: 'PA_ASSIGNMENTS_HISTORY',
2726: l_nos_assignments_his_inserted,
2727: l_nos_assignments_his_deleted,

Line 2740: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_PROJECT_ASSIGNMENT_PURGE' );

2736: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2737: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2738:
2739: WHEN OTHERS THEN
2740: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_PROJECT_ASSIGNMENT_PURGE' );
2741: pa_debug.debug('Error stage is '||x_err_stage );
2742: pa_debug.debug('Error stack is '||x_err_stack );
2743: pa_debug.debug(SQLERRM);
2744: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 2862: pa_purge.CommitProcess(p_purge_batch_id,

2858: l_nos_parties_deleted :=l_nos_parties_deleted + SQL%ROWCOUNT;
2859:
2860: END LOOP;
2861:
2862: pa_purge.CommitProcess(p_purge_batch_id,
2863: p_project_id,
2864: 'PA_PROJECT_PARTIES',
2865: l_nos_parties_inserted,
2866: l_nos_parties_deleted,

Line 2879: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_PROJECT_PARTIES_PURGE' );

2875: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2876: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2877:
2878: WHEN OTHERS THEN
2879: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_PROJECT_PARTIES_PURGE' );
2880: pa_debug.debug('Error stage is '||x_err_stage );
2881: pa_debug.debug('Error stack is '||x_err_stack );
2882: pa_debug.debug(SQLERRM);
2883: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 2953: Pa_Purge_Pjr_Txns.pa_wf_key_purge ( p_purge_batch_id =>p_purge_batch_id,

2949:
2950: Pa_Debug.DEBUG(' About to purge workflow process ') ;
2951: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
2952:
2953: Pa_Purge_Pjr_Txns.pa_wf_key_purge ( p_purge_batch_id =>p_purge_batch_id,
2954: p_project_id =>p_project_id,
2955: p_purge_release =>p_purge_release,
2956: p_entity_key2 => '-999',
2957: p_wf_type_code =>'ADVERTISEMENTS_NTF_WF',

Line 2970: Pa_Purge_Pjr_Txns.pa_wf_purge ( p_purge_batch_id =>p_purge_batch_id,

2966:
2967: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;
2968: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
2969:
2970: Pa_Purge_Pjr_Txns.pa_wf_purge ( p_purge_batch_id =>p_purge_batch_id,
2971: p_project_id =>p_project_id,
2972: p_purge_release =>p_purge_release,
2973: p_entity_key_tab =>p_assignment_id_tab,
2974: p_wf_type_code =>'ADVERTISEMENTS_NTF_WF',

Line 3319: pa_purge.CommitProcess(p_purge_batch_id,

3315: CLOSE Cur_Action_sets;
3316:
3317: END LOOP;
3318:
3319: pa_purge.CommitProcess(p_purge_batch_id,
3320: p_project_id,
3321: 'PA_ACTION_SETS',
3322: l_nos_action_sets_inserted,
3323: l_nos_action_sets_deleted,

Line 3329: pa_purge.CommitProcess(p_purge_batch_id,

3325: x_err_stack,
3326: x_err_stage
3327: ) ;
3328:
3329: pa_purge.CommitProcess(p_purge_batch_id,
3330: p_project_id,
3331: 'PA_ACTION_SET_LINES',
3332: l_nos_set_lines_inserted,
3333: l_nos_set_lines_deleted,

Line 3339: pa_purge.CommitProcess(p_purge_batch_id,

3335: x_err_stack,
3336: x_err_stage
3337: ) ;
3338:
3339: pa_purge.CommitProcess(p_purge_batch_id,
3340: p_project_id,
3341: /* 'PA_ACTN_SET_LN_COND_AR', bug 2480653 */
3342: 'PA_ACTION_SET_LINE_COND',
3343: l_nos_lines_cond_inserted,

Line 3350: pa_purge.CommitProcess(p_purge_batch_id,

3346: x_err_stack,
3347: x_err_stage
3348: ) ;
3349:
3350: pa_purge.CommitProcess(p_purge_batch_id,
3351: p_project_id,
3352: /* 'PA_ACTN_SETLN_AUD_AR', bug 2480653 */
3353: 'PA_ACTION_SET_LINE_AUD',
3354: l_nos_lines_aud_inserted,

Line 3368: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ADVERTISEMENTS_PURGE' );

3364: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
3365: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3366:
3367: WHEN OTHERS THEN
3368: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ADVERTISEMENTS_PURGE' );
3369: pa_debug.debug('Error stage is '||x_err_stage );
3370: pa_debug.debug('Error stack is '||x_err_stack );
3371: pa_debug.debug(SQLERRM);
3372: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 3693: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.

3689:
3690: END LOOP;
3691:
3692: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited. This also creates a record in
3693: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.
3694: The procedure is called once for ppa_wf_processes, pa_wf_process_details and pa_wf_ntf_performers tables */
3695:
3696: Pa_Purge.CommitProcess(p_purge_batch_id,
3697: p_project_id,

Line 3696: Pa_Purge.CommitProcess(p_purge_batch_id,

3692: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited. This also creates a record in
3693: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.
3694: The procedure is called once for ppa_wf_processes, pa_wf_process_details and pa_wf_ntf_performers tables */
3695:
3696: Pa_Purge.CommitProcess(p_purge_batch_id,
3697: p_project_id,
3698: 'PA_WF_NTF_PERFORMERS',
3699: l_nos_wf_ntf_perf_inserted,
3700: l_nos_wf_ntf_perf_deleted,

Line 3706: Pa_Purge.CommitProcess(p_purge_batch_id,

3702: x_err_stack,
3703: x_err_stage
3704: ) ;
3705:
3706: Pa_Purge.CommitProcess(p_purge_batch_id,
3707: p_project_id,
3708: 'PA_WF_PROCESS_DETAILS',
3709: l_nos_wf_process_dtls_inserted,
3710: l_nos_wf_process_dtls_deleted,

Line 3716: Pa_Purge.CommitProcess(p_purge_batch_id,

3712: x_err_stack,
3713: x_err_stage
3714: ) ;
3715:
3716: Pa_Purge.CommitProcess(p_purge_batch_id,
3717: p_project_id,
3718: 'PA_WF_PROCESSES',
3719: l_nos_wf_process_inserted,
3720: l_nos_wf_process_deleted,

Line 3732: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_PURGE');

3728: WHEN Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error THEN
3729: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
3730:
3731: WHEN OTHERS THEN
3732: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_PURGE');
3733: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
3734: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
3735: Pa_Debug.DEBUG(SQLERRM);
3736: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;

Line 3958: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.

3954:
3955: END LOOP;
3956:
3957: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited. This also creates a record in
3958: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.
3959: The procedure is called once for pa_wf_processes, pa_wf_process_details and pa_wf_ntf_performers tables */
3960:
3961: Pa_Purge.CommitProcess(p_purge_batch_id,
3962: p_project_id,

Line 3961: Pa_Purge.CommitProcess(p_purge_batch_id,

3957: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited. This also creates a record in
3958: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.
3959: The procedure is called once for pa_wf_processes, pa_wf_process_details and pa_wf_ntf_performers tables */
3960:
3961: Pa_Purge.CommitProcess(p_purge_batch_id,
3962: p_project_id,
3963: 'PA_WF_PROCESS_DETAILS',
3964: l_nos_wf_process_dtls_inserted,
3965: l_nos_wf_process_dtls_deleted,

Line 3971: Pa_Purge.CommitProcess(p_purge_batch_id,

3967: x_err_stack,
3968: x_err_stage
3969: ) ;
3970:
3971: Pa_Purge.CommitProcess(p_purge_batch_id,
3972: p_project_id,
3973: 'PA_WF_PROCESSES',
3974: l_nos_wf_process_inserted,
3975: l_nos_wf_process_deleted,

Line 3987: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_MASS_PURGE');

3983: WHEN Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error THEN
3984: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
3985:
3986: WHEN OTHERS THEN
3987: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_MASS_PURGE');
3988: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
3989: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
3990: Pa_Debug.DEBUG(SQLERRM);
3991: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;

Line 4226: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.

4222:
4223: END LOOP;
4224:
4225: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited. This also creates a record in
4226: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.
4227: The procedure is called once for pa_wf_processes and pa_wf_ntf_performers tables */
4228:
4229: Pa_Purge.CommitProcess(p_purge_batch_id,
4230: p_project_id,

Line 4229: Pa_Purge.CommitProcess(p_purge_batch_id,

4225: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited. This also creates a record in
4226: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.
4227: The procedure is called once for pa_wf_processes and pa_wf_ntf_performers tables */
4228:
4229: Pa_Purge.CommitProcess(p_purge_batch_id,
4230: p_project_id,
4231: 'PA_WF_NTF_PERFORMERS',
4232: l_nos_wf_ntf_perf_inserted,
4233: l_nos_wf_ntf_perf_deleted,

Line 4239: Pa_Purge.CommitProcess(p_purge_batch_id,

4235: x_err_stack,
4236: x_err_stage
4237: ) ;
4238:
4239: Pa_Purge.CommitProcess(p_purge_batch_id,
4240: p_project_id,
4241: 'PA_WF_PROCESSES',
4242: l_nos_wf_process_inserted,
4243: l_nos_wf_process_deleted,

Line 4255: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_MASS_ASGN_PURGE');

4251: WHEN Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error THEN
4252: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
4253:
4254: WHEN OTHERS THEN
4255: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_MASS_ASGN_PURGE');
4256: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
4257: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
4258: Pa_Debug.DEBUG(SQLERRM);
4259: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;

Line 4409: This also creates a record in the Pa_Purge_Project_details, which will show the no. of

4405:
4406: CLOSE cur_workflow;
4407:
4408: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited.
4409: This also creates a record in the Pa_Purge_Project_details, which will show the no. of
4410: records that are purged from each table.The procedure is called once for pa_wf_processes tables */
4411:
4412: Pa_Purge.CommitProcess(p_purge_batch_id,
4413: p_project_id,

Line 4412: Pa_Purge.CommitProcess(p_purge_batch_id,

4408: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited.
4409: This also creates a record in the Pa_Purge_Project_details, which will show the no. of
4410: records that are purged from each table.The procedure is called once for pa_wf_processes tables */
4411:
4412: Pa_Purge.CommitProcess(p_purge_batch_id,
4413: p_project_id,
4414: 'PA_WF_PROCESSES',
4415: l_nos_wf_process_inserted,
4416: l_nos_wf_process_deleted,

Line 4428: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_KEY_PURGE');

4424: WHEN Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error THEN
4425: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
4426:
4427: WHEN OTHERS THEN
4428: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_KEY_PURGE');
4429: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
4430: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
4431: Pa_Debug.DEBUG(SQLERRM);
4432: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;