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 899: UPDATE ap_payment_hist_dists dist

895: If g_body_debug_mode = 'Y' Then
896: write_log(LOG, 'Number of invoice distributions updated = ' || to_char(SQL%ROWCOUNT));
897: end if;
898:
899: UPDATE ap_payment_hist_dists dist
900: SET dist.pa_addition_flag = 'N'
901: , DIST.request_id = G_REQUEST_ID
902: WHERE DIST.pa_addition_flag = 'O'
903: AND dist.pay_dist_lookup_code = 'DISCOUNT'

Line 944: UPDATE ap_payment_hist_dists dist

940: end if;
941:
942: ELSE --Accounting method is CASH BASIS
943:
944: UPDATE ap_payment_hist_dists dist
945: SET dist.pa_addition_flag = 'N'
946: , DIST.request_id = G_REQUEST_ID
947: WHERE DIST.pa_addition_flag = 'O'
948: AND dist.pay_dist_lookup_code = 'CASH'

Line 4173: UPDATE ap_payment_hist_dists dist

4169: IF G_ACCTNG_METHOD = 'C' THEN
4170:
4171: FORALL i IN l_sys_ref1_tbl.FIRST..l_sys_ref1_tbl.LAST
4172:
4173: UPDATE ap_payment_hist_dists dist
4174: SET dist.pa_addition_flag = 'G',
4175: request_id = G_REQUEST_ID,
4176: last_update_date=SYSDATE,
4177: last_updated_by= G_USER_ID,

Line 4439: UPDATE ap_payment_hist_dists dist

4435:
4436: -- Mark all Discount lines associated with PREPAYMENT payment to G to prevent interface into Projects
4437: -- In Rel12, we will only bring in Prepayment application lines (AP_PREPAY_APP_DISTS) into Projects for Cash Based Acctng
4438:
4439: UPDATE ap_payment_hist_dists dist
4440: SET dist.pa_addition_flag = 'G',
4441: request_id = G_REQUEST_ID,
4442: last_update_date=SYSDATE,
4443: last_updated_by= G_USER_ID,

Line 4477: UPDATE ap_payment_hist_dists dist

4473: End If;
4474:
4475: -- Update pa-addition-flag to O for all valid ap distributions that should be interfaced to Projects
4476:
4477: UPDATE ap_payment_hist_dists dist
4478: SET dist.pa_addition_flag = 'O',
4479: request_id = G_REQUEST_ID,
4480: last_update_date=SYSDATE,
4481: last_updated_by= G_USER_ID,

Line 4535: UPDATE ap_payment_hist_dists dist

4531:
4532: -- Mark all Discount lines associated with PREPAYMENT payment to G to prevent interface into Projects
4533: -- In Rel12, we will only bring in Prepayment application lines (AP_PREPAY_APP_DISTS) into Projects for Cash Based Acctng
4534:
4535: UPDATE ap_payment_hist_dists dist
4536: SET dist.pa_addition_flag = 'G',
4537: request_id = G_REQUEST_ID,
4538: last_update_date=SYSDATE,
4539: last_updated_by= G_USER_ID,

Line 4569: UPDATE ap_payment_hist_dists dist

4565: write_log(LOG, 'Number of Discount prepayments marked to G: ' || to_char(SQL%ROWCOUNT));
4566:
4567: -- Update pa-addition-flag to O for all valid ap distributions that should be interfaced to Projects
4568:
4569: UPDATE ap_payment_hist_dists dist
4570: SET dist.pa_addition_flag = 'O',
4571: request_id = G_REQUEST_ID,
4572: last_update_date=SYSDATE,
4573: last_updated_by= G_USER_ID,

Line 8724: UPDATE ap_payment_hist_dists dist

8720: -- If the invoice distribution has a encumbered flag value of 'R' then it is
8721: -- not encumbered and there exist no Budgetery control commitment records
8722: -- for these in PA
8723:
8724: UPDATE ap_payment_hist_dists dist
8725: SET dist.pa_addition_flag = 'Z',
8726: request_id = G_REQUEST_ID,
8727: last_update_date=SYSDATE,
8728: last_updated_by= G_USER_ID,

Line 8757: UPDATE ap_payment_hist_dists dist

8753: -- not encumbered and there exist no Budgetery control commitment records
8754: -- for these in PA
8755:
8756:
8757: UPDATE ap_payment_hist_dists dist
8758: SET dist.pa_addition_flag = 'Z',
8759: request_id = G_REQUEST_ID,
8760: last_update_date=SYSDATE,
8761: last_updated_by= G_USER_ID,

