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 981: UPDATE ap_prepay_app_dists dist

977: If g_body_debug_mode = 'Y' Then
978: write_log(LOG, 'Number of payment distributions updated = ' || to_char(SQL%ROWCOUNT));
979: end if;
980:
981: UPDATE ap_prepay_app_dists dist
982: SET dist.pa_addition_flag = 'N',
983: request_id = G_REQUEST_ID
984: WHERE dist.pa_addition_flag = 'O'
985: AND NOT EXISTS ( SELECT 'X'

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

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

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

5746:
5747: ELSE -- G_PRoject_id is null
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,

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

10653:
10654: G_PAY_DISTRIBUTIONS_MARKED := SQL%ROWCOUNT;
10655: write_log(LOG, 'Number of Invoice - Payment rows marked to O: ' || to_char(SQL%ROWCOUNT));
10656:
10657: /* For Prepayment Application , we need to interface the prepay application lines created in ap_prepay_app_dists table*/
10658:
10659: UPDATE ap_prepay_app_dists dist
10660: SET dist.pa_addition_flag = 'O',
10661: request_id = G_REQUEST_ID,

Line 10659: UPDATE ap_prepay_app_dists dist

10655: write_log(LOG, 'Number of Invoice - Payment rows marked to O: ' || to_char(SQL%ROWCOUNT));
10656:
10657: /* For Prepayment Application , we need to interface the prepay application lines created in ap_prepay_app_dists table*/
10658:
10659: UPDATE ap_prepay_app_dists dist
10660: SET dist.pa_addition_flag = 'O',
10661: request_id = G_REQUEST_ID,
10662: last_update_date=SYSDATE,
10663: last_updated_by= G_USER_ID,

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

10744:
10745: G_PAY_DISTRIBUTIONS_MARKED := SQL%ROWCOUNT;
10746: write_log(LOG, 'Number of Invoice - Payment rows marked to O: ' || to_char(SQL%ROWCOUNT));
10747:
10748: /* For Prepayment Application , we need to interface the prepay application lines created in ap_prepay_app_dists table*/
10749:
10750: UPDATE ap_prepay_app_dists dist
10751: SET dist.pa_addition_flag = 'O',
10752: request_id = G_REQUEST_ID,

Line 10750: UPDATE ap_prepay_app_dists dist

10746: write_log(LOG, 'Number of Invoice - Payment rows marked to O: ' || to_char(SQL%ROWCOUNT));
10747:
10748: /* For Prepayment Application , we need to interface the prepay application lines created in ap_prepay_app_dists table*/
10749:
10750: UPDATE ap_prepay_app_dists dist
10751: SET dist.pa_addition_flag = 'O',
10752: request_id = G_REQUEST_ID,
10753: last_update_date=SYSDATE,
10754: last_updated_by= G_USER_ID,

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

10855:
10856: G_PAY_DISTRIBUTIONS_MARKED := SQL%ROWCOUNT;
10857: write_log(LOG, 'Number of Invoice - Payment rows marked to O: ' || to_char(SQL%ROWCOUNT));
10858:
10859: /* For Prepayment Application , we need to interface the prepay application lines created in ap_prepay_app_dists table*/
10860:
10861: UPDATE ap_prepay_app_dists dist
10862: SET dist.pa_addition_flag = 'O',
10863: request_id = G_REQUEST_ID,

Line 10861: UPDATE ap_prepay_app_dists dist

10857: write_log(LOG, 'Number of Invoice - Payment rows marked to O: ' || to_char(SQL%ROWCOUNT));
10858:
10859: /* For Prepayment Application , we need to interface the prepay application lines created in ap_prepay_app_dists table*/
10860:
10861: UPDATE ap_prepay_app_dists dist
10862: SET dist.pa_addition_flag = 'O',
10863: request_id = G_REQUEST_ID,
10864: last_update_date=SYSDATE,
10865: last_updated_by= G_USER_ID,

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

10957:
10958: G_PAY_DISTRIBUTIONS_MARKED := SQL%ROWCOUNT;
10959: write_log(LOG, 'Number of Invoice - Payment rows marked to O: ' || to_char(SQL%ROWCOUNT));
10960:
10961: /* For Prepayment Application , we need to interface the prepay application lines created in ap_prepay_app_dists table*/
10962:
10963: UPDATE ap_prepay_app_dists dist
10964: SET dist.pa_addition_flag = 'O',
10965: request_id = G_REQUEST_ID,

Line 10963: UPDATE ap_prepay_app_dists dist

10959: write_log(LOG, 'Number of Invoice - Payment rows marked to O: ' || to_char(SQL%ROWCOUNT));
10960:
10961: /* For Prepayment Application , we need to interface the prepay application lines created in ap_prepay_app_dists table*/
10962:
10963: UPDATE ap_prepay_app_dists dist
10964: SET dist.pa_addition_flag = 'O',
10965: request_id = G_REQUEST_ID,
10966: last_update_date=SYSDATE,
10967: last_updated_by= G_USER_ID,

Line 12674: UPDATE ap_prepay_app_dists dist

12670:
12671: IF l_batch = 'APPPAY' THEN --Prepayment Appl batch
12672:
12673: FORALL i IN l_sys_ref1_tbl.FIRST..l_sys_ref1_tbl.LAST
12674: UPDATE ap_prepay_app_dists dist
12675: SET dist.pa_addition_flag = l_pa_addflag_tbl(i)
12676: WHERE dist.prepay_app_dist_id = l_sys_ref4_tbl(i)
12677: AND dist.invoice_distribution_id = l_sys_ref5_tbl(i)
12678: AND dist.pa_addition_flag = 'O';