APPS.PA_PURGE_CAPITAL dependencies on PA_MC_PRJ_AST_LINE_DTLS

Line 131: PA_MC_Prj_Ast_Line_Dtls pmald

127: PA_Project_Asset_Line_Details pald,
128: pa_implementations_all pia ,
129: -- gl_mc_reporting_options gmc ,
130: GL_ALC_LEDGER_RSHIPS_V gmc, -- R12 Ledger changes
131: PA_MC_Prj_Ast_Line_Dtls pmald
132: WHERE
133: pald.proj_asset_line_dtl_uniq_id = pmald.proj_asset_line_dtl_uniq_id
134: AND pald.Expenditure_Item_id = pei.Expenditure_Item_id
135: AND pei.project_id = p_project_id

Line 211: Delete From PA_MC_Prj_Ast_line_Dtls

207:
208: End If;
209:
210: FORALL i in 1..l_sob.count
211: Delete From PA_MC_Prj_Ast_line_Dtls
212: Where SET_OF_BOOKS_ID = l_sob(i)
213: And PROJ_ASSET_LINE_DTL_UNIQ_ID = l_asset_line_uniq_id(i);
214:
215: NoOfRecordsDel := l_sob.count ;

Line 228: 'PA_MC_Prj_Ast_line_Dtls',

224: l_err_stage := 'Before Calling PA_Purge.CommitProcess';
225:
226: PA_Purge.CommitProcess(p_purge_batch_id,
227: p_project_id,
228: 'PA_MC_Prj_Ast_line_Dtls',
229: NoOfRecordsIns,
230: NoOfRecordsDel,
231: p_err_code,
232: p_err_stack,

Line 334: PA_MC_Prj_Ast_Line_Dtls pmald,

330: p_purge_release,
331: p_purge_batch_id,
332: p_project_id
333: FROM
334: PA_MC_Prj_Ast_Line_Dtls pmald,
335: PA_Project_Asset_Line_Details pald,
336: PA_Expenditure_Items_All pei
337: WHERE
338: pald.proj_asset_line_dtl_uniq_id = pmald.proj_asset_line_dtl_uniq_id

Line 351: l_err_stage := 'Before Deleting from PA_MC_Prj_Ast_line_Dtls table after Archive';

347: -- We have a seperate delete statement if the archive option is
348: -- selected because if archive option is selected the the records
349: -- being purged will be those records which are already archived.
350:
351: l_err_stage := 'Before Deleting from PA_MC_Prj_Ast_line_Dtls table after Archive';
352:
353: DELETE FROM PA_MC_Prj_Ast_line_Dtls pmald
354: WHERE (pmald.Proj_Asset_Line_Dtl_Uniq_Id) in
355: ( SELECT pmaldar.Proj_Asset_Line_Dtl_Uniq_Id

Line 353: DELETE FROM PA_MC_Prj_Ast_line_Dtls pmald

349: -- being purged will be those records which are already archived.
350:
351: l_err_stage := 'Before Deleting from PA_MC_Prj_Ast_line_Dtls table after Archive';
352:
353: DELETE FROM PA_MC_Prj_Ast_line_Dtls pmald
354: WHERE (pmald.Proj_Asset_Line_Dtl_Uniq_Id) in
355: ( SELECT pmaldar.Proj_Asset_Line_Dtl_Uniq_Id
356: FROM PA_MC_PRJ_AST_LN_DET_AR pmaldar,
357: PA_Project_Asset_Line_Details pald,

Line 376: l_err_stage := 'Before Deleting from PA_MC_Prj_Ast_line_Dtls table ';

372:
373: -- If the archive option is not selected then the delete will
374: -- be based on the commit size.
375:
376: l_err_stage := 'Before Deleting from PA_MC_Prj_Ast_line_Dtls table ';
377:
378: DELETE FROM PA_MC_Prj_Ast_line_Dtls pmald
379: WHERE Exists ---- Bug 3613739 proj_asset_line_dtl_uniq_id IN
380: (SELECT proj_asset_line_dtl_uniq_id

Line 378: DELETE FROM PA_MC_Prj_Ast_line_Dtls pmald

374: -- be based on the commit size.
375:
376: l_err_stage := 'Before Deleting from PA_MC_Prj_Ast_line_Dtls table ';
377:
378: DELETE FROM PA_MC_Prj_Ast_line_Dtls pmald
379: WHERE Exists ---- Bug 3613739 proj_asset_line_dtl_uniq_id IN
380: (SELECT proj_asset_line_dtl_uniq_id
381: FROM PA_Project_Asset_Line_Details pald,
382: PA_Expenditure_Items_All pei

Line 409: 'PA_MC_Prj_Ast_line_Dtls',

405: l_err_stage := 'Before Calling PA_Purge.CommitProcess';
406:
407: PA_Purge.CommitProcess( p_purge_batch_id,
408: p_project_id,
409: 'PA_MC_Prj_Ast_line_Dtls',
410: NoOfRecordsIns,
411: NoOfRecordsDel,
412: p_err_code,
413: p_err_stack,