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 602: ln_created_by jai_ar_payment_audits.created_by%TYPE;

598: IS
599: SELECT jai_ar_rec_appl_audits_s.nextval
600: FROM dual;
601:
602: ln_created_by jai_ar_payment_audits.created_by%TYPE;
603: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;
604: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;
605: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;
606: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;

Line 603: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;

599: SELECT jai_ar_rec_appl_audits_s.nextval
600: FROM dual;
601:
602: ln_created_by jai_ar_payment_audits.created_by%TYPE;
603: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;
604: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;
605: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;
606: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;
607:

Line 604: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;

600: FROM dual;
601:
602: ln_created_by jai_ar_payment_audits.created_by%TYPE;
603: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;
604: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;
605: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;
606: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;
607:
608: BEGIN

Line 605: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;

601:
602: ln_created_by jai_ar_payment_audits.created_by%TYPE;
603: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;
604: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;
605: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;
606: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;
607:
608: BEGIN
609: p_process_status := jai_constants.successful;

Line 606: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;

602: ln_created_by jai_ar_payment_audits.created_by%TYPE;
603: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;
604: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;
605: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;
606: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;
607:
608: BEGIN
609: p_process_status := jai_constants.successful;
610: p_process_message := NULL;

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

694: p_process_message := SUBSTR(SQLERRM,1,300);
695: END maintain_applications;
696:
697: --=========================================================================================--
698: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
699: --=========================================================================================--
700:
701: PROCEDURE maintain_schedules( p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
702: p_payment_schedule_id IN ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL,

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

704: p_invoice_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
705: p_concurrent_req_num IN NUMBER,
706: p_request_id IN NUMBER,
707: p_operation_type IN VARCHAR2,
708: p_payment_audit_id IN OUT NOCOPY jai_ar_payment_audits.payment_audit_id%TYPE,
709: p_process_status OUT NOCOPY VARCHAR2,
710: p_process_message OUT NOCOPY VARCHAR2)
711: IS
712:

Line 718: SELECT jai_ar_payment_audits_s.nextval

714:
715:
716: CURSOR cur_payment_audits_s
717: IS
718: SELECT jai_ar_payment_audits_s.nextval
719: FROM dual;
720:
721: ln_created_by jai_ar_payment_audits.created_by%TYPE;
722: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;

Line 721: ln_created_by jai_ar_payment_audits.created_by%TYPE;

717: IS
718: SELECT jai_ar_payment_audits_s.nextval
719: FROM dual;
720:
721: ln_created_by jai_ar_payment_audits.created_by%TYPE;
722: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;
723: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;
724: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;
725: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;

Line 722: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;

718: SELECT jai_ar_payment_audits_s.nextval
719: FROM dual;
720:
721: ln_created_by jai_ar_payment_audits.created_by%TYPE;
722: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;
723: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;
724: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;
725: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;
726: BEGIN

Line 723: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;

719: FROM dual;
720:
721: ln_created_by jai_ar_payment_audits.created_by%TYPE;
722: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;
723: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;
724: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;
725: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;
726: BEGIN
727: p_process_status := jai_constants.successful;

Line 724: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;

720:
721: ln_created_by jai_ar_payment_audits.created_by%TYPE;
722: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;
723: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;
724: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;
725: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;
726: BEGIN
727: p_process_status := jai_constants.successful;
728: p_process_message := NULL;

Line 725: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;

721: ln_created_by jai_ar_payment_audits.created_by%TYPE;
722: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;
723: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;
724: ld_last_update_date jai_ar_payment_audits.last_update_date%TYPE;
725: ln_last_update_login jai_ar_payment_audits.last_update_login%TYPE;
726: BEGIN
727: p_process_status := jai_constants.successful;
728: p_process_message := NULL;
729:

