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_PREPAY_APP_DISTS

Line 963: UPDATE ap_prepay_app_dists dist

959: If g_body_debug_mode = 'Y' Then
960: write_log(LOG, 'Number of payment distributions updated = ' || to_char(SQL%ROWCOUNT));
961: end if;
962:
963: UPDATE ap_prepay_app_dists dist
964: SET dist.pa_addition_flag = 'N',
965: request_id = G_REQUEST_ID
966: WHERE dist.pa_addition_flag = 'O'
967: AND NOT EXISTS ( SELECT 'X'

Line 4437: -- In Rel12, we will only bring in Prepayment application lines (AP_PREPAY_APP_DISTS) into Projects for Cash Based Acctng

4433:
4434: IF G_PROJECT_ID is not NULL THEN
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,

Line 4533: -- In Rel12, we will only bring in Prepayment application lines (AP_PREPAY_APP_DISTS) into Projects for Cash Based Acctng

4529:
4530: ELSE -- G_PRoject_id is null
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,

Line 8939: /* For Prepayment Application , we need to interface the prepay application lines created in ap_prepay_app_dists table*/

8935:
8936: G_PAY_DISTRIBUTIONS_MARKED := SQL%ROWCOUNT;
8937: write_log(LOG, 'Number of Invoice - Payment rows marked to O: ' || to_char(SQL%ROWCOUNT));
8938:
8939: /* For Prepayment Application , we need to interface the prepay application lines created in ap_prepay_app_dists table*/
8940:
8941: UPDATE ap_prepay_app_dists dist
8942: SET dist.pa_addition_flag = 'O',
8943: request_id = G_REQUEST_ID,

Line 8941: UPDATE ap_prepay_app_dists dist

8937: write_log(LOG, 'Number of Invoice - Payment rows marked to O: ' || to_char(SQL%ROWCOUNT));
8938:
8939: /* For Prepayment Application , we need to interface the prepay application lines created in ap_prepay_app_dists table*/
8940:
8941: UPDATE ap_prepay_app_dists dist
8942: SET dist.pa_addition_flag = 'O',
8943: request_id = G_REQUEST_ID,
8944: last_update_date=SYSDATE,
8945: last_updated_by= G_USER_ID,

Line 9030: /* For Prepayment Application , we need to interface the prepay application lines created in ap_prepay_app_dists table*/

9026:
9027: G_PAY_DISTRIBUTIONS_MARKED := SQL%ROWCOUNT;
9028: write_log(LOG, 'Number of Invoice - Payment rows marked to O: ' || to_char(SQL%ROWCOUNT));
9029:
9030: /* For Prepayment Application , we need to interface the prepay application lines created in ap_prepay_app_dists table*/
9031:
9032: UPDATE ap_prepay_app_dists dist
9033: SET dist.pa_addition_flag = 'O',
9034: request_id = G_REQUEST_ID,

Line 9032: UPDATE ap_prepay_app_dists dist

9028: write_log(LOG, 'Number of Invoice - Payment rows marked to O: ' || to_char(SQL%ROWCOUNT));
9029:
9030: /* For Prepayment Application , we need to interface the prepay application lines created in ap_prepay_app_dists table*/
9031:
9032: UPDATE ap_prepay_app_dists dist
9033: SET dist.pa_addition_flag = 'O',
9034: request_id = G_REQUEST_ID,
9035: last_update_date=SYSDATE,
9036: last_updated_by= G_USER_ID,

Line 9141: /* For Prepayment Application , we need to interface the prepay application lines created in ap_prepay_app_dists table*/

9137:
9138: G_PAY_DISTRIBUTIONS_MARKED := SQL%ROWCOUNT;
9139: write_log(LOG, 'Number of Invoice - Payment rows marked to O: ' || to_char(SQL%ROWCOUNT));
9140:
9141: /* For Prepayment Application , we need to interface the prepay application lines created in ap_prepay_app_dists table*/
9142:
9143: UPDATE ap_prepay_app_dists dist
9144: SET dist.pa_addition_flag = 'O',
9145: request_id = G_REQUEST_ID,

Line 9143: UPDATE ap_prepay_app_dists dist

9139: write_log(LOG, 'Number of Invoice - Payment rows marked to O: ' || to_char(SQL%ROWCOUNT));
9140:
9141: /* For Prepayment Application , we need to interface the prepay application lines created in ap_prepay_app_dists table*/
9142:
9143: UPDATE ap_prepay_app_dists dist
9144: SET dist.pa_addition_flag = 'O',
9145: request_id = G_REQUEST_ID,
9146: last_update_date=SYSDATE,
9147: last_updated_by= G_USER_ID,

Line 9243: /* For Prepayment Application , we need to interface the prepay application lines created in ap_prepay_app_dists table*/

9239:
9240: G_PAY_DISTRIBUTIONS_MARKED := SQL%ROWCOUNT;
9241: write_log(LOG, 'Number of Invoice - Payment rows marked to O: ' || to_char(SQL%ROWCOUNT));
9242:
9243: /* For Prepayment Application , we need to interface the prepay application lines created in ap_prepay_app_dists table*/
9244:
9245: UPDATE ap_prepay_app_dists dist
9246: SET dist.pa_addition_flag = 'O',
9247: request_id = G_REQUEST_ID,

Line 9245: UPDATE ap_prepay_app_dists dist

9241: write_log(LOG, 'Number of Invoice - Payment rows marked to O: ' || to_char(SQL%ROWCOUNT));
9242:
9243: /* For Prepayment Application , we need to interface the prepay application lines created in ap_prepay_app_dists table*/
9244:
9245: UPDATE ap_prepay_app_dists dist
9246: SET dist.pa_addition_flag = 'O',
9247: request_id = G_REQUEST_ID,
9248: last_update_date=SYSDATE,
9249: last_updated_by= G_USER_ID,

Line 10913: UPDATE ap_prepay_app_dists dist

10909:
10910: IF l_batch = 'APPPAY' THEN --Prepayment Appl batch
10911:
10912: FORALL i IN l_sys_ref1_tbl.FIRST..l_sys_ref1_tbl.LAST
10913: UPDATE ap_prepay_app_dists dist
10914: SET dist.pa_addition_flag = l_pa_addflag_tbl(i)
10915: WHERE dist.prepay_app_dist_id = l_sys_ref4_tbl(i)
10916: AND dist.invoice_distribution_id = l_sys_ref5_tbl(i)
10917: AND dist.pa_addition_flag = 'O';