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

Line 717: /* Call Workflow API to archive/purge data from pa_wf_processes and detail table

713: l_nos_fi_amt_inserted :=0;
714:
715:
716: -----------------Begin Logic added to purge data from Workflow related tables-----------------
717: /* Call Workflow API to archive/purge data from pa_wf_processes and detail table
718: and also from pa_wf_ntf_performers table*/
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) ;

Line 1720: /* Call Workflow API to archive/purge data from pa_wf_processes and detail table

1716: l_nos_candidate_deleted :=0;
1717: l_nos_candidate_rev_deleted :=0;
1718:
1719: -----------------Begin Logic added to purge data from Workflow related tables-----------------
1720: /* Call Workflow API to archive/purge data from pa_wf_processes and detail table
1721: and also from pa_wf_ntf_performers table*/
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) ;

Line 2127: /* Call Workflow API to archive/purge data from pa_wf_processes and detail table

2123: -----------------Begin Logic added to purge data from Workflow related tables-----------------
2124:
2125: IF l_overcommitment_flag = 'Y' THEN
2126:
2127: /* Call Workflow API to archive/purge data from pa_wf_processes and detail table
2128: and also from pa_wf_ntf_performers table*/
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) ;

Line 2146: /* Call Workflow API to archive/purge data from pa_wf_processes table*/

2142: x_err_code =>x_err_code);
2143:
2144: END IF;
2145:
2146: /* Call Workflow API to archive/purge data from pa_wf_processes table*/
2147:
2148: Pa_Debug.DEBUG(' About to purge workflow process ') ;
2149: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
2150:

Line 2223: /* Call Workflow API to archive/purge data from pa_wf_processes and detail table */

2219: l_nos_assignments_deleted :=0;
2220: l_nos_assignments_his_deleted :=0;
2221:
2222: -----------------Begin Logic added to purge data from Workflow related tables-----------------
2223: /* Call Workflow API to archive/purge data from pa_wf_processes and detail table */
2224:
2225: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;
2226: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
2227:

Line 2238: /* Call Workflow API to archive/purge data from pa_wf_processes and detail table

2234: x_err_stack =>x_err_stack,
2235: x_err_stage =>x_err_stage,
2236: x_err_code =>x_err_code);
2237:
2238: /* Call Workflow API to archive/purge data from pa_wf_processes and detail table
2239: and also from pa_wf_ntf_performers table*/
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) ;

Line 2255: /* Call Workflow API to archive/purge data from pa_wf_processes table*/

2251: x_err_stack =>x_err_stack,
2252: x_err_stage =>x_err_stage,
2253: x_err_code =>x_err_code);
2254:
2255: /* Call Workflow API to archive/purge data from pa_wf_processes table*/
2256:
2257: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;
2258: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
2259:

Line 2271: /* Call Workflow API to archive/purge data from pa_wf_processes table*/

2267: x_err_stack =>x_err_stack,
2268: x_err_stage =>x_err_stage,
2269: x_err_code =>x_err_code);
2270:
2271: /* Call Workflow API to archive/purge data from pa_wf_processes table*/
2272:
2273: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;
2274: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
2275:

Line 2948: /* Call Workflow API to archive/purge data from pa_wf_processes table*/

2944: l_nos_lines_cond_deleted :=0;
2945: l_nos_lines_aud_deleted :=0;
2946:
2947: -----------------Begin Logic added to purge data from Workflow related tables-----------------
2948: /* Call Workflow API to archive/purge data from pa_wf_processes table*/
2949:
2950: Pa_Debug.DEBUG(' About to purge workflow process ') ;
2951: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
2952:

Line 2964: /* Call Workflow API to archive/purge data from pa_wf_processes and detail table

2960: x_err_stack =>x_err_stack,
2961: x_err_stage =>x_err_stage,
2962: x_err_code =>x_err_code);
2963:
2964: /* Call Workflow API to archive/purge data from pa_wf_processes and detail table
2965: and also from pa_wf_ntf_performers table*/
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) ;

Line 3388: -- pa_wf_processes.entity_key2

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

Line 3405: FROM pa_wf_processes

3401: x_err_code IN OUT NOCOPY NUMBER ) AS --File.Sql.39 bug 4440895
3402:
3403: CURSOR cur_workflow (x_entity_key VARCHAR2) IS
3404: SELECT item_key
3405: FROM pa_wf_processes
3406: WHERE entity_key1 = TO_CHAR(p_project_id)
3407: AND entity_key2 = x_entity_key
3408: AND wf_type_code = p_wf_type_code
3409: AND item_type = p_item_type;

