APPS.PA_PURGE_CAPITAL dependencies on PA_PRJ_ASSET_LN_DETS_AR

Line 460: p_err_stack := p_err_stack || ' ->Before insert into PA_PRJ_ASSET_LN_DETS_AR' ;

456: p_err_code := 0;
457:
458: l_old_err_stack := p_err_stack;
459:
460: p_err_stack := p_err_stack || ' ->Before insert into PA_PRJ_ASSET_LN_DETS_AR' ;
461:
462: LOOP
463:
464: IF p_archive_flag = 'Y' THEN

Line 471: l_err_stage := 'Before Inserting into PA_PRJ_ASSET_LN_DETS_AR table';

467: -- no. of records specified in the commit size.
468:
469: l_commit_size := p_commit_size / 2 ;
470:
471: l_err_stage := 'Before Inserting into PA_PRJ_ASSET_LN_DETS_AR table';
472:
473: INSERT INTO PA_PRJ_ASSET_LN_DETS_AR
474: ( Expenditure_Item_Id,
475: Line_Num,

Line 473: INSERT INTO PA_PRJ_ASSET_LN_DETS_AR

469: l_commit_size := p_commit_size / 2 ;
470:
471: l_err_stage := 'Before Inserting into PA_PRJ_ASSET_LN_DETS_AR table';
472:
473: INSERT INTO PA_PRJ_ASSET_LN_DETS_AR
474: ( Expenditure_Item_Id,
475: Line_Num,
476: Project_Asset_Line_Detail_Id,
477: Cip_Cost,

Line 536: PA_PRJ_ASSET_LN_DETS_AR paldar,

532: DELETE FROM PA_Project_Asset_line_Details pald
533: WHERE (pald.Project_Asset_Line_Detail_Id) IN
534: ( SELECT pald1.Proj_Asset_Line_Dtl_Uniq_Id
535: FROM PA_Project_Asset_line_Details pald1,
536: PA_PRJ_ASSET_LN_DETS_AR paldar,
537: PA_Expenditure_Items_All pei
538: WHERE
539: pald1.Project_Asset_Line_Detail_Id = paldar.Project_Asset_Line_Detail_Id
540: AND paldar.Expenditure_Item_Id = pei.Expenditure_Item_Id

Line 547: PA_PRJ_ASSET_LN_DETS_AR paldar

543: DELETE FROM PA_Project_Asset_line_Details pald
544: WHERE (pald.PROJ_ASSET_LINE_DTL_UNIQ_ID) IN
545: ( SELECT paldar.PROJ_ASSET_LINE_DTL_UNIQ_ID
546: FROM PA_Project_Asset_line_Details pald1,
547: PA_PRJ_ASSET_LN_DETS_AR paldar
548: WHERE
549: pald1.PROJ_ASSET_LINE_DTL_UNIQ_ID = paldar.PROJ_ASSET_LINE_DTL_UNIQ_ID
550: AND paldar.Purge_project_id = p_project_id
551: AND pald1.Project_Asset_Line_Detail_Id = paldar.Project_Asset_Line_Detail_Id) ;