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.JAI_AR_MATCH_TAX_PKG dependencies on JAI_AR_PAYMENT_AUDITS

Line 1164: ln_created_by jai_ar_payment_audits.created_by%TYPE;

1160: IS
1161: SELECT jai_ar_rec_appl_audits_s.nextval
1162: FROM dual;
1163:
1164: ln_created_by jai_ar_payment_audits.created_by%TYPE;
1165: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;
1166: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;
1167: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;
1168: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;

Line 1165: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;

1161: SELECT jai_ar_rec_appl_audits_s.nextval
1162: FROM dual;
1163:
1164: ln_created_by jai_ar_payment_audits.created_by%TYPE;
1165: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;
1166: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;
1167: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;
1168: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;
1169:

Line 1166: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;

1162: FROM dual;
1163:
1164: ln_created_by jai_ar_payment_audits.created_by%TYPE;
1165: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;
1166: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;
1167: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;
1168: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;
1169:
1170: BEGIN

Line 1167: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;

1163:
1164: ln_created_by jai_ar_payment_audits.created_by%TYPE;
1165: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;
1166: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;
1167: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;
1168: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;
1169:
1170: BEGIN
1171: p_process_status := jai_constants.successful;

Line 1168: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;

1164: ln_created_by jai_ar_payment_audits.created_by%TYPE;
1165: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;
1166: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;
1167: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;
1168: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;
1169:
1170: BEGIN
1171: p_process_status := jai_constants.successful;
1172: p_process_message := NULL;

Line 1260: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits

1256: p_process_message := SUBSTR(SQLERRM,1,300);
1257: END maintain_applications;
1258:
1259: --=========================================================================================--
1260: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
1261: --=========================================================================================--
1262:
1263: PROCEDURE maintain_schedules( p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
1264: p_payment_schedule_id IN ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL,

Line 1270: p_payment_audit_id IN OUT NOCOPY jai_ar_payment_audits.payment_audit_id%TYPE,

1266: p_invoice_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
1267: p_concurrent_req_num IN NUMBER,
1268: p_request_id IN NUMBER,
1269: p_operation_type IN VARCHAR2,
1270: p_payment_audit_id IN OUT NOCOPY jai_ar_payment_audits.payment_audit_id%TYPE,
1271: p_process_status OUT NOCOPY VARCHAR2,
1272: p_process_message OUT NOCOPY VARCHAR2)
1273: IS
1274:

Line 1280: SELECT jai_ar_payment_audits_s.nextval

1276:
1277:
1278: CURSOR cur_payment_audits_s
1279: IS
1280: SELECT jai_ar_payment_audits_s.nextval
1281: FROM dual;
1282:
1283: ln_created_by jai_ar_payment_audits.created_by%TYPE;
1284: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;

Line 1283: ln_created_by jai_ar_payment_audits.created_by%TYPE;

1279: IS
1280: SELECT jai_ar_payment_audits_s.nextval
1281: FROM dual;
1282:
1283: ln_created_by jai_ar_payment_audits.created_by%TYPE;
1284: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;
1285: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;
1286: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;
1287: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;

Line 1284: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;

1280: SELECT jai_ar_payment_audits_s.nextval
1281: FROM dual;
1282:
1283: ln_created_by jai_ar_payment_audits.created_by%TYPE;
1284: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;
1285: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;
1286: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;
1287: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;
1288: BEGIN

Line 1285: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;

1281: FROM dual;
1282:
1283: ln_created_by jai_ar_payment_audits.created_by%TYPE;
1284: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;
1285: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;
1286: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;
1287: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;
1288: BEGIN
1289: p_process_status := jai_constants.successful;

Line 1286: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;

1282:
1283: ln_created_by jai_ar_payment_audits.created_by%TYPE;
1284: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;
1285: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;
1286: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;
1287: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;
1288: BEGIN
1289: p_process_status := jai_constants.successful;
1290: p_process_message := NULL;

Line 1287: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;

1283: ln_created_by jai_ar_payment_audits.created_by%TYPE;
1284: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;
1285: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;
1286: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;
1287: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;
1288: BEGIN
1289: p_process_status := jai_constants.successful;
1290: p_process_message := NULL;
1291:

