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.FV_DC_ASSIGN_FINANCE_CHRG dependencies on RA_CUSTOMER_TRX

Line 25: invoice_id ra_customer_trx_all.customer_trx_id%TYPE,

21: g_lo_date DATE;
22:
23: TYPE out_rec IS RECORD
24: (
25: invoice_id ra_customer_trx_all.customer_trx_id%TYPE,
26: payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,
27: charge_type fv_finance_charge_controls.charge_type%TYPE,
28: invoice_number ra_customer_trx_all.trx_number%TYPE,
29: amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE,

Line 28: invoice_number ra_customer_trx_all.trx_number%TYPE,

24: (
25: invoice_id ra_customer_trx_all.customer_trx_id%TYPE,
26: payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,
27: charge_type fv_finance_charge_controls.charge_type%TYPE,
28: invoice_number ra_customer_trx_all.trx_number%TYPE,
29: amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE,
30: amount_due_original ar_payment_schedules.amount_due_original%TYPE,
31: due_date ar_payment_schedules.due_date%TYPE,
32: amount_based VARCHAR2(1),

Line 280: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,

276: PROCEDURE accrue_charges
277: (
278: p_accrue_as_of_date IN DATE,
279: p_last_date IN DATE,
280: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
281: p_amount_due_remaining IN OUT NOCOPY ar_payment_schedules.amount_due_remaining%TYPE,
282: p_rate_amount IN NUMBER,
283: p_interval IN fv_finance_charge_controls.accrual_interval%TYPE,
284: p_charges OUT NOCOPY NUMBER,

Line 673: p_exchange_date IN ra_customer_trx.exchange_date%TYPE,

669: p_bill_to_customer_id IN NUMBER,
670: p_bill_to_contact_id IN NUMBER,
671: p_bill_to_address_id IN NUMBER,
672: p_term_id IN NUMBER,
673: p_exchange_date IN ra_customer_trx.exchange_date%TYPE,
674: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE,
675: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%TYPE,
676: p_root_invoice_id IN NUMBER,
677: p_org_id IN NUMBER,

Line 674: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE,

670: p_bill_to_contact_id IN NUMBER,
671: p_bill_to_address_id IN NUMBER,
672: p_term_id IN NUMBER,
673: p_exchange_date IN ra_customer_trx.exchange_date%TYPE,
674: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE,
675: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%TYPE,
676: p_root_invoice_id IN NUMBER,
677: p_org_id IN NUMBER,
678: p_rec_ccid IN NUMBER,

Line 675: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%TYPE,

671: p_bill_to_address_id IN NUMBER,
672: p_term_id IN NUMBER,
673: p_exchange_date IN ra_customer_trx.exchange_date%TYPE,
674: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE,
675: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%TYPE,
676: p_root_invoice_id IN NUMBER,
677: p_org_id IN NUMBER,
678: p_rec_ccid IN NUMBER,
679: p_rev_ccid IN NUMBER,

Line 703: l_dm_trx_number ra_customer_trx_all.trx_number%TYPE;

699: l_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
700: l_return_status VARCHAR2(10);
701: l_message_count NUMBER;
702: l_message_data VARCHAR2(1024);
703: l_dm_trx_number ra_customer_trx_all.trx_number%TYPE;
704: l_line_counter NUMBER;
705: l_dist_counter NUMBER;
706: l_prorated_line_amount NUMBER;
707: l_line_amount_due NUMBER;

Line 757: SELECT fv_ra_customer_trx_s.nextval

753: END IF;
754:
755: IF (p_retcode = g_SUCCESS) THEN
756: BEGIN
757: SELECT fv_ra_customer_trx_s.nextval
758: INTO l_dm_trx_number
759: FROM dual;
760: EXCEPTION
761: WHEN OTHERS THEN

Line 764: l_location := l_module_name||'.select_fv_ra_customer_trx_s';

760: EXCEPTION
761: WHEN OTHERS THEN
762: p_retcode := g_FAILURE;
763: p_errbuf := SQLERRM;
764: l_location := l_module_name||'.select_fv_ra_customer_trx_s';
765: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
766: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
767: END;
768: END IF;

Line 774: FROM ra_customer_trx_lines rctl

770: IF (p_retcode = g_SUCCESS) THEN
771: BEGIN
772: SELECT SUM(NVL(rctl.amount_due_remaining, rctl.quantity_invoiced*rctl.unit_selling_price))
773: INTO l_total_line_amount
774: FROM ra_customer_trx_lines rctl
775: WHERE rctl.customer_trx_id = p_parent_invoice_id;
776: IF (fnd_log.level_statement >= g_CURRENT_LOG_LEVEL) THEN
777: debug (l_module_name,'l_total_line_amount='||l_total_line_amount);
778: END IF;

Line 783: l_location := l_module_name||'.select_ra_customer_trx_lines';

779: EXCEPTION
780: WHEN OTHERS THEN
781: p_retcode := g_FAILURE;
782: p_errbuf := SQLERRM;
783: l_location := l_module_name||'.select_ra_customer_trx_lines';
784: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
785: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
786: END;
787: END IF;

Line 851: FROM ra_customer_trx_lines rctl

847: END LOOP;
848:
849: IF (p_prorate_charge = 'L') THEN
850: FOR inv_lines_rec IN (SELECT *
851: FROM ra_customer_trx_lines rctl
852: WHERE rctl.customer_trx_id = p_parent_invoice_id) LOOP
853: IF (fnd_log.level_statement >= g_CURRENT_LOG_LEVEL) THEN
854: debug (l_module_name,'inv_lines_rec.amount_due_remaining='||inv_lines_rec.amount_due_remaining);
855: debug (l_module_name,'inv_lines_rec.quantity_invoiced='||inv_lines_rec.quantity_invoiced);

Line 1083: UPDATE ra_customer_trx rct

1079: -- There is no way to put p_related_invoice_id in the API
1080: -- as it is giving an error. For the time being as a
1081: -- workaround updating the filed directly.
1082: BEGIN
1083: UPDATE ra_customer_trx rct
1084: SET rct.related_customer_trx_id = p_root_invoice_id,
1085: rct.interface_header_attribute3 = p_charge_type
1086: WHERE rct.customer_trx_id = p_dm_invoice_id;
1087: EXCEPTION

Line 1091: l_location := l_module_name||'.update_ra_customer_trx';

1087: EXCEPTION
1088: WHEN OTHERS THEN
1089: p_retcode := g_FAILURE;
1090: p_errbuf := SQLERRM;
1091: l_location := l_module_name||'.update_ra_customer_trx';
1092: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1093: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
1094: END;
1095: END IF;

Line 1127: p_exchange_date IN ra_customer_trx.exchange_date%TYPE,

1123: p_bill_to_customer_id IN NUMBER,
1124: p_bill_to_contact_id IN NUMBER,
1125: p_bill_to_address_id IN NUMBER,
1126: p_invoice_due_date IN DATE,
1127: p_exchange_date IN ra_customer_trx.exchange_date%TYPE,
1128: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE,
1129: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%TYPE,
1130: p_root_invoice_id IN NUMBER,
1131: p_invoice_date_type IN VARCHAR2,

Line 1128: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE,

1124: p_bill_to_contact_id IN NUMBER,
1125: p_bill_to_address_id IN NUMBER,
1126: p_invoice_due_date IN DATE,
1127: p_exchange_date IN ra_customer_trx.exchange_date%TYPE,
1128: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE,
1129: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%TYPE,
1130: p_root_invoice_id IN NUMBER,
1131: p_invoice_date_type IN VARCHAR2,
1132: p_immediate_term_id IN NUMBER,

Line 1129: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%TYPE,

1125: p_bill_to_address_id IN NUMBER,
1126: p_invoice_due_date IN DATE,
1127: p_exchange_date IN ra_customer_trx.exchange_date%TYPE,
1128: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE,
1129: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%TYPE,
1130: p_root_invoice_id IN NUMBER,
1131: p_invoice_date_type IN VARCHAR2,
1132: p_immediate_term_id IN NUMBER,
1133: p_invoice_term_id IN NUMBER,

Line 1150: l_dm_trx_number ra_customer_trx_all.trx_number%TYPE;

1146: l_module_name VARCHAR2(200);
1147: l_location VARCHAR2(200);
1148: l_term_id NUMBER;
1149: l_dm_invoice_id NUMBER;
1150: l_dm_trx_number ra_customer_trx_all.trx_number%TYPE;
1151: l_dm_trx_date ra_customer_trx_all.trx_date%TYPE;
1152: l_root_invoice_id NUMBER;
1153: BEGIN
1154: l_module_name := g_module_name || 'process_and_create_dm';

Line 1151: l_dm_trx_date ra_customer_trx_all.trx_date%TYPE;

1147: l_location VARCHAR2(200);
1148: l_term_id NUMBER;
1149: l_dm_invoice_id NUMBER;
1150: l_dm_trx_number ra_customer_trx_all.trx_number%TYPE;
1151: l_dm_trx_date ra_customer_trx_all.trx_date%TYPE;
1152: l_root_invoice_id NUMBER;
1153: BEGIN
1154: l_module_name := g_module_name || 'process_and_create_dm';
1155: p_retcode := g_SUCCESS;

Line 1308: FROM ra_customer_trx_lines rctl

1304: g_request_id,
1305: p_finance_charge_group_hdr_id,
1306: p_finance_charge_group_dtl_id,
1307: p_charge_id
1308: FROM ra_customer_trx_lines rctl
1309: WHERE rctl.customer_trx_id = l_dm_invoice_id;
1310: EXCEPTION
1311: WHEN OTHERS THEN
1312: p_retcode := g_FAILURE;

Line 1587: l_old_invoice_id ra_customer_trx.customer_trx_id%TYPE;

1583: l_location VARCHAR2(200);
1584: l_message VARCHAR2(1024);
1585: l_gl_date DATE;
1586: l_old_charge_id fv_finance_charge_controls.charge_id%TYPE;
1587: l_old_invoice_id ra_customer_trx.customer_trx_id%TYPE;
1588: l_accrue_as_of_date DATE;
1589: l_accrual_date DATE;
1590: l_finance_charges NUMBER;
1591: l_immediate_term_id NUMBER;

Line 1693: ra_customer_trx rct,

1689: FROM ar_payment_schedules aps,
1690: fv_invoice_finance_chrgs fifc,
1691: fv_finance_charge_controls fcc,
1692: fv_finance_charge_history fch,
1693: ra_customer_trx rct,
1694: ra_cust_trx_types rctt,
1695: hz_cust_site_uses_all rsua,
1696: fv_ar_fin_chrg_invoices fai
1697: WHERE (due_date + first_accrual + grace_period) <= l_accrue_as_of_date

Line 2350: (SELECT 'X' FROM ra_customer_trx_lines_all ral

2346: IF (p_retcode = g_SUCCESS) THEN
2347: BEGIN
2348: /* Bug 13035171. Replaced clause AND rctt.type IN ('DM','INV') with
2349: AND( rctt.type ='INV' OR (rctt.type ='DM' and not exists
2350: (SELECT 'X' FROM ra_customer_trx_lines_all ral
2351: WHERE description = 'Accrue Federal Finance Charges'
2352: AND ral.customer_trx_id = ract.customer_trx_id )))
2353: in both insert statements below. Assign Finance Charges report should display
2354: finance charges assigned to invoices and debit memos not created by the Accrue

Line 2397: FROM ra_customer_trx ract,

2393: g_user_id,
2394: SYSDATE,
2395: g_login_id,
2396: g_request_id
2397: FROM ra_customer_trx ract,
2398: ra_cust_trx_types rctt
2399: WHERE ract.cust_trx_type_id = rctt.cust_trx_type_id
2400: AND ract.complete_flag = 'Y'
2401: --AND rctt.type IN ('DM','INV')

Line 2403: ( SELECT 'X' FROM ra_customer_trx_lines_all ral

2399: WHERE ract.cust_trx_type_id = rctt.cust_trx_type_id
2400: AND ract.complete_flag = 'Y'
2401: --AND rctt.type IN ('DM','INV')
2402: AND( rctt.type ='INV' OR (rctt.type ='DM' AND NOT EXISTS
2403: ( SELECT 'X' FROM ra_customer_trx_lines_all ral
2404: WHERE description = 'Accrue Federal Finance Charges'
2405: AND ral.customer_trx_id = ract.customer_trx_id )))
2406:
2407: /* AND NVL(ract.interface_header_attribute3,'XX') NOT IN (SELECT charge_type

Line 2464: FROM ra_customer_trx ract,

2460: fcgd.base_charge_id,
2461: fcgh.finance_charge_group_hdr_id,
2462: fcgd.finance_charge_group_dtl_id,
2463: 'Y'
2464: FROM ra_customer_trx ract,
2465: fv_cust_finance_chrgs fcfc,
2466: fv_finance_charge_controls fcc,
2467: ra_cust_trx_types rctt,
2468: fv_finance_charge_grp_dtls fcgd,

Line 2481: ( SELECT 'X' FROM ra_customer_trx_lines_all ral

2477: AND fcfc.enabled_flag = 'Y'
2478: AND fcfc.waive_flag = 'N'
2479: --AND rctt.type IN ('DM','INV')
2480: AND( rctt.type ='INV' OR (rctt.type ='DM' AND NOT EXISTS
2481: ( SELECT 'X' FROM ra_customer_trx_lines_all ral
2482: WHERE description = 'Accrue Federal Finance Charges'
2483: AND ral.customer_trx_id = ract.customer_trx_id )))
2484: AND fcgd.finance_charge_group_hdr_id = fcgh.finance_charge_group_hdr_id
2485: AND fcgh.enabled_flag = 'Y'