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

Line 255: CURSOR c_get_trx_info(p_trx_id RA_CUSTOMER_TRX.CUSTOMER_TRX_ID%TYPE)

251: v_source VARCHAR2(50) ;
252: v_next_pay NUMBER ;
253: l_debug_info VARCHAR2(2000);
254:
255: CURSOR c_get_trx_info(p_trx_id RA_CUSTOMER_TRX.CUSTOMER_TRX_ID%TYPE)
256: IS
257: SELECT trx.previous_customer_trx_id
258: , trx.complete_flag
259: , ctt.accounting_affect_flag

Line 263: FROM ra_customer_trx_all trx

259: , ctt.accounting_affect_flag
260: , ctt.creation_sign
261: , ctt.allow_overapplication_flag
262: , ctt.natural_application_only_flag
263: FROM ra_customer_trx_all trx
264: , ra_cust_trx_types_all ctt
265: WHERE trx.customer_trx_id = p_trx_id
266: AND trx.cust_trx_type_id = ctt.cust_trx_type_id
267: AND trx.org_id = ctt.org_id;

Line 269: l_previous_customer_trx_id ra_customer_trx.previous_customer_trx_id%TYPE;

265: WHERE trx.customer_trx_id = p_trx_id
266: AND trx.cust_trx_type_id = ctt.cust_trx_type_id
267: AND trx.org_id = ctt.org_id;
268:
269: l_previous_customer_trx_id ra_customer_trx.previous_customer_trx_id%TYPE;
270: l_complete_flag ra_customer_trx.complete_flag%TYPE;
271: l_trx_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%TYPE;
272: l_creation_sign ra_cust_trx_types.creation_sign%TYPE;
273: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;

Line 270: l_complete_flag ra_customer_trx.complete_flag%TYPE;

266: AND trx.cust_trx_type_id = ctt.cust_trx_type_id
267: AND trx.org_id = ctt.org_id;
268:
269: l_previous_customer_trx_id ra_customer_trx.previous_customer_trx_id%TYPE;
270: l_complete_flag ra_customer_trx.complete_flag%TYPE;
271: l_trx_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%TYPE;
272: l_creation_sign ra_cust_trx_types.creation_sign%TYPE;
273: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;
274: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%TYPE;

Line 278: CURSOR c_get_prev_trx_info(p_trx_id RA_CUSTOMER_TRX.CUSTOMER_TRX_ID%TYPE)

274: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%TYPE;
275: p_error_message VARCHAR2(2000);
276:
277:
278: CURSOR c_get_prev_trx_info(p_trx_id RA_CUSTOMER_TRX.CUSTOMER_TRX_ID%TYPE)
279: IS
280: SELECT ctt.accounting_affect_flag
281: FROM ra_customer_trx_all trx
282: , ra_cust_trx_types_all ctt

Line 281: FROM ra_customer_trx_all trx

277:
278: CURSOR c_get_prev_trx_info(p_trx_id RA_CUSTOMER_TRX.CUSTOMER_TRX_ID%TYPE)
279: IS
280: SELECT ctt.accounting_affect_flag
281: FROM ra_customer_trx_all trx
282: , ra_cust_trx_types_all ctt
283: WHERE trx.customer_trx_id = p_trx_id
284: AND trx.cust_trx_type_id = ctt.cust_trx_type_id
285: AND trx.org_id = ctt.org_id;

Line 337: UPDATE ra_customer_trx

333: -----------------------------
334: l_debug_info := ' v_count = 0';
335: --dbms_output.put_line(l_debug_info);
336: ----------------------------------
337: UPDATE ra_customer_trx
338: SET complete_flag = 'Y'
339: WHERE customer_trx_id = p_customer_trx;
340:
341: -----------------------------

Line 342: l_debug_info := 'UPDATE ra_customer_trx complete';

338: SET complete_flag = 'Y'
339: WHERE customer_trx_id = p_customer_trx;
340:
341: -----------------------------
342: l_debug_info := 'UPDATE ra_customer_trx complete';
343: --dbms_output.put_line(l_debug_info);
344: ----------------------------------
345:
346: OPEN c_get_trx_info(p_customer_trx);

Line 780: FROM ra_customer_trx_all rct

776: SELECT rct.customer_trx_id
777: , rct.trx_number
778: , rctt.name
779: , arl.meaning
780: FROM ra_customer_trx_all rct
781: , igi_exp_ar_trans i
782: , ar_lookups arl
783: , ra_cust_trx_types_all rctt
784: WHERE i.du_id = pv_du_id

Line 1031: UPDATE ra_customer_trx rct

1027: rgd.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)
1028: WHERE rgd.customer_trx_id = r_ar_trx.customer_trx_id
1029: AND rgd.gl_posted_date IS NULL;
1030:
1031: UPDATE ra_customer_trx rct
1032: SET rct.trx_date = TRUNC(p_gl_date),
1033: rct.last_update_login = NVL(fnd_profile.value('LOGIN_ID'),-1),
1034: rct.last_update_date = SYSDATE,
1035: rct.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)