Line 3411: l_item_key pa_wf_processes.item_key%TYPE;

3407: AND entity_key2 = x_entity_key
3408: AND wf_type_code = p_wf_type_code
3409: AND item_type = p_item_type;
3410:
3411: l_item_key pa_wf_processes.item_key%TYPE;
3412: I PLS_INTEGER;
3413: l_entity_key pa_wf_processes.entity_key2%TYPE;
3414: l_nos_wf_process_inserted NUMBER ;
3415: l_nos_wf_process_dtls_inserted NUMBER ;

Line 3413: l_entity_key pa_wf_processes.entity_key2%TYPE;

3409: AND item_type = p_item_type;
3410:
3411: l_item_key pa_wf_processes.item_key%TYPE;
3412: I PLS_INTEGER;
3413: l_entity_key pa_wf_processes.entity_key2%TYPE;
3414: l_nos_wf_process_inserted NUMBER ;
3415: l_nos_wf_process_dtls_inserted NUMBER ;
3416: l_nos_wf_ntf_perf_inserted NUMBER ;
3417: l_nos_wf_process_deleted NUMBER ;

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 3490: FROM pa_wf_processes

3486: last_update_date,
3487: creation_date,
3488: created_by,
3489: last_update_login
3490: FROM pa_wf_processes
3491: WHERE entity_key1 = TO_CHAR(p_project_id)
3492: AND entity_key2 = l_entity_key
3493: AND wf_type_code = p_wf_type_code
3494: AND item_type = p_item_type;

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 3630: /* To keep the count of no of records deleted from pa_wf_processes, pa_wf_process_details and pa_wf_ntf_performers,

3626: l_nos_wf_ntf_perf_inserted := l_nos_wf_ntf_perf_inserted + SQL%ROWCOUNT;
3627:
3628: END IF; -- p_archive_flag='Y'
3629:
3630: /* To keep the count of no of records deleted from pa_wf_processes, pa_wf_process_details and pa_wf_ntf_performers,
3631: manipulate the count of l_nos_wf_process_deleted, l_nos_wf_process_dtls_deleted and l_nos_wf_ntf_perf_deleted. */
3632:
3633: Pa_Debug.DEBUG('Deleting Records from pa_wf_ntf_performers table ') ;
3634: x_err_stage := 'Deleting Records from pa_wf_ntf_performers table for item key '|| l_item_key ;

Line 3655: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;

3651: AND item_type = p_item_type;
3652:
3653: l_nos_wf_process_dtls_deleted := l_nos_wf_process_dtls_deleted + SQL%ROWCOUNT;
3654:
3655: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;
3656: x_err_stage := 'Deleting Records from pa_wf_processes table for item key '|| l_item_key ;
3657:
3658:
3659: DELETE pa_wf_processes

Line 3656: x_err_stage := 'Deleting Records from pa_wf_processes table for item key '|| l_item_key ;

3652:
3653: l_nos_wf_process_dtls_deleted := l_nos_wf_process_dtls_deleted + SQL%ROWCOUNT;
3654:
3655: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;
3656: x_err_stage := 'Deleting Records from pa_wf_processes table for item key '|| l_item_key ;
3657:
3658:
3659: DELETE pa_wf_processes
3660: WHERE entity_key1 = TO_CHAR(p_project_id)

Line 3659: DELETE pa_wf_processes

3655: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;
3656: x_err_stage := 'Deleting Records from pa_wf_processes table for item key '|| l_item_key ;
3657:
3658:
3659: DELETE pa_wf_processes
3660: WHERE entity_key1 = TO_CHAR(p_project_id)
3661: AND entity_key2 = l_entity_key
3662: AND wf_type_code = p_wf_type_code
3663: AND item_type = p_item_type;

Line 3694: The procedure is called once for ppa_wf_processes, pa_wf_process_details and pa_wf_ntf_performers tables */

