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_ICIP dependencies on PA_DRAFT_INVOICES_ALL

Line 390: /* The new column pa_draft_invoices_all.purge_flag will be updated with 'Y'

386: and mdir.draft_invoice_detail_id = mdi.draft_invoice_detail_id);
387:
388: l_MRC_NoOfRecordsDel := SQL%ROWCOUNT; */
389:
390: /* The new column pa_draft_invoices_all.purge_flag will be updated with 'Y'
391: whenever any of the source project is purged. Since we have to show
392: appropriate message, in the case of Drilldown from Intercompany Invoice
393: to source Expenditure items, will not have a performance hit as we would
394: know upfront that the at least one of the source project has been purged.

Line 397: update pa_draft_invoices_all di

393: to source Expenditure items, will not have a performance hit as we would
394: know upfront that the at least one of the source project has been purged.
395: */
396:
397: update pa_draft_invoices_all di
398: set di.purge_flag = 'Y'
399: where ( di.project_id, di.draft_invoice_num ) in
400: ( select did.project_id, did.draft_invoice_num
401: from pa_draft_inv_dets_ar did

Line 471: /* The new column pa_draft_invoices_all.purge_flag will be updated with 'Y'

467: and rownum < l_pmy_commit_size;
468:
469: l_MRC_NoOfRecordsDel := SQL%ROWCOUNT ; */
470:
471: /* The new column pa_draft_invoices_all.purge_flag will be updated with 'Y'
472: whenever any of the source project is purged. Since we have to show
473: appropriate message, in the case of Drilldown from Intercompany Invoice
474: to source Expenditure items, will not have a performance hit as we would
475: know upfront that the at least one of the source project has been purged.

Line 478: update pa_draft_invoices_all di

474: to source Expenditure items, will not have a performance hit as we would
475: know upfront that the at least one of the source project has been purged.
476: */
477:
478: update pa_draft_invoices_all di
479: set di.purge_flag = 'Y'
480: where ( di.project_id, di.draft_invoice_num ) in
481: ( select did.project_id, did.draft_invoice_num
482: from pa_draft_invoice_details_all did

Line 541: /* The new column pa_draft_invoices_all.purge_flag will be updated with 'Y'

537:
538: l_MRC_NoOfRecordsDel := SQL%ROWCOUNT ; */
539:
540:
541: /* The new column pa_draft_invoices_all.purge_flag will be updated with 'Y'
542: whenever any of the source project is purged. Since we have to show
543: appropriate message, in the case of Drilldown from Intercompany Invoice
544: to source Expenditure items, will not have a performance hit as we would
545: know upfront that the at least one of the source project has been purged.

Line 548: update pa_draft_invoices_all di

544: to source Expenditure items, will not have a performance hit as we would
545: know upfront that the at least one of the source project has been purged.
546: */
547:
548: update pa_draft_invoices_all di
549: set di.purge_flag = 'Y'
550: where ( di.project_id, di.draft_invoice_num ) in
551: ( select did.project_id, did.draft_invoice_num
552: from pa_draft_invoice_details_all did