Line 8796: UPDATE ap_payment_hist_dists dist

8792: -- reversal distributions were looked at and they offset each other so, they can be ignored and marked as Z.
8793: -- (This is set only if the parent one is not validated as well. Otherwise the reversal one will also be encumbered).
8794: -- Since these lines have been not encumbered, there exist no Budgetery control commitment records for these in PA
8795:
8796: UPDATE ap_payment_hist_dists dist
8797: SET dist.pa_addition_flag = 'Z',
8798: request_id = G_REQUEST_ID,
8799: last_update_date=SYSDATE,
8800: last_updated_by= G_USER_ID,

Line 8828: UPDATE ap_payment_hist_dists dist

8824: -- If the invoice distribution has a encumbered flag value of 'R' then it is
8825: -- not encumbered and there exist no Budgetery control commitment records
8826: -- for these in PA
8827:
8828: UPDATE ap_payment_hist_dists dist
8829: SET dist.pa_addition_flag = 'Z',
8830: request_id = G_REQUEST_ID,
8831: last_update_date=SYSDATE,
8832: last_updated_by= G_USER_ID,

Line 8897: UPDATE ap_payment_hist_dists dist

8893: write_log(LOG, 'Marking Expense Report type invoices for processing...');
8894: --
8895: IF G_PROJECT_ID IS NOT NULL THEN
8896:
8897: UPDATE ap_payment_hist_dists dist
8898: SET dist.pa_addition_flag = 'O',
8899: request_id = G_REQUEST_ID,
8900: last_update_date=SYSDATE,
8901: last_updated_by= G_USER_ID,

Line 8987: UPDATE ap_payment_hist_dists dist

8983:
8984: ELSE /* G_PROJECT_ID IS NULL */
8985:
8986:
8987: UPDATE ap_payment_hist_dists dist
8988: SET dist.pa_addition_flag = 'O',
8989: request_id = G_REQUEST_ID,
8990: last_update_date=SYSDATE,
8991: last_updated_by= G_USER_ID,

Line 9092: UPDATE ap_payment_hist_dists dist

9088: IF G_PROJECT_ID IS NOT NULL THEN
9089:
9090: -- Update pa-addition-flag to O for all valid ap distributions that should be interfaced to Projects
9091:
9092: UPDATE ap_payment_hist_dists dist
9093: SET dist.pa_addition_flag = 'O',
9094: request_id = G_REQUEST_ID,
9095: last_update_date=SYSDATE,
9096: last_updated_by= G_USER_ID,

Line 9194: UPDATE ap_payment_hist_dists dist

9190:
9191:
9192: -- Update pa-addition-flag to O for all valid ap distributions that should be interfaced to Projects
9193:
9194: UPDATE ap_payment_hist_dists dist
9195: SET dist.pa_addition_flag = 'O',
9196: request_id = G_REQUEST_ID,
9197: last_update_date=SYSDATE,
9198: last_updated_by= G_USER_ID,

Line 9468: UPDATE ap_payment_hist_dists dist

9464: write_log(LOG,'Before bulk update of prepayment payments');
9465:
9466: FORALL i IN l_invoice_id_tbl.FIRST..l_invoice_id_tbl.LAST
9467:
9468: UPDATE ap_payment_hist_dists dist
9469: SET dist.pa_addition_flag = decode(l_insert_flag_tbl(i),'F','G','P','N')
9470: WHERE dist.invoice_payment_id = l_inv_pay_id_tbl(i)
9471: AND dist.pay_dist_lookup_code = 'CASH'
9472: AND dist.invoice_distribution_id = l_invoice_dist_id_tbl(i)

Line 10922: UPDATE ap_payment_hist_dists paydist

10918:
10919: ELSE
10920:
10921: FORALL i IN l_sys_ref1_tbl.FIRST..l_sys_ref1_tbl.LAST
10922: UPDATE ap_payment_hist_dists paydist
10923: SET paydist.pa_addition_flag = l_pa_addflag_tbl(i)
10924: WHERE paydist.invoice_payment_id = l_sys_ref4_tbl(i)
10925: AND paydist.invoice_distribution_id = l_sys_ref5_tbl(i)
10926: AND paydist.pa_addition_flag = 'O';