Line 748: INSERT INTO jai_ar_payment_audits(

744:
745: ln_created_by := ln_last_updated_by;
746: ld_creation_date := ld_last_update_date;
747:
748: INSERT INTO jai_ar_payment_audits(
749: payment_audit_id,
750: concurrent_req_num,
751: payment_schedule_id,
752: cm_customer_trx_id,

Line 803: UPDATE jai_ar_payment_audits a

799: WHERE customer_trx_id = p_customer_trx_id
800: AND payment_schedule_id = NVL(p_payment_schedule_id, payment_schedule_id);
801:
802: ELSIF p_operation_type = 'UPDATE' THEN
803: UPDATE jai_ar_payment_audits a
804: SET (ado_new,
805: to_new,
806: fo_new,
807: aapp_new,

Line 1494: ln_payment_audit_id jai_ar_payment_audits.payment_audit_id%TYPE;

1490: ln_amt_due_rem NUMBER;
1491: ln_line_applied NUMBER;
1492: ln_frt_amt_cashrcpt NUMBER;
1493: ln_tax_amt_cashrcpt NUMBER;
1494: ln_payment_audit_id jai_ar_payment_audits.payment_audit_id%TYPE;
1495: ln_rec_appl_audit_id jai_ar_rec_appl_audits.rec_appl_audit_id%TYPE;
1496: lv_process_status VARCHAR2(2);
1497: lv_process_message VARCHAR2(1000);
1498: v_upd_created_from VARCHAR2(15);

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

1844:
1845: ln_payment_audit_id := NULL;
1846: ln_rec_appl_audit_id := NULL;
1847:
1848: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
1849: maintain_schedules( p_customer_trx_id => p_customer_trx_id,
1850: p_payment_schedule_id => NULL,
1851: p_cm_customer_trx_id => p_customer_trx_id,
1852: p_invoice_customer_trx_id => ln_previous_customer_trx_id,

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

1874: amount_applied = ROUND(NVL(amount_line_items_original,0) + ln_total_tax_amt_for_inv + ln_total_frt_amt_for_inv, ln_precision),
1875: last_update_date = SYSDATE
1876: WHERE customer_trx_id = p_customer_trx_id;
1877:
1878: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
1879: maintain_schedules( p_customer_trx_id => p_customer_trx_id,
1880: p_payment_schedule_id => NULL,
1881: p_cm_customer_trx_id => p_customer_trx_id,
1882: p_invoice_customer_trx_id => ln_previous_customer_trx_id,

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

2004: IF ( NVL(lv_allow_overappln_flag,'N') = 'Y' ) OR
2005: ( NVL(lv_allow_overappln_flag,'N') = 'N' AND ln_amt_due_rem >= 0 )
2006: THEN
2007:
2008: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
2009: maintain_schedules( p_customer_trx_id => p_customer_trx_id,
2010: p_payment_schedule_id => rec_payment.payment_schedule_id,
2011: p_cm_customer_trx_id => p_customer_trx_id,
2012: p_invoice_customer_trx_id => ln_previous_customer_trx_id,

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

2053: IF p_debug = 'Y' THEN
2054: fnd_file.put_line(FND_FILE.LOG, 'After second update fo ar_payment_schedules_all');
2055: END IF;
2056:
2057: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
2058: maintain_schedules( p_customer_trx_id => p_customer_trx_id,
2059: p_payment_schedule_id => rec_payment.payment_schedule_id,
2060: p_cm_customer_trx_id => p_customer_trx_id,
2061: p_invoice_customer_trx_id => ln_previous_customer_trx_id,

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

2205: ln_inst_tax_amt_for_inv := ln_total_tax_amt_for_inv * ln_apportion_factor;
2206: ln_inst_frt_amt_for_inv := ln_total_frt_amt_for_inv * ln_apportion_factor;
2207:
2208:
2209: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
2210: maintain_schedules( p_customer_trx_id => p_customer_trx_id,
2211: p_payment_schedule_id => rec_payment.payment_schedule_id,
2212: p_cm_customer_trx_id => NULL,
2213: p_invoice_customer_trx_id => p_customer_trx_id,

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

2256: fnd_file.put_line(FND_FILE.LOG, 'After Second update of ar_payment_schedules_all '||SQL%ROWCOUNT);
2257: END IF;
2258:
2259:
2260: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
2261: maintain_schedules( p_customer_trx_id => p_customer_trx_id,
2262: p_payment_schedule_id => rec_payment.payment_schedule_id,
2263: p_cm_customer_trx_id => NULL,
2264: p_invoice_customer_trx_id => p_customer_trx_id,