APPS.PA_PURGE_PJR_TXNS dependencies on WF_PURGE

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 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 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 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 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 3383: -- API name : PA_WF_PURGE

3379: End Pa_Advertisements_purge;
3380:
3381:
3382: -- Start of comments
3383: -- API name : PA_WF_PURGE
3384: -- Type : Public
3385: -- Pre-reqs : None
3386: -- Function : Main purge procedure for Purging records from Workflow related tables:
3387: -- Note : Argument p_entity_key2_tab can have the following values-

Line 3392: PROCEDURE PA_WF_PURGE ( p_purge_batch_id IN NUMBER,

3388: -- pa_wf_processes.entity_key2
3389: -- pa_wf_process-details.object_id1.
3390: -- pa_wf_ntf_performers.object_id1.
3391:
3392: PROCEDURE PA_WF_PURGE ( p_purge_batch_id IN NUMBER,
3393: p_project_id IN NUMBER,
3394: p_purge_release IN VARCHAR2,
3395: p_entity_key_tab IN Pa_Plsql_Datatypes.IdTabTyp,
3396: p_wf_type_code IN VARCHAR2,

Line 3682: Wf_Purge.total( itemtype => p_item_type,

3678: itemkey => l_item_key );
3679: END IF;
3680:
3681: /* Purge the record from workflow tables.*/
3682: Wf_Purge.total( itemtype => p_item_type,
3683: itemkey => l_item_key );
3684:
3685:
3686: END LOOP;

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 3741: END PA_WF_PURGE;

3737:
3738: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
3739:
3740:
3741: END PA_WF_PURGE;
3742:
3743:
3744: PROCEDURE PA_WF_MASS_PURGE ( p_purge_batch_id IN NUMBER,
3745: p_project_id IN NUMBER,

Line 3947: Wf_Purge.total( itemtype => p_item_type,

3943: itemkey => l_item_key );
3944: END IF;
3945:
3946: /* Purge the record from workflow tables.*/
3947: Wf_Purge.total( itemtype => p_item_type,
3948: itemkey => l_item_key );
3949:
3950:
3951: END LOOP;

Line 4215: Wf_Purge.total( itemtype => 'PARMAAP',

4211: itemkey => l_item_key );
4212: END IF;
4213:
4214: /* Purge the record from workflow tables.*/
4215: Wf_Purge.total( itemtype => 'PARMAAP',
4216: itemkey => l_item_key );
4217:
4218:
4219: END LOOP;

Line 4400: Wf_Purge.total( itemtype => p_item_type,

4396: itemkey => l_item_key );
4397: END IF;
4398:
4399: /* Purge the record from workflow tables.*/
4400: Wf_Purge.total( itemtype => p_item_type,
4401: itemkey => l_item_key );
4402:
4403:
4404: END LOOP;