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_PROCESSES_AR

Line 3458: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;

3454: /* If archive flag is YES, archiving of data needs to be done. Insert data into correspodning AR tables */
3455:
3456: IF p_archive_flag='Y' THEN
3457:
3458: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;
3459: x_err_stage := 'Inserting Records into pa_wf_processes_AR table for item key '||l_item_key ;
3460:
3461: INSERT INTO pa_wf_processes_ar
3462: (purge_batch_id,

Line 3459: x_err_stage := 'Inserting Records into pa_wf_processes_AR table for item key '||l_item_key ;

3455:
3456: IF p_archive_flag='Y' THEN
3457:
3458: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;
3459: x_err_stage := 'Inserting Records into pa_wf_processes_AR table for item key '||l_item_key ;
3460:
3461: INSERT INTO pa_wf_processes_ar
3462: (purge_batch_id,
3463: purge_release,

Line 3461: INSERT INTO pa_wf_processes_ar

3457:
3458: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;
3459: x_err_stage := 'Inserting Records into pa_wf_processes_AR table for item key '||l_item_key ;
3460:
3461: INSERT INTO pa_wf_processes_ar
3462: (purge_batch_id,
3463: purge_release,
3464: purge_project_id,
3465: wf_type_code,

Line 3496: /*Increase the value of l_nos_wf_process_inserted to indicate number of records inserted in pa_wf_processes_ar table.

3492: AND entity_key2 = l_entity_key
3493: AND wf_type_code = p_wf_type_code
3494: AND item_type = p_item_type;
3495:
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 ') ;

Line 3803: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;

3799: /* If archive flag is YES, archiving of data needs to be done. Insert data into correspodning AR tables */
3800:
3801: IF p_archive_flag='Y' THEN
3802:
3803: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;
3804: x_err_stage := 'Inserting Records into pa_wf_processes_AR table for item key '||l_item_key ;
3805:
3806: INSERT INTO pa_wf_processes_ar
3807: (purge_batch_id,

Line 3804: x_err_stage := 'Inserting Records into pa_wf_processes_AR table for item key '||l_item_key ;

3800:
3801: IF p_archive_flag='Y' THEN
3802:
3803: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;
3804: x_err_stage := 'Inserting Records into pa_wf_processes_AR table for item key '||l_item_key ;
3805:
3806: INSERT INTO pa_wf_processes_ar
3807: (purge_batch_id,
3808: purge_release,

Line 3806: INSERT INTO pa_wf_processes_ar

3802:
3803: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;
3804: x_err_stage := 'Inserting Records into pa_wf_processes_AR table for item key '||l_item_key ;
3805:
3806: INSERT INTO pa_wf_processes_ar
3807: (purge_batch_id,
3808: purge_release,
3809: purge_project_id,
3810: wf_type_code,

Line 3840: /*Increase the value of l_nos_wf_process_inserted to indicate number of records inserted in pa_wf_processes_ar table.

3836: WHERE item_key = l_item_key
3837: AND entity_key1 = TO_CHAR(p_project_id)
3838: AND item_type = p_item_type;
3839:
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 ') ;

Line 4065: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;

4061: /* If archive flag is YES, archiving of data needs to be done. Insert data into correspodning AR tables */
4062:
4063: IF p_archive_flag='Y' THEN
4064:
4065: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;
4066: x_err_stage := 'Inserting Records into pa_wf_processes_AR table for assignment_id/group_id '||l_group_id ;
4067:
4068: INSERT INTO pa_wf_processes_ar
4069: (purge_batch_id,

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

4062:
4063: IF p_archive_flag='Y' THEN
4064:
4065: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;
4066: x_err_stage := 'Inserting Records into pa_wf_processes_AR table for assignment_id/group_id '||l_group_id ;
4067:
4068: INSERT INTO pa_wf_processes_ar
4069: (purge_batch_id,
4070: purge_release,

Line 4068: INSERT INTO pa_wf_processes_ar

4064:
4065: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;
4066: x_err_stage := 'Inserting Records into pa_wf_processes_AR table for assignment_id/group_id '||l_group_id ;
4067:
4068: INSERT INTO pa_wf_processes_ar
4069: (purge_batch_id,
4070: purge_release,
4071: purge_project_id,
4072: wf_type_code,

Line 4104: /*Increase the value of l_nos_wf_process_inserted to indicate number of records inserted in pa_wf_processes_ar table.

4100: AND entity_key1 = TO_CHAR(p_project_id)
4101: AND wf_type_code = p_wf_type_code
4102: AND item_type <> 'PAWFAAP';
4103:
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 ') ;

Line 4326: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;

4322: /* If archive flag is YES, archiving of data needs to be done. Insert data into correspodning AR tables */
4323:
4324: IF p_archive_flag='Y' THEN
4325:
4326: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;
4327: x_err_stage := 'Inserting Records into pa_wf_processes_AR table for item key '||l_item_key ;
4328:
4329: INSERT INTO pa_wf_processes_ar
4330: (purge_batch_id,

Line 4327: x_err_stage := 'Inserting Records into pa_wf_processes_AR table for item key '||l_item_key ;

4323:
4324: IF p_archive_flag='Y' THEN
4325:
4326: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;
4327: x_err_stage := 'Inserting Records into pa_wf_processes_AR table for item key '||l_item_key ;
4328:
4329: INSERT INTO pa_wf_processes_ar
4330: (purge_batch_id,
4331: purge_release,

Line 4329: INSERT INTO pa_wf_processes_ar

4325:
4326: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;
4327: x_err_stage := 'Inserting Records into pa_wf_processes_AR table for item key '||l_item_key ;
4328:
4329: INSERT INTO pa_wf_processes_ar
4330: (purge_batch_id,
4331: purge_release,
4332: purge_project_id,
4333: wf_type_code,

Line 4364: /*Increase the value of l_nos_wf_process_inserted to indicate number of records inserted in pa_wf_processes_ar table.

4360: AND entity_key2 = p_entity_key2
4361: AND wf_type_code = p_wf_type_code
4362: AND item_type = p_item_type;
4363:
4364: /*Increase the value of l_nos_wf_process_inserted to indicate number of records inserted in pa_wf_processes_ar table.
4365: The value will increase for each loop(item_key)*/
4366: l_nos_wf_process_inserted := l_nos_wf_process_inserted + SQL%ROWCOUNT;
4367:
4368: