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_PROCESS_HEADER dependencies on RA_CUST_TRX_TYPES

Line 197: ra_cust_trx_types.accounting_affect_flag%type,

193: p_new_trx_rec IN ra_customer_trx%rowtype,
194: p_new_gl_date IN
195: ra_cust_trx_line_gl_dist.gl_date%type,
196: p_new_open_rec_flag IN
197: ra_cust_trx_types.accounting_affect_flag%type,
198: p_ps_dispute_amount IN
199: ar_payment_schedules.amount_in_dispute%type,
200: pd_dispute_date IN DATE,
201: p_ex_rate_changed_flag OUT NOCOPY boolean,

Line 214: l_old_open_rec_flag ra_cust_trx_types.accounting_affect_flag%type;

210: IS
211:
212: l_old_trx_rec ra_customer_trx%rowtype;
213: l_old_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
214: l_old_open_rec_flag ra_cust_trx_types.accounting_affect_flag%type;
215: l_old_dispute_amount ar_payment_schedules.amount_in_dispute%type;
216: ld_old_dispute_date DATE;
217:
218: BEGIN

Line 296: from ra_cust_trx_types

292: )
293: THEN
294: select accounting_affect_flag
295: into l_old_open_rec_flag
296: from ra_cust_trx_types
297: where cust_trx_type_id = l_old_trx_rec.cust_trx_type_id;
298:
299: IF l_old_open_rec_flag <> p_new_open_rec_flag
300: THEN p_open_rec_changed_flag := TRUE;

Line 801: p_trx_class IN ra_cust_trx_types.type%type,

797: PROCEDURE insert_header(
798: p_form_name IN varchar2,
799: p_form_version IN number,
800: p_trx_rec IN ra_customer_trx%rowtype,
801: p_trx_class IN ra_cust_trx_types.type%type,
802: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
803: p_term_in_use_flag IN varchar2,
804: p_commitment_rec IN arp_process_commitment.commitment_rec_type,
805: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,

Line 902: FROM ra_cust_trx_types

898: THEN
899:
900: SELECT NVL( default_printing_option, 'PRI' )
901: INTO l_trx_rec.printing_option
902: FROM ra_cust_trx_types
903: WHERE cust_trx_type_id = l_trx_rec.cust_trx_type_id;
904:
905: END IF;
906:

Line 1079: p_trx_class IN ra_cust_trx_types.type%type,

1075: p_form_version IN number,
1076: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
1077: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1078: p_trx_amount IN number,
1079: p_trx_class IN ra_cust_trx_types.type%type,
1080: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1081: p_initial_customer_trx_line_id IN
1082: ra_customer_trx_lines.initial_customer_trx_line_id%type
1083: default null,

Line 1085: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,

1081: p_initial_customer_trx_line_id IN
1082: ra_customer_trx_lines.initial_customer_trx_line_id%type
1083: default null,
1084: p_commitment_rec IN arp_process_commitment.commitment_rec_type,
1085: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,
1086: p_term_in_use_flag IN varchar2,
1087: p_recalc_tax_flag IN boolean,
1088: p_rerun_autoacc_flag IN boolean,
1089: p_ps_dispute_amount IN NUMBER DEFAULT NULL,

Line 1668: ra_cust_trx_types ctt,

1664: l_post_to_gl,
1665: l_event_status_code
1666: from
1667: ra_customer_trx ct ,
1668: ra_cust_trx_types ctt,
1669: xla_transaction_entities_upg xet ,
1670: xla_events xe
1671: where ct.customer_trx_id = p_customer_trx_id
1672: and ctt.cust_trx_type_id = ct.cust_trx_type_id

Line 1934: ra_cust_trx_types.accounting_affect_flag%type,

1930: ra_customer_trx.previous_customer_trx_id%type,
1931: p_complete_flag IN
1932: ra_customer_trx.complete_flag%type,
1933: p_trx_open_receivables_flag IN
1934: ra_cust_trx_types.accounting_affect_flag%type,
1935: p_prev_open_receivables_flag IN
1936: ra_cust_trx_types.accounting_affect_flag%type,
1937: p_creation_sign IN
1938: ra_cust_trx_types.creation_sign%type,

Line 1936: ra_cust_trx_types.accounting_affect_flag%type,

1932: ra_customer_trx.complete_flag%type,
1933: p_trx_open_receivables_flag IN
1934: ra_cust_trx_types.accounting_affect_flag%type,
1935: p_prev_open_receivables_flag IN
1936: ra_cust_trx_types.accounting_affect_flag%type,
1937: p_creation_sign IN
1938: ra_cust_trx_types.creation_sign%type,
1939: p_allow_overapplication_flag IN
1940: ra_cust_trx_types.allow_overapplication_flag%type,

Line 1938: ra_cust_trx_types.creation_sign%type,

1934: ra_cust_trx_types.accounting_affect_flag%type,
1935: p_prev_open_receivables_flag IN
1936: ra_cust_trx_types.accounting_affect_flag%type,
1937: p_creation_sign IN
1938: ra_cust_trx_types.creation_sign%type,
1939: p_allow_overapplication_flag IN
1940: ra_cust_trx_types.allow_overapplication_flag%type,
1941: p_natural_application_flag IN
1942: ra_cust_trx_types.natural_application_only_flag%type,

Line 1940: ra_cust_trx_types.allow_overapplication_flag%type,

1936: ra_cust_trx_types.accounting_affect_flag%type,
1937: p_creation_sign IN
1938: ra_cust_trx_types.creation_sign%type,
1939: p_allow_overapplication_flag IN
1940: ra_cust_trx_types.allow_overapplication_flag%type,
1941: p_natural_application_flag IN
1942: ra_cust_trx_types.natural_application_only_flag%type,
1943: p_cash_receipt_id IN
1944: ar_cash_receipts.cash_receipt_id%type DEFAULT NULL

Line 1942: ra_cust_trx_types.natural_application_only_flag%type,

1938: ra_cust_trx_types.creation_sign%type,
1939: p_allow_overapplication_flag IN
1940: ra_cust_trx_types.allow_overapplication_flag%type,
1941: p_natural_application_flag IN
1942: ra_cust_trx_types.natural_application_only_flag%type,
1943: p_cash_receipt_id IN
1944: ar_cash_receipts.cash_receipt_id%type DEFAULT NULL
1945: ) IS
1946:

Line 2008: p_trx_class IN ra_cust_trx_types.type%type,

2004: PROCEDURE update_header_freight_cover(
2005: p_form_name IN varchar2,
2006: p_form_version IN number,
2007: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2008: p_trx_class IN ra_cust_trx_types.type%type,
2009: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,
2010: p_ship_via IN ra_customer_trx.ship_via%type,
2011: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
2012: p_waybill_number IN ra_customer_trx.waybill_number%type,

Line 2009: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,

2005: p_form_name IN varchar2,
2006: p_form_version IN number,
2007: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2008: p_trx_class IN ra_cust_trx_types.type%type,
2009: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,
2010: p_ship_via IN ra_customer_trx.ship_via%type,
2011: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
2012: p_waybill_number IN ra_customer_trx.waybill_number%type,
2013: p_fob_point IN ra_customer_trx.fob_point%type,

Line 2356: l_ctt_prev_class ra_cust_trx_types.type%type;

2352: l_prev_trx_balance number;
2353: l_rac_prev_bill_to_cust_name hz_parties.party_name%type;
2354: l_rac_prev_bill_to_cust_num hz_cust_accounts.account_number%type;
2355: l_bs_prev_source_name ra_batch_sources.name%type;
2356: l_ctt_prev_class ra_cust_trx_types.type%type;
2357: l_ctt_prev_allow_overapp_flag
2358: ra_cust_trx_types.allow_overapplication_flag%type;
2359: l_ctt_prev_natural_app_only
2360: ra_cust_trx_types.natural_application_only_flag%type;

Line 2358: ra_cust_trx_types.allow_overapplication_flag%type;

2354: l_rac_prev_bill_to_cust_num hz_cust_accounts.account_number%type;
2355: l_bs_prev_source_name ra_batch_sources.name%type;
2356: l_ctt_prev_class ra_cust_trx_types.type%type;
2357: l_ctt_prev_allow_overapp_flag
2358: ra_cust_trx_types.allow_overapplication_flag%type;
2359: l_ctt_prev_natural_app_only
2360: ra_cust_trx_types.natural_application_only_flag%type;
2361: l_ct_prev_open_receivables
2362: ra_cust_trx_types.accounting_affect_flag%type; /* Bug-3954193 */

Line 2360: ra_cust_trx_types.natural_application_only_flag%type;

2356: l_ctt_prev_class ra_cust_trx_types.type%type;
2357: l_ctt_prev_allow_overapp_flag
2358: ra_cust_trx_types.allow_overapplication_flag%type;
2359: l_ctt_prev_natural_app_only
2360: ra_cust_trx_types.natural_application_only_flag%type;
2361: l_ct_prev_open_receivables
2362: ra_cust_trx_types.accounting_affect_flag%type; /* Bug-3954193 */
2363: l_ct_prev_post_to_gl_flag
2364: ra_cust_trx_types.post_to_gl%type; /* Bug-3954193 */

Line 2362: ra_cust_trx_types.accounting_affect_flag%type; /* Bug-3954193 */

2358: ra_cust_trx_types.allow_overapplication_flag%type;
2359: l_ctt_prev_natural_app_only
2360: ra_cust_trx_types.natural_application_only_flag%type;
2361: l_ct_prev_open_receivables
2362: ra_cust_trx_types.accounting_affect_flag%type; /* Bug-3954193 */
2363: l_ct_prev_post_to_gl_flag
2364: ra_cust_trx_types.post_to_gl%type; /* Bug-3954193 */
2365: l_al_cm_reason_meaning ar_lookups.meaning%type;
2366: l_ct_prev_rowid rowid;

Line 2364: ra_cust_trx_types.post_to_gl%type; /* Bug-3954193 */

2360: ra_cust_trx_types.natural_application_only_flag%type;
2361: l_ct_prev_open_receivables
2362: ra_cust_trx_types.accounting_affect_flag%type; /* Bug-3954193 */
2363: l_ct_prev_post_to_gl_flag
2364: ra_cust_trx_types.post_to_gl%type; /* Bug-3954193 */
2365: l_al_cm_reason_meaning ar_lookups.meaning%type;
2366: l_ct_prev_rowid rowid;
2367: l_commit_memo_line_id ra_customer_trx_lines.memo_line_id%type;
2368: l_commit_memo_line_desc ar_memo_lines.description%type;

Line 2709: ra_cust_trx_types ctt_prev,

2705: ra_cust_trx_line_gl_dist gd_prev,
2706: hz_cust_accounts rac_prev,
2707: hz_parties party,
2708: ra_batch_sources bs_prev,
2709: ra_cust_trx_types ctt_prev,
2710: ar_lookups al_cm_reason
2711: WHERE ct.rowid = p_ct_rowid
2712: and ct.previous_customer_trx_id = ct_prev.customer_trx_id
2713: and ct_prev.batch_source_id = bs_prev.batch_source_id