Line 1310: INSERT INTO jai_ar_payment_audits(

1306:
1307: ln_created_by := ln_last_updated_by;
1308: ld_creation_date := ld_last_update_date;
1309:
1310: INSERT INTO jai_ar_payment_audits(
1311: payment_audit_id,
1312: concurrent_req_num,
1313: payment_schedule_id,
1314: cm_customer_trx_id,

Line 1365: UPDATE jai_ar_payment_audits a

1361: WHERE customer_trx_id = p_customer_trx_id
1362: AND payment_schedule_id = NVL(p_payment_schedule_id, payment_schedule_id);
1363:
1364: ELSIF p_operation_type = 'UPDATE' THEN
1365: UPDATE jai_ar_payment_audits a
1366: SET (ado_new,
1367: to_new,
1368: fo_new,
1369: aapp_new,

Line 2175: ln_payment_audit_id jai_ar_payment_audits.payment_audit_id%TYPE;

2171: ln_amt_due_rem NUMBER;
2172: ln_line_applied NUMBER;
2173: ln_frt_amt_cashrcpt NUMBER;
2174: ln_tax_amt_cashrcpt NUMBER;
2175: ln_payment_audit_id jai_ar_payment_audits.payment_audit_id%TYPE;
2176: ln_rec_appl_audit_id jai_ar_rec_appl_audits.rec_appl_audit_id%TYPE;
2177: lv_process_status VARCHAR2(2);
2178: lv_process_message VARCHAR2(1000);
2179: v_upd_created_from VARCHAR2(15);

Line 2656: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits

2652: END LOOP;
2653: --bug#9230409, end
2654:
2655:
2656: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
2657: maintain_schedules( p_customer_trx_id => p_customer_trx_id,
2658: p_payment_schedule_id => NULL,
2659: p_cm_customer_trx_id => p_customer_trx_id,
2660: p_invoice_customer_trx_id => ln_previous_customer_trx_id,

Line 2686: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits

2682: amount_applied = ROUND(NVL(amount_line_items_original,0) + ln_total_tax_amt_for_inv + ln_total_frt_amt_for_inv, ln_precision),
2683: last_update_date = SYSDATE
2684: WHERE customer_trx_id = p_customer_trx_id;
2685:
2686: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
2687: maintain_schedules( p_customer_trx_id => p_customer_trx_id,
2688: p_payment_schedule_id => NULL,
2689: p_cm_customer_trx_id => p_customer_trx_id,
2690: p_invoice_customer_trx_id => ln_previous_customer_trx_id,

Line 2816: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits

2812: IF ( NVL(lv_allow_overappln_flag,'N') = 'Y' ) OR
2813: ( NVL(lv_allow_overappln_flag,'N') = 'N' AND ln_amt_due_rem >= 0 )
2814: THEN
2815:
2816: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
2817: maintain_schedules( p_customer_trx_id => p_customer_trx_id,
2818: p_payment_schedule_id => rec_payment.payment_schedule_id,
2819: p_cm_customer_trx_id => p_customer_trx_id,
2820: p_invoice_customer_trx_id => ln_previous_customer_trx_id,

Line 2865: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits

2861: IF p_debug = 'Y' THEN
2862: fnd_file.put_line(FND_FILE.LOG, 'After second update fo ar_payment_schedules_all');
2863: END IF;
2864:
2865: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
2866: maintain_schedules( p_customer_trx_id => p_customer_trx_id,
2867: p_payment_schedule_id => rec_payment.payment_schedule_id,
2868: p_cm_customer_trx_id => p_customer_trx_id,
2869: p_invoice_customer_trx_id => ln_previous_customer_trx_id,

Line 3076: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits

3072: ln_inst_tax_amt_for_inv := ln_total_tax_amt_for_inv * ln_apportion_factor;
3073: ln_inst_frt_amt_for_inv := ln_total_frt_amt_for_inv * ln_apportion_factor;
3074:
3075:
3076: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
3077: maintain_schedules( p_customer_trx_id => p_customer_trx_id,
3078: p_payment_schedule_id => rec_payment.payment_schedule_id,
3079: p_cm_customer_trx_id => NULL,
3080: p_invoice_customer_trx_id => p_customer_trx_id,

Line 3127: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits

3123: fnd_file.put_line(FND_FILE.LOG, 'After Second update of ar_payment_schedules_all '||SQL%ROWCOUNT);
3124: END IF;
3125:
3126:
3127: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
3128: maintain_schedules( p_customer_trx_id => p_customer_trx_id,
3129: p_payment_schedule_id => rec_payment.payment_schedule_id,
3130: p_cm_customer_trx_id => NULL,
3131: p_invoice_customer_trx_id => p_customer_trx_id,