DBA Data[Home] [Help]

APPS.PA_PURGE_PJR_TXNS dependencies on PA_WF_NTF_PERFORMERS_AR

Line 3563: Pa_Debug.DEBUG('Inserting Records into pa_wf_ntf_performers_AR table ') ;

3559: /* Increase the value of l_nos_wf_process_dtls_inserted to indicate number of records inserted in
3560: pa_wf_process_details_ar table. The value will increase for each loop(item_key)*/
3561: l_nos_wf_process_dtls_inserted := l_nos_wf_process_dtls_inserted + SQL%ROWCOUNT;
3562:
3563: Pa_Debug.DEBUG('Inserting Records into pa_wf_ntf_performers_AR table ') ;
3564: x_err_stage := 'Inserting Records into pa_wf_ntf_performers_AR table for item key '|| l_item_key ;
3565:
3566:
3567: INSERT INTO pa_wf_ntf_performers_ar

Line 3564: x_err_stage := 'Inserting Records into pa_wf_ntf_performers_AR table for item key '|| l_item_key ;

3560: pa_wf_process_details_ar table. The value will increase for each loop(item_key)*/
3561: l_nos_wf_process_dtls_inserted := l_nos_wf_process_dtls_inserted + SQL%ROWCOUNT;
3562:
3563: Pa_Debug.DEBUG('Inserting Records into pa_wf_ntf_performers_AR table ') ;
3564: x_err_stage := 'Inserting Records into pa_wf_ntf_performers_AR table for item key '|| l_item_key ;
3565:
3566:
3567: INSERT INTO pa_wf_ntf_performers_ar
3568: (purge_batch_id,

Line 3567: INSERT INTO pa_wf_ntf_performers_ar

3563: Pa_Debug.DEBUG('Inserting Records into pa_wf_ntf_performers_AR table ') ;
3564: x_err_stage := 'Inserting Records into pa_wf_ntf_performers_AR table for item key '|| l_item_key ;
3565:
3566:
3567: INSERT INTO pa_wf_ntf_performers_ar
3568: (purge_batch_id,
3569: purge_release,
3570: purge_project_id,
3571: wf_type_code,

Line 4108: Pa_Debug.DEBUG('Inserting Records into pa_wf_ntf_performers_AR table ') ;

4104: /*Increase the value of l_nos_wf_process_inserted to indicate number of records inserted in pa_wf_processes_ar table.
4105: The value will increase for each loop(item_key)*/
4106: l_nos_wf_process_inserted := l_nos_wf_process_inserted + SQL%ROWCOUNT;
4107:
4108: Pa_Debug.DEBUG('Inserting Records into pa_wf_ntf_performers_AR table ') ;
4109: x_err_stage := 'Inserting Records into pa_wf_ntf_performers_AR table for assignment_id/group_id '|| l_group_id ;
4110:
4111:
4112: INSERT INTO pa_wf_ntf_performers_ar

Line 4109: x_err_stage := 'Inserting Records into pa_wf_ntf_performers_AR table for assignment_id/group_id '|| l_group_id ;

4105: The value will increase for each loop(item_key)*/
4106: l_nos_wf_process_inserted := l_nos_wf_process_inserted + SQL%ROWCOUNT;
4107:
4108: Pa_Debug.DEBUG('Inserting Records into pa_wf_ntf_performers_AR table ') ;
4109: x_err_stage := 'Inserting Records into pa_wf_ntf_performers_AR table for assignment_id/group_id '|| l_group_id ;
4110:
4111:
4112: INSERT INTO pa_wf_ntf_performers_ar
4113: (purge_batch_id,

Line 4112: INSERT INTO pa_wf_ntf_performers_ar

4108: Pa_Debug.DEBUG('Inserting Records into pa_wf_ntf_performers_AR table ') ;
4109: x_err_stage := 'Inserting Records into pa_wf_ntf_performers_AR table for assignment_id/group_id '|| l_group_id ;
4110:
4111:
4112: INSERT INTO pa_wf_ntf_performers_ar
4113: (purge_batch_id,
4114: purge_release,
4115: purge_project_id,
4116: wf_type_code,