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_SUMMARY dependencies on PA_PROJECT_ACCUM_HEADERS

Line 35: -- Function : Archive and Purge data for table PA_PROJECT_ACCUM_HEADERS

31: -- Start of comments
32: -- API name : PA_PROJACCUMHEADERS
33: -- Type : Private
34: -- Pre-reqs : None
35: -- Function : Archive and Purge data for table PA_PROJECT_ACCUM_HEADERS
36: -- Parameters : See common list above
37: -- End of comments
38:
39: PROCEDURE pa_projaccumheaders

Line 128: FROM pa_project_accum_headers pah

124: pah.PROGRAM_ID,
125: pah.PROGRAM_UPDATE_DATE,
126: pah.TASKS_RESTRUCTURED_FLAG,
127: pah.SUM_EXCEPTION_CODE
128: FROM pa_project_accum_headers pah
129: WHERE ( pah.project_id = p_project_id
130: /* 2485577 */ AND pah.project_accum_id <> g_def_proj_accum_id
131: AND rownum <= l_commit_size
132: ) ;

Line 153: pa_debug.debug( ' ->Before delete from pa_project_accum_headers ') ;

149: /*Code Changes for Bug No.2984871 end */
150: -- The algorithm for deleting records from original table
151: -- depends on whether records are being archived or not.
152:
153: pa_debug.debug( ' ->Before delete from pa_project_accum_headers ') ;
154:
155: /* commented and modified as below for performance reasons. Archive Purge 11.5
156: DELETE FROM pa_project_accum_headers pah
157: WHERE (pah.rowid) IN

Line 156: DELETE FROM pa_project_accum_headers pah

152:
153: pa_debug.debug( ' ->Before delete from pa_project_accum_headers ') ;
154:
155: /* commented and modified as below for performance reasons. Archive Purge 11.5
156: DELETE FROM pa_project_accum_headers pah
157: WHERE (pah.rowid) IN
158: ( SELECT pah1.rowid
159: FROM pa_project_accum_headers pah1,
160: PA_PRJ_ACCUM_HEADERS_AR pah2

Line 159: FROM pa_project_accum_headers pah1,

155: /* commented and modified as below for performance reasons. Archive Purge 11.5
156: DELETE FROM pa_project_accum_headers pah
157: WHERE (pah.rowid) IN
158: ( SELECT pah1.rowid
159: FROM pa_project_accum_headers pah1,
160: PA_PRJ_ACCUM_HEADERS_AR pah2
161: WHERE pah1.project_accum_id = pah2.project_accum_id
162: AND pah2.purge_project_id = p_project_id
163: ) ;

Line 166: DELETE FROM pa_project_accum_headers pah

162: AND pah2.purge_project_id = p_project_id
163: ) ;
164: */
165:
166: DELETE FROM pa_project_accum_headers pah
167: WHERE (pah.project_accum_id) IN
168: ( SELECT pah2.project_accum_id
169: FROM PA_PRJ_ACCUM_HEADERS_AR pah2
170: WHERE pah2.purge_project_id = p_project_id

Line 177: pa_debug.debug( ' ->After delete from pa_project_accum_headers ') ;

173: /*Code Changes for Bug No.2984871 start */
174: l_NoOfRecordsDel := SQL%ROWCOUNT ;
175: /*Code Changes for Bug No.2984871 end */
176:
177: pa_debug.debug( ' ->After delete from pa_project_accum_headers ') ;
178:
179: END IF ;
180: ELSE
181:

Line 188: pa_debug.debug( ' ->Before delete from pa_project_accum_headers ') ;

184: -- If the archive option is not selected then the delete will
185: -- be based on the commit size.
186:
187:
188: pa_debug.debug( ' ->Before delete from pa_project_accum_headers ') ;
189: /* commented and modified as below for performance reasons. Archive Purge 11.5
190: DELETE FROM pa_project_accum_headers pah
191: WHERE (pah.rowid) IN
192: ( SELECT pah.rowid

Line 190: DELETE FROM pa_project_accum_headers pah

186:
187:
188: pa_debug.debug( ' ->Before delete from pa_project_accum_headers ') ;
189: /* commented and modified as below for performance reasons. Archive Purge 11.5
190: DELETE FROM pa_project_accum_headers pah
191: WHERE (pah.rowid) IN
192: ( SELECT pah.rowid
193: FROM pa_project_accum_headers pah
194: WHERE pah.project_id = p_project_id

Line 193: FROM pa_project_accum_headers pah

189: /* commented and modified as below for performance reasons. Archive Purge 11.5
190: DELETE FROM pa_project_accum_headers pah
191: WHERE (pah.rowid) IN
192: ( SELECT pah.rowid
193: FROM pa_project_accum_headers pah
194: WHERE pah.project_id = p_project_id
195: AND rownum <= l_commit_size
196: ) ;
197: */

Line 199: DELETE FROM pa_project_accum_headers pah

195: AND rownum <= l_commit_size
196: ) ;
197: */
198:
199: DELETE FROM pa_project_accum_headers pah
200: WHERE pah.project_id = p_project_id
201: /* 2485577 */ AND pah.project_accum_id <> g_def_proj_accum_id
202: AND rownum <= l_commit_size;
203:

