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.PAAPIMP_PKG dependencies on AP_PAYMENT_HIST_DISTS

Line 917: UPDATE ap_payment_hist_dists dist

913: If g_body_debug_mode = 'Y' Then
914: write_log(LOG, 'Number of invoice distributions updated = ' || to_char(SQL%ROWCOUNT));
915: end if;
916:
917: UPDATE ap_payment_hist_dists dist
918: SET dist.pa_addition_flag = 'N'
919: , DIST.request_id = G_REQUEST_ID
920: WHERE DIST.pa_addition_flag = 'O'
921: AND dist.pay_dist_lookup_code = 'DISCOUNT'

Line 962: UPDATE ap_payment_hist_dists dist

958: end if;
959:
960: ELSE --Accounting method is CASH BASIS
961:
962: UPDATE ap_payment_hist_dists dist
963: SET dist.pa_addition_flag = 'N'
964: , DIST.request_id = G_REQUEST_ID
965: WHERE DIST.pa_addition_flag = 'O'
966: AND dist.pay_dist_lookup_code = 'CASH'

Line 5328: UPDATE ap_payment_hist_dists dist

5324: IF G_ACCTNG_METHOD = 'C' THEN
5325:
5326: FORALL i IN l_sys_ref1_tbl.FIRST..l_sys_ref1_tbl.LAST
5327:
5328: UPDATE ap_payment_hist_dists dist
5329: SET dist.pa_addition_flag = 'G',
5330: request_id = G_REQUEST_ID,
5331: last_update_date=SYSDATE,
5332: last_updated_by= G_USER_ID,

Line 5595: UPDATE ap_payment_hist_dists dist

5591:
5592: -- Mark all Discount lines associated with PREPAYMENT payment to G to prevent interface into Projects
5593: -- In Rel12, we will only bring in Prepayment application lines (AP_PREPAY_APP_DISTS) into Projects for Cash Based Acctng
5594:
5595: UPDATE ap_payment_hist_dists dist
5596: SET dist.pa_addition_flag = 'G',
5597: request_id = G_REQUEST_ID,
5598: last_update_date=SYSDATE,
5599: last_updated_by= G_USER_ID,

Line 5633: UPDATE ap_payment_hist_dists dist

5629: End If;
5630:
5631: -- Update pa-addition-flag to O for all valid ap distributions that should be interfaced to Projects
5632:
5633: UPDATE ap_payment_hist_dists dist
5634: SET dist.pa_addition_flag = 'O',
5635: request_id = G_REQUEST_ID,
5636: last_update_date=SYSDATE,
5637: last_updated_by= G_USER_ID,

Line 5692: UPDATE ap_payment_hist_dists dist

5688:
5689: -- Bug 11775600 added the following update statement to mark pa_addition_flag to G for
5690: -- ap_payment_history_all.transaction_type not in ( 'PAYMENT CREATED','PAYMENT CANCELLED') transactions
5691:
5692: UPDATE ap_payment_hist_dists dist
5693: SET dist.pa_addition_flag = 'G',
5694: request_id = G_REQUEST_ID,
5695: last_update_date=SYSDATE,
5696: last_updated_by= G_USER_ID,

Line 5752: UPDATE ap_payment_hist_dists dist

5748:
5749: -- Mark all Discount lines associated with PREPAYMENT payment to G to prevent interface into Projects
5750: -- In Rel12, we will only bring in Prepayment application lines (AP_PREPAY_APP_DISTS) into Projects for Cash Based Acctng
5751:
5752: UPDATE ap_payment_hist_dists dist
5753: SET dist.pa_addition_flag = 'G',
5754: request_id = G_REQUEST_ID,
5755: last_update_date=SYSDATE,
5756: last_updated_by= G_USER_ID,

Line 5786: UPDATE ap_payment_hist_dists dist

5782: write_log(LOG, 'Number of Discount prepayments marked to G: ' || to_char(SQL%ROWCOUNT));
5783:
5784: -- Update pa-addition-flag to O for all valid ap distributions that should be interfaced to Projects
5785:
5786: UPDATE ap_payment_hist_dists dist
5787: SET dist.pa_addition_flag = 'O',
5788: request_id = G_REQUEST_ID,
5789: last_update_date=SYSDATE,
5790: last_updated_by= G_USER_ID,

Line 5844: UPDATE ap_payment_hist_dists dist

5840:
5841: -- Bug 11775600 added the following update statement to mark pa_addition_flag to G for
5842: -- ap_payment_history_all.transaction_type not in ( 'PAYMENT CREATED','PAYMENT CANCELLED') transactions
5843:
5844: UPDATE ap_payment_hist_dists dist
5845: SET dist.pa_addition_flag = 'G',
5846: request_id = G_REQUEST_ID,
5847: last_update_date=SYSDATE,
5848: last_updated_by= G_USER_ID,

Line 10438: UPDATE ap_payment_hist_dists dist

