APPS.PA_PURGE_SUMMARY dependencies on PA_PRJ_ACCUM_HEADERS_AR

Line 78: pa_debug.debug( ' ->Before insert into PA_PRJ_ACCUM_HEADERS_AR') ;

74:
75: l_commit_size := p_commit_size / 2 ;
76:
77:
78: pa_debug.debug( ' ->Before insert into PA_PRJ_ACCUM_HEADERS_AR') ;
79:
80: INSERT INTO PA_PRJ_ACCUM_HEADERS_AR
81: (
82: PURGE_BATCH_ID,

Line 80: INSERT INTO PA_PRJ_ACCUM_HEADERS_AR

76:
77:
78: pa_debug.debug( ' ->Before insert into PA_PRJ_ACCUM_HEADERS_AR') ;
79:
80: INSERT INTO PA_PRJ_ACCUM_HEADERS_AR
81: (
82: PURGE_BATCH_ID,
83: PURGE_RELEASE,
84: PURGE_PROJECT_ID,

Line 138: pa_debug.debug( ' ->After insert into PA_PRJ_ACCUM_HEADERS_AR') ;

134: /*Code Changes for Bug No.2984871 start */
135: l_NoOfRecordsIns := SQL%ROWCOUNT ;
136: /*Code Changes for Bug No.2984871 end */
137:
138: pa_debug.debug( ' ->After insert into PA_PRJ_ACCUM_HEADERS_AR') ;
139:
140: /* Commented for Bug 2984871
141:
142: l_NoOfRecordsIns := SQL%ROWCOUNT ; */

Line 160: PA_PRJ_ACCUM_HEADERS_AR pah2

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: ) ;
164: */

Line 169: FROM PA_PRJ_ACCUM_HEADERS_AR pah2

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
171: ) ;
172:
173: /*Code Changes for Bug No.2984871 start */