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_WF_PROCESS_DETAILS_AR

Line 3500: Pa_Debug.DEBUG('Inserting Records into pa_wf_process_DETAILS_AR table ') ;

3496: /*Increase the value of l_nos_wf_process_inserted to indicate number of records inserted in pa_wf_processes_ar table.
3497: The value will increase for each loop(item_key)*/
3498: l_nos_wf_process_inserted := l_nos_wf_process_inserted + SQL%ROWCOUNT;
3499:
3500: Pa_Debug.DEBUG('Inserting Records into pa_wf_process_DETAILS_AR table ') ;
3501: x_err_stage := 'Inserting Records into pa_wf_process_DETAILS_AR table for item key '|| l_item_key ;
3502:
3503:
3504: INSERT INTO pa_wf_process_details_ar

Line 3501: x_err_stage := 'Inserting Records into pa_wf_process_DETAILS_AR table for item key '|| l_item_key ;

3497: The value will increase for each loop(item_key)*/
3498: l_nos_wf_process_inserted := l_nos_wf_process_inserted + SQL%ROWCOUNT;
3499:
3500: Pa_Debug.DEBUG('Inserting Records into pa_wf_process_DETAILS_AR table ') ;
3501: x_err_stage := 'Inserting Records into pa_wf_process_DETAILS_AR table for item key '|| l_item_key ;
3502:
3503:
3504: INSERT INTO pa_wf_process_details_ar
3505: (purge_batch_id,

Line 3504: INSERT INTO pa_wf_process_details_ar

3500: Pa_Debug.DEBUG('Inserting Records into pa_wf_process_DETAILS_AR table ') ;
3501: x_err_stage := 'Inserting Records into pa_wf_process_DETAILS_AR table for item key '|| l_item_key ;
3502:
3503:
3504: INSERT INTO pa_wf_process_details_ar
3505: (purge_batch_id,
3506: purge_release,
3507: purge_project_id,
3508: wf_type_code,

Line 3560: pa_wf_process_details_ar table. The value will increase for each loop(item_key)*/

3556: AND wf_type_code = p_wf_type_code
3557: AND item_type = p_item_type;
3558:
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 ;

Line 3624: /*Increase the value of l_nos_wf_ntf_perf_inserted to indicate number of records inserted in pa_wf_process_details_ar table.

3620: AND object_id1 = l_entity_key
3621: AND wf_type_code = p_wf_type_code
3622: AND item_type = p_item_type;
3623:
3624: /*Increase the value of l_nos_wf_ntf_perf_inserted to indicate number of records inserted in pa_wf_process_details_ar table.
3625: The value will increase for each loop(item_key)*/
3626: l_nos_wf_ntf_perf_inserted := l_nos_wf_ntf_perf_inserted + SQL%ROWCOUNT;
3627:
3628: END IF; -- p_archive_flag='Y'

Line 3844: Pa_Debug.DEBUG('Inserting Records into pa_wf_process_DETAILS_AR table ') ;

3840: /*Increase the value of l_nos_wf_process_inserted to indicate number of records inserted in pa_wf_processes_ar table.
3841: The value will increase for each loop(item_key)*/
3842: l_nos_wf_process_inserted := l_nos_wf_process_inserted + SQL%ROWCOUNT;
3843:
3844: Pa_Debug.DEBUG('Inserting Records into pa_wf_process_DETAILS_AR table ') ;
3845: x_err_stage := 'Inserting Records into pa_wf_process_DETAILS_AR table for item key '|| l_item_key ;
3846:
3847:
3848: INSERT INTO pa_wf_process_details_ar

Line 3845: x_err_stage := 'Inserting Records into pa_wf_process_DETAILS_AR table for item key '|| l_item_key ;

3841: The value will increase for each loop(item_key)*/
3842: l_nos_wf_process_inserted := l_nos_wf_process_inserted + SQL%ROWCOUNT;
3843:
3844: Pa_Debug.DEBUG('Inserting Records into pa_wf_process_DETAILS_AR table ') ;
3845: x_err_stage := 'Inserting Records into pa_wf_process_DETAILS_AR table for item key '|| l_item_key ;
3846:
3847:
3848: INSERT INTO pa_wf_process_details_ar
3849: (purge_batch_id,

Line 3848: INSERT INTO pa_wf_process_details_ar

3844: Pa_Debug.DEBUG('Inserting Records into pa_wf_process_DETAILS_AR table ') ;
3845: x_err_stage := 'Inserting Records into pa_wf_process_DETAILS_AR table for item key '|| l_item_key ;
3846:
3847:
3848: INSERT INTO pa_wf_process_details_ar
3849: (purge_batch_id,
3850: purge_release,
3851: purge_project_id,
3852: wf_type_code,

Line 3903: pa_wf_process_details_ar table. The value will increase for each loop(item_key)*/

3899: AND NVL(object_id2, object_id1) = TO_CHAR(l_object_id)
3900: AND item_type = p_item_type;
3901:
3902: /* Increase the value of l_nos_wf_process_dtls_inserted to indicate number of records inserted in
3903: pa_wf_process_details_ar table. The value will increase for each loop(item_key)*/
3904: l_nos_wf_process_dtls_inserted := l_nos_wf_process_dtls_inserted + SQL%ROWCOUNT;
3905:
3906: END IF; -- p_archive_flag='Y'
3907:

Line 4168: /*Increase the value of l_nos_wf_ntf_perf_inserted to indicate number of records inserted in pa_wf_process_details_ar table.

4164: WHERE object_id1 = TO_CHAR(l_object_id)
4165: AND wf_type_code = p_wf_type_code
4166: AND item_type <> 'PAWFAAP';
4167:
4168: /*Increase the value of l_nos_wf_ntf_perf_inserted to indicate number of records inserted in pa_wf_process_details_ar table.
4169: The value will increase for each loop(item_key)*/
4170: l_nos_wf_ntf_perf_inserted := l_nos_wf_ntf_perf_inserted + SQL%ROWCOUNT;
4171:
4172: END IF; -- p_archive_flag='Y'