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_PJR_TXNS

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 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 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 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 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 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 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 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 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 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 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 ;