3690: END LOOP;
3691:
3692: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited. This also creates a record in
3693: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.
3694: The procedure is called once for ppa_wf_processes, pa_wf_process_details and pa_wf_ntf_performers tables */
3695:
3696: Pa_Purge.CommitProcess(p_purge_batch_id,
3697: p_project_id,
3698: 'PA_WF_NTF_PERFORMERS',

Line 3718: 'PA_WF_PROCESSES',

3714: ) ;
3715:
3716: Pa_Purge.CommitProcess(p_purge_batch_id,
3717: p_project_id,
3718: 'PA_WF_PROCESSES',
3719: l_nos_wf_process_inserted,
3720: l_nos_wf_process_deleted,
3721: x_err_code,
3722: x_err_stack,

Line 3760: l_item_key pa_wf_processes.item_key%TYPE;

3756: FROM pa_wf_process_details
3757: WHERE NVL(object_id2, object_id1) = x_object_id
3758: AND item_type = p_item_type;
3759:
3760: l_item_key pa_wf_processes.item_key%TYPE;
3761: I PLS_INTEGER;
3762: l_object_id pa_wf_process_details.object_id1%TYPE;
3763: l_nos_wf_process_inserted NUMBER ;
3764: l_nos_wf_process_dtls_inserted NUMBER ;

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 3835: FROM pa_wf_processes

3831: last_update_date,
3832: creation_date,
3833: created_by,
3834: last_update_login
3835: FROM pa_wf_processes
3836: WHERE item_key = l_item_key
3837: AND entity_key1 = TO_CHAR(p_project_id)
3838: AND item_type = p_item_type;
3839:

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 3908: /* To keep the count of no of records deleted from pa_wf_processes and pa_wf_process_details, manipulate the

3904: l_nos_wf_process_dtls_inserted := l_nos_wf_process_dtls_inserted + SQL%ROWCOUNT;
3905:
3906: END IF; -- p_archive_flag='Y'
3907:
3908: /* To keep the count of no of records deleted from pa_wf_processes and pa_wf_process_details, manipulate the
3909: count of l_nos_wf_process_deleted and l_nos_wf_process_dtls_deleted. */
3910:
3911: Pa_Debug.DEBUG('Deleting Records from pa_wf_process_details table ') ;
3912: x_err_stage := 'Deleting Records from pa_wf_process_details table for item key '|| l_item_key ;

Line 3921: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;

3917: AND item_type = p_item_type;
3918:
3919: l_nos_wf_process_dtls_deleted := l_nos_wf_process_dtls_deleted + SQL%ROWCOUNT;
3920:
3921: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;
3922: x_err_stage := 'Deleting Records from pa_wf_processes table for item key '|| l_item_key ;
3923:
3924:
3925: DELETE pa_wf_processes

Line 3922: x_err_stage := 'Deleting Records from pa_wf_processes table for item key '|| l_item_key ;

3918:
3919: l_nos_wf_process_dtls_deleted := l_nos_wf_process_dtls_deleted + SQL%ROWCOUNT;
3920:
3921: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;
3922: x_err_stage := 'Deleting Records from pa_wf_processes table for item key '|| l_item_key ;
3923:
3924:
3925: DELETE pa_wf_processes
3926: WHERE item_key = l_item_key

Line 3925: DELETE pa_wf_processes

3921: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;
3922: x_err_stage := 'Deleting Records from pa_wf_processes table for item key '|| l_item_key ;
3923:
3924:
3925: DELETE pa_wf_processes
3926: WHERE item_key = l_item_key
3927: AND entity_key1 = TO_CHAR(p_project_id)
3928: AND item_type = p_item_type;
3929:

Line 3959: The procedure is called once for pa_wf_processes, pa_wf_process_details and pa_wf_ntf_performers tables */

3955: END LOOP;
3956:
3957: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited. This also creates a record in
3958: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.
3959: The procedure is called once for pa_wf_processes, pa_wf_process_details and pa_wf_ntf_performers tables */
3960:
3961: Pa_Purge.CommitProcess(p_purge_batch_id,
3962: p_project_id,
3963: 'PA_WF_PROCESS_DETAILS',

Line 3973: 'PA_WF_PROCESSES',

3969: ) ;
3970:
3971: Pa_Purge.CommitProcess(p_purge_batch_id,
3972: p_project_id,
3973: 'PA_WF_PROCESSES',
3974: l_nos_wf_process_inserted,
3975: l_nos_wf_process_deleted,
3976: x_err_code,
3977: x_err_stack,

Line 4021: l_item_key pa_wf_processes.item_key%TYPE;

4017: WHERE object_id1 = x_object_id
4018: AND wf_type_code = p_wf_type_code
4019: AND item_type <> 'PAWFAAP';
4020:
4021: l_item_key pa_wf_processes.item_key%TYPE;
4022: l_group_id pa_wf_ntf_performers.group_id%TYPE;
4023: I PLS_INTEGER;
4024: l_object_id pa_wf_ntf_performers.object_id1%TYPE;
4025: l_nos_wf_process_inserted NUMBER ;

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 4097: FROM pa_wf_processes

4093: last_update_date,
4094: creation_date,
4095: created_by,
4096: last_update_login
4097: FROM pa_wf_processes
4098: WHERE ( entity_key2 = TO_CHAR(l_object_id)
4099: OR entity_key2 = TO_CHAR(l_group_id ))
4100: AND entity_key1 = TO_CHAR(p_project_id)
4101: AND wf_type_code = p_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 4174: /* To keep the count of no of records deleted from pa_wf_processes, pa_wf_process_details and pa_wf_ntf_performers,

4170: l_nos_wf_ntf_perf_inserted := l_nos_wf_ntf_perf_inserted + SQL%ROWCOUNT;
4171:
4172: END IF; -- p_archive_flag='Y'
4173:
4174: /* To keep the count of no of records deleted from pa_wf_processes, pa_wf_process_details and pa_wf_ntf_performers,
4175: manipulate the count of l_nos_wf_process_deleted, l_nos_wf_process_dtls_deleted and l_nos_wf_ntf_perf_deleted. */
4176:
4177: Pa_Debug.DEBUG('Deleting Records from pa_wf_ntf_performers table ') ;
4178: x_err_stage := 'Deleting Records from pa_wf_ntf_performers table for assignment_id/group_id '|| l_group_id;

Line 4187: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;

4183: AND item_type <> 'PAWFAAP';
4184:
4185: l_nos_wf_ntf_perf_deleted := l_nos_wf_ntf_perf_deleted + SQL%ROWCOUNT;
4186:
4187: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;
4188: x_err_stage := 'Deleting Records from pa_wf_processes table for assignment_id/group_id '|| l_group_id;
4189:
4190:
4191: DELETE pa_wf_processes

Line 4188: x_err_stage := 'Deleting Records from pa_wf_processes table for assignment_id/group_id '|| l_group_id;

4184:
4185: l_nos_wf_ntf_perf_deleted := l_nos_wf_ntf_perf_deleted + SQL%ROWCOUNT;
4186:
4187: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;
4188: x_err_stage := 'Deleting Records from pa_wf_processes table for assignment_id/group_id '|| l_group_id;
4189:
4190:
4191: DELETE pa_wf_processes
4192: WHERE entity_key1 = TO_CHAR(p_project_id)

Line 4191: DELETE pa_wf_processes

4187: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;
4188: x_err_stage := 'Deleting Records from pa_wf_processes table for assignment_id/group_id '|| l_group_id;
4189:
4190:
4191: DELETE pa_wf_processes
4192: WHERE entity_key1 = TO_CHAR(p_project_id)
4193: aND (entity_key2 = TO_CHAR(l_object_id)
4194: OR entity_key2 = TO_CHAR(l_group_id) )
4195: AND wf_type_code = p_wf_type_code

Line 4227: The procedure is called once for pa_wf_processes and pa_wf_ntf_performers tables */

4223: END LOOP;
4224:
4225: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited. This also creates a record in
4226: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.
4227: The procedure is called once for pa_wf_processes and pa_wf_ntf_performers tables */
4228:
4229: Pa_Purge.CommitProcess(p_purge_batch_id,
4230: p_project_id,
4231: 'PA_WF_NTF_PERFORMERS',

Line 4241: 'PA_WF_PROCESSES',

4237: ) ;
4238:
4239: Pa_Purge.CommitProcess(p_purge_batch_id,
4240: p_project_id,
4241: 'PA_WF_PROCESSES',
4242: l_nos_wf_process_inserted,
4243: l_nos_wf_process_deleted,
4244: x_err_code,
4245: x_err_stack,

Line 4271: -- pa_wf_processes.entity_key2 does not store assignment_id

4267: -- API name : PA_WF_KEY_PURGE
4268: -- Type : Public
4269: -- Pre-reqs : None
4270: -- Function : Procedure for Purging records from Workflow related tables where
4271: -- pa_wf_processes.entity_key2 does not store assignment_id
4272:
4273: PROCEDURE PA_WF_KEY_PURGE ( p_purge_batch_id IN NUMBER,
4274: p_project_id IN NUMBER,
4275: p_purge_release IN VARCHAR2,

Line 4286: FROM pa_wf_processes

4282: x_err_code IN OUT NOCOPY NUMBER ) AS --File.Sql.39 bug 4440895
4283:
4284: CURSOR cur_workflow (x_entity_key VARCHAR2) IS
4285: SELECT item_key
4286: FROM pa_wf_processes
4287: WHERE entity_key1 = TO_CHAR(p_project_id)
4288: AND entity_key2 = x_entity_key
4289: AND wf_type_code = p_wf_type_code
4290: AND item_type = p_item_type;

Line 4292: l_item_key pa_wf_processes.item_key%TYPE;

4288: AND entity_key2 = x_entity_key
4289: AND wf_type_code = p_wf_type_code
4290: AND item_type = p_item_type;
4291:
4292: l_item_key pa_wf_processes.item_key%TYPE;
4293: I PLS_INTEGER;
4294: l_entity_key pa_wf_processes.entity_key2%TYPE;
4295: l_nos_wf_process_inserted NUMBER ;
4296: l_nos_wf_process_deleted NUMBER ;

Line 4294: l_entity_key pa_wf_processes.entity_key2%TYPE;

4290: AND item_type = p_item_type;
4291:
4292: l_item_key pa_wf_processes.item_key%TYPE;
4293: I PLS_INTEGER;
4294: l_entity_key pa_wf_processes.entity_key2%TYPE;
4295: l_nos_wf_process_inserted NUMBER ;
4296: l_nos_wf_process_deleted NUMBER ;
4297:
4298: l_status VARCHAR2(100);

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 4358: FROM pa_wf_processes

4354: last_update_date,
4355: creation_date,
4356: created_by,
4357: last_update_login
4358: FROM pa_wf_processes
4359: WHERE entity_key1 = TO_CHAR(p_project_id)
4360: AND entity_key2 = p_entity_key2
4361: AND wf_type_code = p_wf_type_code
4362: AND item_type = p_item_type;

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:

Line 4371: /* To keep the count of no of records deleted from pa_wf_processes manipulate the count of l_nos_wf_process_deleted. */

4367:
4368:
4369: END IF; -- p_archive_flag='Y'
4370:
4371: /* To keep the count of no of records deleted from pa_wf_processes manipulate the count of l_nos_wf_process_deleted. */
4372:
4373: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;
4374: x_err_stage := 'Deleting Records from pa_wf_processes table for item key '|| l_item_key ;
4375:

Line 4373: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;

4369: END IF; -- p_archive_flag='Y'
4370:
4371: /* To keep the count of no of records deleted from pa_wf_processes manipulate the count of l_nos_wf_process_deleted. */
4372:
4373: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;
4374: x_err_stage := 'Deleting Records from pa_wf_processes table for item key '|| l_item_key ;
4375:
4376:
4377: DELETE pa_wf_processes

Line 4374: x_err_stage := 'Deleting Records from pa_wf_processes table for item key '|| l_item_key ;

4370:
4371: /* To keep the count of no of records deleted from pa_wf_processes manipulate the count of l_nos_wf_process_deleted. */
4372:
4373: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;
4374: x_err_stage := 'Deleting Records from pa_wf_processes table for item key '|| l_item_key ;
4375:
4376:
4377: DELETE pa_wf_processes
4378: WHERE entity_key1 = TO_CHAR(p_project_id)

Line 4377: DELETE pa_wf_processes

4373: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;
4374: x_err_stage := 'Deleting Records from pa_wf_processes table for item key '|| l_item_key ;
4375:
4376:
4377: DELETE pa_wf_processes
4378: WHERE entity_key1 = TO_CHAR(p_project_id)
4379: AND entity_key2 = p_entity_key2
4380: AND wf_type_code = p_wf_type_code
4381: AND item_type = p_item_type;

Line 4410: records that are purged from each table.The procedure is called once for pa_wf_processes tables */

4406: CLOSE cur_workflow;
4407:
4408: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited.
4409: This also creates a record in the Pa_Purge_Project_details, which will show the no. of
4410: records that are purged from each table.The procedure is called once for pa_wf_processes tables */
4411:
4412: Pa_Purge.CommitProcess(p_purge_batch_id,
4413: p_project_id,
4414: 'PA_WF_PROCESSES',

Line 4414: 'PA_WF_PROCESSES',

4410: records that are purged from each table.The procedure is called once for pa_wf_processes tables */
4411:
4412: Pa_Purge.CommitProcess(p_purge_batch_id,
4413: p_project_id,
4414: 'PA_WF_PROCESSES',
4415: l_nos_wf_process_inserted,
4416: l_nos_wf_process_deleted,
4417: x_err_code,
4418: x_err_stack,