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

Line 3389: -- pa_wf_process-details.object_id1.

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

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 3553: FROM pa_wf_process_details

3549: last_update_date,
3550: creation_date,
3551: created_by,
3552: last_update_login
3553: FROM pa_wf_process_details
3554: WHERE item_key = l_item_key
3555: AND object_id1 = l_entity_key
3556: AND wf_type_code = p_wf_type_code
3557: AND item_type = p_item_type;

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

3640: AND item_type = p_item_type;
3641:
3642: l_nos_wf_ntf_perf_deleted := l_nos_wf_ntf_perf_deleted + SQL%ROWCOUNT;
3643:
3644: Pa_Debug.DEBUG('Deleting Records from pa_wf_process_details table ') ;
3645: x_err_stage := 'Deleting Records from pa_wf_process_details table for item key '|| l_item_key ;
3646:
3647: DELETE pa_wf_process_details
3648: WHERE object_id2 = TO_CHAR(p_project_id)

Line 3645: x_err_stage := 'Deleting Records from pa_wf_process_details table for item key '|| l_item_key ;

3641:
3642: l_nos_wf_ntf_perf_deleted := l_nos_wf_ntf_perf_deleted + SQL%ROWCOUNT;
3643:
3644: Pa_Debug.DEBUG('Deleting Records from pa_wf_process_details table ') ;
3645: x_err_stage := 'Deleting Records from pa_wf_process_details table for item key '|| l_item_key ;
3646:
3647: DELETE pa_wf_process_details
3648: WHERE object_id2 = TO_CHAR(p_project_id)
3649: AND object_id1 = l_entity_key

Line 3647: DELETE pa_wf_process_details

3643:
3644: Pa_Debug.DEBUG('Deleting Records from pa_wf_process_details table ') ;
3645: x_err_stage := 'Deleting Records from pa_wf_process_details table for item key '|| l_item_key ;
3646:
3647: DELETE pa_wf_process_details
3648: WHERE object_id2 = TO_CHAR(p_project_id)
3649: AND object_id1 = l_entity_key
3650: AND wf_type_code = p_wf_type_code
3651: 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 3708: 'PA_WF_PROCESS_DETAILS',

3704: ) ;
3705:
3706: Pa_Purge.CommitProcess(p_purge_batch_id,
3707: p_project_id,
3708: 'PA_WF_PROCESS_DETAILS',
3709: l_nos_wf_process_dtls_inserted,
3710: l_nos_wf_process_dtls_deleted,
3711: x_err_code,
3712: x_err_stack,

Line 3756: FROM pa_wf_process_details

3752: x_err_code IN OUT NOCOPY NUMBER ) AS --File.Sql.39 bug 4440895
3753:
3754: CURSOR cur_workflow (x_object_id VARCHAR2) IS
3755: SELECT item_key
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;

Line 3762: l_object_id pa_wf_process_details.object_id1%TYPE;

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 ;
3765: l_nos_wf_process_deleted NUMBER ;
3766: l_nos_wf_process_dtls_deleted NUMBER ;

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 3897: FROM pa_wf_process_details

3893: last_update_date,
3894: creation_date,
3895: created_by,
3896: last_update_login
3897: FROM pa_wf_process_details
3898: WHERE item_key = l_item_key
3899: AND NVL(object_id2, object_id1) = TO_CHAR(l_object_id)
3900: AND item_type = p_item_type;
3901:

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

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 ;
3913:
3914: DELETE pa_wf_process_details
3915: WHERE item_key = l_item_key

Line 3912: x_err_stage := 'Deleting Records from pa_wf_process_details table for item key '|| l_item_key ;

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 ;
3913:
3914: DELETE pa_wf_process_details
3915: WHERE item_key = l_item_key
3916: AND NVL(object_id2, object_id1) = TO_CHAR(l_object_id)

Line 3914: DELETE pa_wf_process_details

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 ;
3913:
3914: DELETE pa_wf_process_details
3915: WHERE item_key = l_item_key
3916: AND NVL(object_id2, object_id1) = TO_CHAR(l_object_id)
3917: AND item_type = p_item_type;
3918:

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 3963: 'PA_WF_PROCESS_DETAILS',

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',
3964: l_nos_wf_process_dtls_inserted,
3965: l_nos_wf_process_dtls_deleted,
3966: x_err_code,
3967: x_err_stack,

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'

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;