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_CAPITAL dependencies on PA_PROJECT_ASSET_LINE_DETAILS

Line 127: PA_Project_Asset_Line_Details pald,

123: pmald.Exchange_Rate,
124: pmald.Conversion_Date
125: FROM
126: PA_Expenditure_Items_All pei ,
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

Line 335: PA_Project_Asset_Line_Details pald,

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
339: AND pald.Expenditure_Item_id = pei.Expenditure_Item_id

Line 357: PA_Project_Asset_Line_Details pald,

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 =
361: pmaldar.Proj_Asset_Line_Dtl_Uniq_Id

Line 381: FROM PA_Project_Asset_Line_Details pald,

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
383: WHERE pald.Expenditure_Item_id = pei.Expenditure_Item_id
384: AND pmald.proj_asset_line_dtl_uniq_id = pald.proj_asset_line_dtl_uniq_id -- Bug 3613739
385: AND pei.project_id = p_project_id)

Line 512: PA_Project_Asset_Line_Details pald,

508: p_purge_batch_id,
509: p_project_id,
510: pald.PROJ_ASSET_LINE_DTL_UNIQ_ID /* Bug#2385541 */
511: FROM
512: PA_Project_Asset_Line_Details pald,
513: PA_Expenditure_Items_All pei
514: WHERE
515: pald.Expenditure_Item_id = pei.Expenditure_Item_id
516: AND pei.project_id = p_project_id

Line 527: l_err_stage := 'Before Deleting from PA_Project_Asset_line_Details table after Archive';

523: -- We have a seperate delete statement if the archive option is
524: -- selected because if archive option is selected the the records
525: -- being purged will be those records which are already archived.
526:
527: l_err_stage := 'Before Deleting from PA_Project_Asset_line_Details table after Archive';
528: /* Bug#2405839: Purge process is not deleting the asset line details since, checking for
529: pald.Project_Asset_Line_Detail_Id in pald1.Proj_Asset_Line_Dtl_Uniq_Id.
530: Commented the delete statement and added the modified delete statement below.
531:

Line 532: DELETE FROM PA_Project_Asset_line_Details pald

528: /* Bug#2405839: Purge process is not deleting the asset line details since, checking for
529: pald.Project_Asset_Line_Detail_Id in pald1.Proj_Asset_Line_Dtl_Uniq_Id.
530: Commented the delete statement and added the modified delete statement below.
531:
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,

Line 535: FROM PA_Project_Asset_line_Details pald1,

531:
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

Line 543: DELETE FROM PA_Project_Asset_line_Details pald

539: pald1.Project_Asset_Line_Detail_Id = paldar.Project_Asset_Line_Detail_Id
540: AND paldar.Expenditure_Item_Id = pei.Expenditure_Item_Id
541: and pei.project_id = p_project_id ) ;
542: */
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

Line 546: FROM PA_Project_Asset_line_Details pald1,

542: */
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

Line 565: l_err_stage := 'Before Deleting from PA_Project_Asset_line_Details table ';

561:
562: -- If the archive option is not selected then the delete will
563: -- be based on the commit size.
564:
565: l_err_stage := 'Before Deleting from PA_Project_Asset_line_Details table ';
566:
567: DELETE FROM PA_Project_Asset_line_Details pald
568: WHERE Expenditure_Item_Id in (SELECT pei.Expenditure_Item_Id
569: FROM PA_Expenditure_Items_All pei

Line 567: DELETE FROM PA_Project_Asset_line_Details pald

563: -- be based on the commit size.
564:
565: l_err_stage := 'Before Deleting from PA_Project_Asset_line_Details table ';
566:
567: DELETE FROM PA_Project_Asset_line_Details pald
568: WHERE Expenditure_Item_Id in (SELECT pei.Expenditure_Item_Id
569: FROM PA_Expenditure_Items_All pei
570: WHERE pei.project_id = p_project_id)
571: AND rownum < l_commit_size ;

Line 594: 'PA_Project_Asset_line_Details',

590: l_err_stage := 'Before Calling PA_Purge.CommitProcess';
591:
592: PA_Purge.CommitProcess( p_purge_batch_id,
593: p_project_id,
594: 'PA_Project_Asset_line_Details',
595: NoOfRecordsIns,
596: NoOfRecordsDel,
597: p_err_code,
598: p_err_stack,