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