10434: -- If the invoice distribution has a encumbered flag value of 'R' then it is
10435: -- not encumbered and there exist no Budgetery control commitment records
10436: -- for these in PA
10437:
10438: UPDATE ap_payment_hist_dists dist
10439: SET dist.pa_addition_flag = 'Z',
10440: request_id = G_REQUEST_ID,
10441: last_update_date=SYSDATE,
10442: last_updated_by= G_USER_ID,

Line 10472: UPDATE ap_payment_hist_dists dist

10468: -- not encumbered and there exist no Budgetery control commitment records
10469: -- for these in PA
10470:
10471:
10472: UPDATE ap_payment_hist_dists dist
10473: SET dist.pa_addition_flag = 'Z',
10474: request_id = G_REQUEST_ID,
10475: last_update_date=SYSDATE,
10476: last_updated_by= G_USER_ID,

Line 10512: UPDATE ap_payment_hist_dists dist

10508: -- reversal distributions were looked at and they offset each other so, they can be ignored and marked as Z.
10509: -- (This is set only if the parent one is not validated as well. Otherwise the reversal one will also be encumbered).
10510: -- Since these lines have been not encumbered, there exist no Budgetery control commitment records for these in PA
10511:
10512: UPDATE ap_payment_hist_dists dist
10513: SET dist.pa_addition_flag = 'Z',
10514: request_id = G_REQUEST_ID,
10515: last_update_date=SYSDATE,
10516: last_updated_by= G_USER_ID,

Line 10545: UPDATE ap_payment_hist_dists dist

10541: -- If the invoice distribution has a encumbered flag value of 'R' then it is
10542: -- not encumbered and there exist no Budgetery control commitment records
10543: -- for these in PA
10544:
10545: UPDATE ap_payment_hist_dists dist
10546: SET dist.pa_addition_flag = 'Z',
10547: request_id = G_REQUEST_ID,
10548: last_update_date=SYSDATE,
10549: last_updated_by= G_USER_ID,

Line 10615: UPDATE ap_payment_hist_dists dist

10611: write_log(LOG, 'Marking Expense Report type invoices for processing...');
10612: --
10613: IF G_PROJECT_ID IS NOT NULL THEN
10614:
10615: UPDATE ap_payment_hist_dists dist
10616: SET dist.pa_addition_flag = 'O',
10617: request_id = G_REQUEST_ID,
10618: last_update_date=SYSDATE,
10619: last_updated_by= G_USER_ID,

Line 10705: UPDATE ap_payment_hist_dists dist

10701:
10702: ELSE /* G_PROJECT_ID IS NULL */
10703:
10704:
10705: UPDATE ap_payment_hist_dists dist
10706: SET dist.pa_addition_flag = 'O',
10707: request_id = G_REQUEST_ID,
10708: last_update_date=SYSDATE,
10709: last_updated_by= G_USER_ID,

Line 10810: UPDATE ap_payment_hist_dists dist

10806: IF G_PROJECT_ID IS NOT NULL THEN
10807:
10808: -- Update pa-addition-flag to O for all valid ap distributions that should be interfaced to Projects
10809:
10810: UPDATE ap_payment_hist_dists dist
10811: SET dist.pa_addition_flag = 'O',
10812: request_id = G_REQUEST_ID,
10813: last_update_date=SYSDATE,
10814: last_updated_by= G_USER_ID,

Line 10912: UPDATE ap_payment_hist_dists dist

10908:
10909:
10910: -- Update pa-addition-flag to O for all valid ap distributions that should be interfaced to Projects
10911:
10912: UPDATE ap_payment_hist_dists dist
10913: SET dist.pa_addition_flag = 'O',
10914: request_id = G_REQUEST_ID,
10915: last_update_date=SYSDATE,
10916: last_updated_by= G_USER_ID,

Line 11187: UPDATE ap_payment_hist_dists dist

11183: write_log(LOG,'Before bulk update of prepayment payments');
11184:
11185: FORALL i IN l_invoice_id_tbl.FIRST..l_invoice_id_tbl.LAST
11186:
11187: UPDATE ap_payment_hist_dists dist
11188: SET dist.pa_addition_flag = decode(l_insert_flag_tbl(i),'F','G','P','N')
11189: WHERE dist.invoice_payment_id = l_inv_pay_id_tbl(i)
11190: AND dist.pay_dist_lookup_code = 'CASH'
11191: AND dist.invoice_distribution_id = l_invoice_dist_id_tbl(i)

Line 12683: UPDATE ap_payment_hist_dists paydist

12679:
12680: ELSE
12681:
12682: FORALL i IN l_sys_ref1_tbl.FIRST..l_sys_ref1_tbl.LAST
12683: UPDATE ap_payment_hist_dists paydist
12684: SET paydist.pa_addition_flag = l_pa_addflag_tbl(i)
12685: WHERE paydist.invoice_payment_id = l_sys_ref4_tbl(i)
12686: AND paydist.invoice_distribution_id = l_sys_ref5_tbl(i)
12687: AND paydist.pa_addition_flag = 'O';