Line 208: pa_debug.debug( ' ->After delete from pa_project_accum_headers ') ;

204:
205: /*Code Changes for Bug No.2984871 start */
206: l_NoOfRecordsDel := SQL%ROWCOUNT ;
207: /*Code Changes for Bug No.2984871 end */
208: pa_debug.debug( ' ->After delete from pa_project_accum_headers ') ;
209: END IF ;
210:
211: /* Commented for Bug 2984871
212: IF SQL%ROWCOUNT = 0 THEN*/

Line 231: p_table_name => 'PA_PROJECT_ACCUM_HEADERS',

227:
228: pa_purge.CommitProcess
229: (p_purge_batch_id => p_purge_batch_id,
230: p_project_id => p_project_id,
231: p_table_name => 'PA_PROJECT_ACCUM_HEADERS',
232: p_NoOfRecordsIns => l_NoOfRecordsIns,
233: p_NoOfRecordsDel => l_NoOfRecordsDel,
234: x_err_code => x_err_code,
235: x_err_stack => x_err_stack,

Line 370: pa_project_accum_headers pah

366: /* commented and modified as below for performance reasons. Archive Purge 11.5
367: WHERE (pac.rowid) IN
368: ( SELECT pac1.rowid
369: FROM pa_project_accum_commitments pac1,
370: pa_project_accum_headers pah
371: WHERE pac1.project_accum_id=pah.project_accum_id
372: AND pah.project_id = p_project_id
373: AND rownum < l_commit_size
374: ) ;

Line 378: FROM pa_project_accum_headers pah

374: ) ;
375: */
376: WHERE (pac.project_accum_id) in
377: ( SELECT pah.project_accum_id
378: FROM pa_project_accum_headers pah
379: WHERE pah.project_id = p_project_id
380: /* 2485577 */ AND pah.project_accum_id <> g_def_proj_accum_id
381: AND rownum < l_commit_size
382: ) ;

Line 430: pa_project_accum_headers pah

426: DELETE FROM pa_project_accum_commitments pac
427: WHERE (pac.rowid) IN
428: ( SELECT pac1.rowid
429: FROM pa_project_accum_commitments pac1,
430: pa_project_accum_headers pah
431: WHERE pac1.project_accum_id=pah.project_accum_id
432: AND pah.project_id = p_project_id
433: AND rownum <= l_commit_size
434: ) ;

Line 440: FROM pa_project_accum_headers pah

436:
437: DELETE FROM pa_project_accum_commitments pac
438: WHERE (pac.project_accum_id) IN
439: ( SELECT pah.project_accum_id
440: FROM pa_project_accum_headers pah
441: WHERE pah.project_id = p_project_id
442: /* 2485577 */ AND pah.project_accum_id <> g_def_proj_accum_id
443: AND rownum <= l_commit_size
444: ) ;

Line 682: Pa_project_accum_headers pah

678: FROM pa_Project_Accum_Budgets pab
679: /* commented and modified as below for performance reasons. Archive Purge 11.5
680: WHERE (pab.rowid) IN
681: (SELECT pab1.rowid FROM pa_project_accum_budgets pab1,
682: Pa_project_accum_headers pah
683: WHERE pab1.project_accum_id=pah.project_accum_id
684: AND pah.project_id = p_project_id
685: AND rownum < l_commit_size
686: ) ;

Line 690: FROM Pa_project_accum_headers pah

686: ) ;
687: */
688: WHERE (pab.project_accum_id) IN
689: (SELECT pah.project_accum_id
690: FROM Pa_project_accum_headers pah
691: WHERE pah.project_id = p_project_id
692: /* 2485577 */ AND pah.project_accum_id <> g_def_proj_accum_id
693: AND rownum < l_commit_size
694: ) ;

Line 749: pa_project_accum_headers pah

745: --Fix for bug#7701114
746: DELETE FROM pa_project_accum_budgets ppab
747: WHERE (ppab.project_accum_id) IN (SELECT pab.project_accum_id
748: FROM pa_project_accum_commitments pab,
749: pa_project_accum_headers pah
750: WHERE pab.project_accum_id=pah.project_accum_id
751: AND pah.project_id = p_project_id
752: /* 2485577 */ AND pah.project_accum_id <> g_def_proj_accum_id)
753: AND rownum <= l_commit_size;

Line 958: pa_project_accum_headers pah

954: FROM pa_Project_Accum_Actuals paa
955: /* commented and modified as below for performance reasons. Archive Purge 11.5
956: WHERE (paa.rowid) IN
957: (SELECT paa1.rowid FROM pa_project_accum_actuals paa1,
958: pa_project_accum_headers pah
959: WHERE paa1.project_accum_id=pah.project_accum_id
960: AND pah.project_id = p_project_id
961: AND rownum < l_commit_size
962: ) ;

Line 966: FROM pa_project_accum_headers pah

962: ) ;
963: */
964: WHERE (paa.project_accum_id) IN
965: (SELECT pah.project_accum_id
966: FROM pa_project_accum_headers pah
967: WHERE pah.project_id = p_project_id
968: /* 2485577 */ AND pah.project_accum_id <> g_def_proj_accum_id
969: AND rownum < l_commit_size
970: ) ;

Line 1022: pa_project_accum_headers pah

1018: DELETE from pa_project_accum_actuals paa
1019: WHERE (paa.rowid) IN
1020: ( SELECT paa1.rowid
1021: FROM pa_project_accum_actuals paa1,
1022: pa_project_accum_headers pah
1023: WHERE paa1.project_accum_id=pah.project_accum_id
1024: AND pah.project_id = p_project_id
1025: AND rownum <= l_commit_size
1026: ) ;

Line 1031: FROM pa_project_accum_headers pah

1027: */
1028: DELETE from pa_project_accum_actuals paa
1029: WHERE (paa.project_accum_id) IN
1030: ( SELECT pah.project_accum_id
1031: FROM pa_project_accum_headers pah
1032: WHERE pah.project_id = p_project_id
1033: /* 2485577 */ AND pah.project_accum_id <> g_def_proj_accum_id
1034: AND rownum <= l_commit_size
1035: ) ;

Line 1841: FROM PA_Project_Accum_Headers

1837: purged. */
1838:
1839: Select Project_Accum_Id
1840: INTO g_def_proj_accum_id
1841: FROM PA_Project_Accum_Headers
1842: WHERE Project_Id = p_project_id
1843: AND Task_Id = 0
1844: AND Resource_Id = 0
1845: AND Resource_List_Assignment_Id = 0

Line 1908: pa_debug.debug('*-> About to purge PA_Project_Accum_Headers ') ;

1904: x_err_stack => x_err_stack,
1905: x_err_stage => x_err_stage
1906: ) ;
1907:
1908: pa_debug.debug('*-> About to purge PA_Project_Accum_Headers ') ;
1909: pa_purge_summary.PA_ProjAccumHeaders
1910: (p_purge_batch_id => p_purge_batch_id,
1911: p_project_id => p_project_id,
1912: p_txn_to_date => p_txn_to_date,