APPS.PA_PURGE_CAPITAL dependencies on PA_MC_PRJ_AST_LN_DET_AR

Line 177: l_err_stage := 'Before Inserting into PA_MC_PRJ_AST_LN_DET_AR table';

173: LIMIT l_commit_size;
174:
175: If l_sob.count <> 0 Then
176:
177: l_err_stage := 'Before Inserting into PA_MC_PRJ_AST_LN_DET_AR table';
178:
179: IF p_archive_flag = 'Y' THEN
180:
181: FORALL i in 1..l_sob.count

Line 182: INSERT INTO PA_MC_PRJ_AST_LN_DET_AR

178:
179: IF p_archive_flag = 'Y' THEN
180:
181: FORALL i in 1..l_sob.count
182: INSERT INTO PA_MC_PRJ_AST_LN_DET_AR
183: ( Set_Of_Books_Id,
184: Proj_Asset_Line_Dtl_Uniq_Id,
185: Project_Asset_Line_Detail_Id,
186: Cip_Cost,

Line 309: l_err_stage := 'Before Inserting into PA_MC_PRJ_AST_LN_DET_AR table';

305: -- no. of records specified in the commit size.
306:
307: l_commit_size := p_commit_size / 2 ;
308:
309: l_err_stage := 'Before Inserting into PA_MC_PRJ_AST_LN_DET_AR table';
310:
311: INSERT INTO PA_MC_PRJ_AST_LN_DET_AR
312: ( Set_Of_Books_Id,
313: Proj_Asset_Line_Dtl_Uniq_Id,

Line 311: INSERT INTO PA_MC_PRJ_AST_LN_DET_AR

307: l_commit_size := p_commit_size / 2 ;
308:
309: l_err_stage := 'Before Inserting into PA_MC_PRJ_AST_LN_DET_AR table';
310:
311: INSERT INTO PA_MC_PRJ_AST_LN_DET_AR
312: ( Set_Of_Books_Id,
313: Proj_Asset_Line_Dtl_Uniq_Id,
314: Project_Asset_Line_Detail_Id,
315: Cip_Cost,

Line 356: FROM PA_MC_PRJ_AST_LN_DET_AR pmaldar,

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,
358: PA_Expenditure_Items_All pei
359: WHERE
360: pald.Proj_Asset_Line_Dtl_Uniq_Id =