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_PROJECT_PARTIES

Line 476: /* Call conflicts API to archive/purge data from pa_project_parties table */

472: x_err_stage =>x_err_stage,
473: x_err_code =>x_err_code);
474:
475:
476: /* Call conflicts API to archive/purge data from pa_project_parties table */
477:
478: pa_debug.debug(' About to purge pa_project_parties data related to assignments') ;
479: x_err_stage := 'About to purge assignment related project parties data'||to_char(p_project_id) ;
480:

Line 478: pa_debug.debug(' About to purge pa_project_parties data related to assignments') ;

474:
475:
476: /* Call conflicts API to archive/purge data from pa_project_parties table */
477:
478: pa_debug.debug(' About to purge pa_project_parties data related to assignments') ;
479: x_err_stage := 'About to purge assignment related project parties data'||to_char(p_project_id) ;
480:
481: pa_purge_pjr_txns.pa_project_parties_purge( p_purge_batch_id =>p_purge_batch_id,
482: p_project_id =>p_project_id,

Line 481: pa_purge_pjr_txns.pa_project_parties_purge( p_purge_batch_id =>p_purge_batch_id,

477:
478: pa_debug.debug(' About to purge pa_project_parties data related to assignments') ;
479: x_err_stage := 'About to purge assignment related project parties data'||to_char(p_project_id) ;
480:
481: pa_purge_pjr_txns.pa_project_parties_purge( p_purge_batch_id =>p_purge_batch_id,
482: p_project_id =>p_project_id,
483: p_purge_release =>p_purge_release,
484: p_assignment_id_tab =>l_assignment_id_tab,
485: p_archive_flag =>p_archive_flag,

Line 605: /* Call conflicts API to archive/purge data from pa_project_parties table */

601: x_err_stage =>x_err_stage,
602: x_err_code =>x_err_code);
603:
604:
605: /* Call conflicts API to archive/purge data from pa_project_parties table */
606:
607: pa_debug.debug(' About to purge pa_project_parties data related to assignments') ;
608: x_err_stage := 'About to purge assignment related project parties data'||to_char(p_project_id) ;
609:

Line 607: pa_debug.debug(' About to purge pa_project_parties data related to assignments') ;

603:
604:
605: /* Call conflicts API to archive/purge data from pa_project_parties table */
606:
607: pa_debug.debug(' About to purge pa_project_parties data related to assignments') ;
608: x_err_stage := 'About to purge assignment related project parties data'||to_char(p_project_id) ;
609:
610: pa_purge_pjr_txns.pa_project_parties_purge( p_purge_batch_id =>p_purge_batch_id,
611: p_project_id =>p_project_id,

Line 610: pa_purge_pjr_txns.pa_project_parties_purge( p_purge_batch_id =>p_purge_batch_id,

606:
607: pa_debug.debug(' About to purge pa_project_parties data related to assignments') ;
608: x_err_stage := 'About to purge assignment related project parties data'||to_char(p_project_id) ;
609:
610: pa_purge_pjr_txns.pa_project_parties_purge( p_purge_batch_id =>p_purge_batch_id,
611: p_project_id =>p_project_id,
612: p_purge_release =>p_purge_release,
613: p_assignment_id_tab =>l_assignment_id_tab,
614: p_archive_flag =>p_archive_flag,

Line 2754: -- API name : PA_PROJECT_PARTIES_PURGE

2750:
2751:
2752:
2753: -- Start of comments
2754: -- API name : PA_PROJECT_PARTIES_PURGE
2755: -- Type : Public
2756: -- Pre-reqs : None
2757: -- Function : Main purge procedure for Purging records from PA_PROJECT_PARTIES table
2758:

Line 2757: -- Function : Main purge procedure for Purging records from PA_PROJECT_PARTIES table

2753: -- Start of comments
2754: -- API name : PA_PROJECT_PARTIES_PURGE
2755: -- Type : Public
2756: -- Pre-reqs : None
2757: -- Function : Main purge procedure for Purging records from PA_PROJECT_PARTIES table
2758:
2759:
2760: Procedure PA_PROJECT_PARTIES_PURGE ( p_purge_batch_id in NUMBER,
2761: p_project_id in NUMBER,

Line 2760: Procedure PA_PROJECT_PARTIES_PURGE ( p_purge_batch_id in NUMBER,

2756: -- Pre-reqs : None
2757: -- Function : Main purge procedure for Purging records from PA_PROJECT_PARTIES table
2758:
2759:
2760: Procedure PA_PROJECT_PARTIES_PURGE ( p_purge_batch_id in NUMBER,
2761: p_project_id in NUMBER,
2762: p_purge_release in VARCHAR2,
2763: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
2764: p_archive_flag in VARCHAR2,

Line 2791: pa_debug.debug('Inserting Records into PA_project_parties_AR table ') ;

2787: FOR I in p_assignment_id_tab.FIRST .. p_assignment_id_tab.LAST LOOP
2788: l_assignment_id :=p_assignment_id_tab(I);
2789:
2790: IF p_archive_flag='Y' THEN
2791: pa_debug.debug('Inserting Records into PA_project_parties_AR table ') ;
2792: x_err_stage := 'Inserting Records into pa_project_parties_AR table for assignment id '||to_char(l_assignment_id);
2793:
2794: INSERT INTO PA_PROJECT_PARTIES_AR
2795: (PURGE_BATCH_ID,

Line 2792: x_err_stage := 'Inserting Records into pa_project_parties_AR table for assignment id '||to_char(l_assignment_id);

2788: l_assignment_id :=p_assignment_id_tab(I);
2789:
2790: IF p_archive_flag='Y' THEN
2791: pa_debug.debug('Inserting Records into PA_project_parties_AR table ') ;
2792: x_err_stage := 'Inserting Records into pa_project_parties_AR table for assignment id '||to_char(l_assignment_id);
2793:
2794: INSERT INTO PA_PROJECT_PARTIES_AR
2795: (PURGE_BATCH_ID,
2796: PURGE_RELEASE,

Line 2794: INSERT INTO PA_PROJECT_PARTIES_AR

2790: IF p_archive_flag='Y' THEN
2791: pa_debug.debug('Inserting Records into PA_project_parties_AR table ') ;
2792: x_err_stage := 'Inserting Records into pa_project_parties_AR table for assignment id '||to_char(l_assignment_id);
2793:
2794: INSERT INTO PA_PROJECT_PARTIES_AR
2795: (PURGE_BATCH_ID,
2796: PURGE_RELEASE,
2797: PURGE_PROJECT_ID,
2798: PROJECT_PARTY_ID,

Line 2838: FROM PA_PROJECT_PARTIES WHERE project_party_id = (SELECT project_party_id from pa_project_assignments

2834: Last_Update_Date,
2835: Last_Updated_By,
2836: Last_Update_Login,
2837: Grant_Id
2838: FROM PA_PROJECT_PARTIES WHERE project_party_id = (SELECT project_party_id from pa_project_assignments
2839: WHERE assignment_id=l_assignment_id);
2840:
2841: /*Increase the value of l_assignments_his_inserted to indicate number of records inserted in assignments_history_ar
2842: table. The value will increase for each loop*/

Line 2848: /*To keep the count of no of records deleted from pa_project_parties, manipulate the

2844: l_nos_parties_inserted := l_nos_parties_inserted + SQL%ROWCOUNT;
2845:
2846: END IF;
2847:
2848: /*To keep the count of no of records deleted from pa_project_parties, manipulate the
2849: count of l_nos_parties_deleted */
2850:
2851: pa_debug.debug('Deleting Records from pa_project_parties table ') ;
2852: x_err_stage := 'Deleting Records from pa_project_parties table for id '||to_char(l_assignment_id) ;

Line 2851: pa_debug.debug('Deleting Records from pa_project_parties table ') ;

2847:
2848: /*To keep the count of no of records deleted from pa_project_parties, manipulate the
2849: count of l_nos_parties_deleted */
2850:
2851: pa_debug.debug('Deleting Records from pa_project_parties table ') ;
2852: x_err_stage := 'Deleting Records from pa_project_parties table for id '||to_char(l_assignment_id) ;
2853:
2854: DELETE PA_PROJECT_PARTIES
2855: WHERE project_party_id =(SELECT project_party_id FROM pa_project_assignments

Line 2852: x_err_stage := 'Deleting Records from pa_project_parties table for id '||to_char(l_assignment_id) ;

2848: /*To keep the count of no of records deleted from pa_project_parties, manipulate the
2849: count of l_nos_parties_deleted */
2850:
2851: pa_debug.debug('Deleting Records from pa_project_parties table ') ;
2852: x_err_stage := 'Deleting Records from pa_project_parties table for id '||to_char(l_assignment_id) ;
2853:
2854: DELETE PA_PROJECT_PARTIES
2855: WHERE project_party_id =(SELECT project_party_id FROM pa_project_assignments
2856: WHERE assignment_id=l_assignment_id);

Line 2854: DELETE PA_PROJECT_PARTIES

2850:
2851: pa_debug.debug('Deleting Records from pa_project_parties table ') ;
2852: x_err_stage := 'Deleting Records from pa_project_parties table for id '||to_char(l_assignment_id) ;
2853:
2854: DELETE PA_PROJECT_PARTIES
2855: WHERE project_party_id =(SELECT project_party_id FROM pa_project_assignments
2856: WHERE assignment_id=l_assignment_id);
2857:
2858: l_nos_parties_deleted :=l_nos_parties_deleted + SQL%ROWCOUNT;

Line 2864: 'PA_PROJECT_PARTIES',

2860: END LOOP;
2861:
2862: pa_purge.CommitProcess(p_purge_batch_id,
2863: p_project_id,
2864: 'PA_PROJECT_PARTIES',
2865: l_nos_parties_inserted,
2866: l_nos_parties_deleted,
2867: x_err_code,
2868: x_err_stack,

Line 2879: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_PROJECT_PARTIES_PURGE' );

2875: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2876: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2877:
2878: WHEN OTHERS THEN
2879: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_PROJECT_PARTIES_PURGE' );
2880: pa_debug.debug('Error stage is '||x_err_stage );
2881: pa_debug.debug('Error stack is '||x_err_stack );
2882: pa_debug.debug(SQLERRM);
2883: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 2887: End Pa_Project_Parties_Purge;

2883: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2884:
2885: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2886:
2887: End Pa_Project_Parties_Purge;
2888:
2889:
2890: -- Start of comments
2891: -- API name : PA_ADVERTISEMENTS_PURGE