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

Line 72: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,

68:
69: PROCEDURE Get_Doc_Entitity_Data (
70: p_level IN VARCHAR2 ,
71: p_app_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ,
72: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
73: p_trh_rec OUT NOCOPY ar_transaction_history%ROWTYPE , -- jrautiai
74: p_rule_rec OUT NOCOPY ae_rule_rec_type );
75:
76: PROCEDURE Create_Ae_Lines_Common (

Line 81: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,

77: p_level IN VARCHAR2 );
78:
79: PROCEDURE Create_Ae_Lines_BR(
80: p_app_rec IN ar_receivable_applications%ROWTYPE ,
81: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
82: p_trh_rec IN ar_transaction_history%ROWTYPE , -- jrautiai
83: p_rule_rec IN ae_rule_rec_type );
84:
85: PROCEDURE Assign_Ael_Elements(

Line 93: PROCEDURE create_exchanged_trx_acct(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,

89: PROCEDURE initialize_global_variables(p_trh_rec IN ar_transaction_history%ROWTYPE);
90:
91: FUNCTION trx_history_status(p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE) RETURN VARCHAR2;
92:
93: PROCEDURE create_exchanged_trx_acct(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
94: p_ae_rule_rec IN ae_rule_rec_type);
95:
96: FUNCTION find_exchanged_trx_acct(p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE) RETURN NUMBER;
97:

Line 671: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,

667: * ======================================================================*/
668: PROCEDURE Get_Doc_Entitity_Data (
669: p_level IN VARCHAR2 ,
670: p_app_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ,
671: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
672: p_trh_rec OUT NOCOPY ar_transaction_history%ROWTYPE ,
673: p_rule_rec OUT NOCOPY ae_rule_rec_type) IS
674:
675: BEGIN

Line 766: ra_customer_trx ctinv,

762: p_trh_rec.status,
763: p_trh_rec.event,
764: p_trh_rec.prv_trx_history_id
765: from ar_transaction_history th,
766: ra_customer_trx ctinv,
767: ar_payment_schedules pay
768: where th.transaction_history_id = g_ae_doc_rec.source_id
769: and th.customer_trx_id = ctinv.customer_trx_id
770: and ctinv.customer_trx_id = pay.customer_trx_id;

Line 856: l_cust_inv_rec ra_customer_trx%ROWTYPE ;

852: PROCEDURE Create_Ae_Lines_Common (
853: p_level IN VARCHAR2 ) IS
854:
855: l_app_rec ar_receivable_applications%ROWTYPE ;
856: l_cust_inv_rec ra_customer_trx%ROWTYPE ;
857: l_trh_rec ar_transaction_history%ROWTYPE ; -- jrautiai
858: l_rule_rec ae_rule_rec_type ;
859:
860: BEGIN

Line 922: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,

918: | p_rule_rec Rule Record
919: * ======================================================================*/
920: PROCEDURE Create_Ae_Lines_BR(
921: p_app_rec IN ar_receivable_applications%ROWTYPE ,
922: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
923: p_trh_rec IN ar_transaction_history%ROWTYPE , -- jrautiai
924: p_rule_rec IN ae_rule_rec_type ) IS
925:
926: l_app_id ar_receivable_applications.receivable_application_id%TYPE;

Line 2288: (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,

2284: | PARAMETERS
2285: | p_customer_trx_id Transaction ID
2286: * ======================================================================*/
2287: PROCEDURE create_exchanged_trx_acct
2288: (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
2289: -- HYUDETDIST
2290: p_ae_rule_rec IN ae_rule_rec_type)
2291: --}
2292: IS

Line 2298: CURSOR all_exchanges_cur(l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE) IS

2294: | Cursor to return all rows exchanged on the BR. |
2295: +--------------------------------------------------*/
2296:
2297: -- MRC Trigger Replacement: select currency sensitive data.
2298: CURSOR all_exchanges_cur(l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE) IS
2299: SELECT ctl.br_ref_customer_trx_id source_trx_id,
2300: ctl.br_ref_payment_schedule_id source_ps_id,
2301: ctl.customer_trx_line_id,
2302: adj.amount adjustment_amount,

Line 2353: FROM ra_customer_trx_lines ctl,

2349: -- ps.payment_schedule_id,
2350: -- g_ae_sys_rec.set_of_books_id)) exchange_date
2351: ps.exchange_date exchange_date
2352: --}
2353: FROM ra_customer_trx_lines ctl,
2354: ar_payment_schedules ps,
2355: ar_payment_schedules assignment_ps,
2356: ra_customer_trx ct,
2357: ar_adjustments adj

Line 2356: ra_customer_trx ct,

2352: --}
2353: FROM ra_customer_trx_lines ctl,
2354: ar_payment_schedules ps,
2355: ar_payment_schedules assignment_ps,
2356: ra_customer_trx ct,
2357: ar_adjustments adj
2358: WHERE assignment_ps.payment_schedule_id = ctl.br_ref_payment_schedule_id
2359: AND ps.customer_trx_id = ct.customer_trx_id
2360: AND adj.adjustment_id = ctl.br_adjustment_id

Line 2366: SELECT * FROM ra_customer_trx

2362: AND ct.customer_trx_id = l_customer_trx_id;
2363:
2364: CURSOR c_trx(p_customer_trx_id IN NUMBER)
2365: IS
2366: SELECT * FROM ra_customer_trx
2367: WHERE customer_trx_id = p_customer_trx_id;
2368:
2369:
2370: /*--------------------------------------------------+

Line 2374: CURSOR TRX_exchange_cur(l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE) IS

2370: /*--------------------------------------------------+
2371: | Cursor for the accounting on normal transactions |
2372: | from table ra_cust_trx_line_gl_dist |
2373: +--------------------------------------------------*/
2374: CURSOR TRX_exchange_cur(l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE) IS
2375: SELECT dist.code_combination_id
2376: FROM ra_cust_trx_line_gl_dist dist
2377: WHERE dist.customer_trx_id = l_customer_trx_id
2378: AND dist.account_class = C_REC

Line 2385: CURSOR BR_exchange_cur(l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE) IS

2381: /*--------------------------------------------------+
2382: | Cursor for the currenct accounted record of the |
2383: | exchanged BR |
2384: +--------------------------------------------------*/
2385: CURSOR BR_exchange_cur(l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE) IS
2386: SELECT th.transaction_history_id
2387: FROM ar_transaction_history th
2388: WHERE th.customer_trx_id = l_customer_trx_id
2389: AND th.current_accounted_flag = 'Y';

Line 2400: l_cust_trx_rec ra_customer_trx%ROWTYPE;

2396: l_ael_line_rec ae_line_rec_type;
2397: l_ael_empty_line_rec ae_line_rec_type;
2398: --{HYUDETDIST
2399: l_adj_rec ar_adjustments%ROWTYPE;
2400: l_cust_trx_rec ra_customer_trx%ROWTYPE;
2401: l_app_rec ar_receivable_applications%ROWTYPE;
2402: l_ae_ctr NUMBER := 0;
2403: l_ae_line_tbl ae_line_tbl_type;
2404: l_ae_empty_line_tbl ae_line_tbl_type;