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_NTF_PERFORMERS

Line 718: and also from pa_wf_ntf_performers table*/

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) ;
722:

Line 1721: and also from pa_wf_ntf_performers table*/

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) ;
1725:

Line 2128: and also from pa_wf_ntf_performers table*/

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) ;
2132:

Line 2239: and also from pa_wf_ntf_performers table*/

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) ;
2243:

Line 2965: and also from pa_wf_ntf_performers table*/

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) ;
2969:

Line 3390: -- pa_wf_ntf_performers.object_id1.

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,
3393: p_project_id IN NUMBER,
3394: p_purge_release IN VARCHAR2,

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 3618: FROM pa_wf_ntf_performers

3614: SYSDATE,
3615: SYSDATE,
3616: Fnd_Global.user_id,
3617: Fnd_Global.login_id
3618: FROM pa_wf_ntf_performers
3619: WHERE object_id2 = TO_CHAR(p_project_id)
3620: AND object_id1 = l_entity_key
3621: AND wf_type_code = p_wf_type_code
3622: AND item_type = p_item_type;

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 3633: Pa_Debug.DEBUG('Deleting Records from pa_wf_ntf_performers table ') ;

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 ;
3635:
3636: DELETE pa_wf_ntf_performers
3637: WHERE object_id2 = TO_CHAR(p_project_id)

Line 3634: x_err_stage := 'Deleting Records from pa_wf_ntf_performers table for item key '|| l_item_key ;

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 ;
3635:
3636: DELETE pa_wf_ntf_performers
3637: WHERE object_id2 = TO_CHAR(p_project_id)
3638: AND object_id1 = l_entity_key

Line 3636: DELETE pa_wf_ntf_performers

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 ;
3635:
3636: DELETE pa_wf_ntf_performers
3637: WHERE object_id2 = TO_CHAR(p_project_id)
3638: AND object_id1 = l_entity_key
3639: AND wf_type_code = p_wf_type_code
3640: 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 3698: 'PA_WF_NTF_PERFORMERS',

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',
3699: l_nos_wf_ntf_perf_inserted,
3700: l_nos_wf_ntf_perf_deleted,
3701: x_err_code,
3702: x_err_stack,

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 4016: FROM pa_wf_ntf_performers

4012: x_err_code IN OUT NOCOPY NUMBER ) AS --File.Sql.39 bug 4440895
4013:
4014: CURSOR cur_workflow (x_object_id VARCHAR2) IS
4015: SELECT item_key, group_id
4016: FROM pa_wf_ntf_performers
4017: WHERE object_id1 = x_object_id
4018: AND wf_type_code = p_wf_type_code
4019: AND item_type <> 'PAWFAAP';
4020:

Line 4022: l_group_id pa_wf_ntf_performers.group_id%TYPE;

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 ;
4026: l_nos_wf_ntf_perf_inserted NUMBER ;

Line 4024: l_object_id pa_wf_ntf_performers.object_id1%TYPE;

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 ;
4026: l_nos_wf_ntf_perf_inserted NUMBER ;
4027: l_nos_wf_process_deleted NUMBER ;
4028: l_nos_wf_ntf_perf_deleted NUMBER ;

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,

Line 4163: FROM pa_wf_ntf_performers

4159: SYSDATE,
4160: SYSDATE,
4161: Fnd_Global.user_id,
4162: Fnd_Global.login_id
4163: FROM pa_wf_ntf_performers
4164: WHERE object_id1 = TO_CHAR(l_object_id)
4165: AND wf_type_code = p_wf_type_code
4166: AND item_type <> 'PAWFAAP';
4167:

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 4177: Pa_Debug.DEBUG('Deleting Records from pa_wf_ntf_performers table ') ;

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;
4179:
4180: DELETE pa_wf_ntf_performers
4181: WHERE object_id1 = TO_CHAR(l_object_id)

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

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;
4179:
4180: DELETE pa_wf_ntf_performers
4181: WHERE object_id1 = TO_CHAR(l_object_id)
4182: AND wf_type_code = p_wf_type_code

Line 4180: DELETE pa_wf_ntf_performers

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;
4179:
4180: DELETE pa_wf_ntf_performers
4181: WHERE object_id1 = TO_CHAR(l_object_id)
4182: AND wf_type_code = p_wf_type_code
4183: AND item_type <> 'PAWFAAP';
4184:

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 4231: 'PA_WF_NTF_PERFORMERS',

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',
4232: l_nos_wf_ntf_perf_inserted,
4233: l_nos_wf_ntf_perf_deleted,
4234: x_err_code,
4235: x_err_stack,