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 858: p_trx_class IN ra_cust_trx_types.type%type,

854: PROCEDURE insert_header(
855: p_form_name IN varchar2,
856: p_form_version IN number,
857: p_trx_rec IN ra_customer_trx%rowtype,
858: p_trx_class IN ra_cust_trx_types.type%type,
859: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
860: p_term_in_use_flag IN varchar2,
861: p_commitment_rec IN arp_process_commitment.commitment_rec_type,
862: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,

Line 959: FROM ra_cust_trx_types

955: THEN
956:
957: SELECT NVL( default_printing_option, 'PRI' )
958: INTO l_trx_rec.printing_option
959: FROM ra_cust_trx_types
960: WHERE cust_trx_type_id = l_trx_rec.cust_trx_type_id;
961:
962: END IF;
963:

Line 1136: p_trx_class IN ra_cust_trx_types.type%type,

1132: p_form_version IN number,
1133: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
1134: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1135: p_trx_amount IN number,
1136: p_trx_class IN ra_cust_trx_types.type%type,
1137: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1138: p_initial_customer_trx_line_id IN
1139: ra_customer_trx_lines.initial_customer_trx_line_id%type
1140: default null,

Line 1142: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,

1138: p_initial_customer_trx_line_id IN
1139: ra_customer_trx_lines.initial_customer_trx_line_id%type
1140: default null,
1141: p_commitment_rec IN arp_process_commitment.commitment_rec_type,
1142: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,
1143: p_term_in_use_flag IN varchar2,
1144: p_recalc_tax_flag IN boolean,
1145: p_rerun_autoacc_flag IN boolean,
1146: p_ps_dispute_amount IN NUMBER DEFAULT NULL,

Line 1748: ra_cust_trx_types ctt,

1744: l_post_to_gl,
1745: l_event_status_code
1746: from
1747: ra_customer_trx ct ,
1748: ra_cust_trx_types ctt,
1749: xla_transaction_entities_upg xet ,
1750: xla_events xe
1751: where ct.customer_trx_id = p_customer_trx_id
1752: and ctt.cust_trx_type_id = ct.cust_trx_type_id

Line 2014: ra_cust_trx_types.accounting_affect_flag%type,

2010: ra_customer_trx.previous_customer_trx_id%type,
2011: p_complete_flag IN
2012: ra_customer_trx.complete_flag%type,
2013: p_trx_open_receivables_flag IN
2014: ra_cust_trx_types.accounting_affect_flag%type,
2015: p_prev_open_receivables_flag IN
2016: ra_cust_trx_types.accounting_affect_flag%type,
2017: p_creation_sign IN
2018: ra_cust_trx_types.creation_sign%type,

Line 2016: ra_cust_trx_types.accounting_affect_flag%type,

2012: ra_customer_trx.complete_flag%type,
2013: p_trx_open_receivables_flag IN
2014: ra_cust_trx_types.accounting_affect_flag%type,
2015: p_prev_open_receivables_flag IN
2016: ra_cust_trx_types.accounting_affect_flag%type,
2017: p_creation_sign IN
2018: ra_cust_trx_types.creation_sign%type,
2019: p_allow_overapplication_flag IN
2020: ra_cust_trx_types.allow_overapplication_flag%type,

Line 2018: ra_cust_trx_types.creation_sign%type,

2014: ra_cust_trx_types.accounting_affect_flag%type,
2015: p_prev_open_receivables_flag IN
2016: ra_cust_trx_types.accounting_affect_flag%type,
2017: p_creation_sign IN
2018: ra_cust_trx_types.creation_sign%type,
2019: p_allow_overapplication_flag IN
2020: ra_cust_trx_types.allow_overapplication_flag%type,
2021: p_natural_application_flag IN
2022: ra_cust_trx_types.natural_application_only_flag%type,

Line 2020: ra_cust_trx_types.allow_overapplication_flag%type,

2016: ra_cust_trx_types.accounting_affect_flag%type,
2017: p_creation_sign IN
2018: ra_cust_trx_types.creation_sign%type,
2019: p_allow_overapplication_flag IN
2020: ra_cust_trx_types.allow_overapplication_flag%type,
2021: p_natural_application_flag IN
2022: ra_cust_trx_types.natural_application_only_flag%type,
2023: p_cash_receipt_id IN
2024: ar_cash_receipts.cash_receipt_id%type DEFAULT NULL

Line 2022: ra_cust_trx_types.natural_application_only_flag%type,

2018: ra_cust_trx_types.creation_sign%type,
2019: p_allow_overapplication_flag IN
2020: ra_cust_trx_types.allow_overapplication_flag%type,
2021: p_natural_application_flag IN
2022: ra_cust_trx_types.natural_application_only_flag%type,
2023: p_cash_receipt_id IN
2024: ar_cash_receipts.cash_receipt_id%type DEFAULT NULL
2025: ) IS
2026:

Line 2088: p_trx_class IN ra_cust_trx_types.type%type,

2084: PROCEDURE update_header_freight_cover(
2085: p_form_name IN varchar2,
2086: p_form_version IN number,
2087: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2088: p_trx_class IN ra_cust_trx_types.type%type,
2089: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,
2090: p_ship_via IN ra_customer_trx.ship_via%type,
2091: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
2092: p_waybill_number IN ra_customer_trx.waybill_number%type,

Line 2089: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,

2085: p_form_name IN varchar2,
2086: p_form_version IN number,
2087: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2088: p_trx_class IN ra_cust_trx_types.type%type,
2089: p_open_rec_flag IN ra_cust_trx_types.accounting_affect_flag%type,
2090: p_ship_via IN ra_customer_trx.ship_via%type,
2091: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
2092: p_waybill_number IN ra_customer_trx.waybill_number%type,
2093: p_fob_point IN ra_customer_trx.fob_point%type,

Line 2436: l_ctt_prev_class ra_cust_trx_types.type%type;

2432: l_prev_trx_balance number;
2433: l_rac_prev_bill_to_cust_name hz_parties.party_name%type;
2434: l_rac_prev_bill_to_cust_num hz_cust_accounts.account_number%type;
2435: l_bs_prev_source_name ra_batch_sources.name%type;
2436: l_ctt_prev_class ra_cust_trx_types.type%type;
2437: l_ctt_prev_allow_overapp_flag
2438: ra_cust_trx_types.allow_overapplication_flag%type;
2439: l_ctt_prev_natural_app_only
2440: ra_cust_trx_types.natural_application_only_flag%type;

Line 2438: ra_cust_trx_types.allow_overapplication_flag%type;

2434: l_rac_prev_bill_to_cust_num hz_cust_accounts.account_number%type;
2435: l_bs_prev_source_name ra_batch_sources.name%type;
2436: l_ctt_prev_class ra_cust_trx_types.type%type;
2437: l_ctt_prev_allow_overapp_flag
2438: ra_cust_trx_types.allow_overapplication_flag%type;
2439: l_ctt_prev_natural_app_only
2440: ra_cust_trx_types.natural_application_only_flag%type;
2441: l_ct_prev_open_receivables
2442: ra_cust_trx_types.accounting_affect_flag%type; /* Bug-3954193 */

Line 2440: ra_cust_trx_types.natural_application_only_flag%type;

2436: l_ctt_prev_class ra_cust_trx_types.type%type;
2437: l_ctt_prev_allow_overapp_flag
2438: ra_cust_trx_types.allow_overapplication_flag%type;
2439: l_ctt_prev_natural_app_only
2440: ra_cust_trx_types.natural_application_only_flag%type;
2441: l_ct_prev_open_receivables
2442: ra_cust_trx_types.accounting_affect_flag%type; /* Bug-3954193 */
2443: l_ct_prev_post_to_gl_flag
2444: ra_cust_trx_types.post_to_gl%type; /* Bug-3954193 */

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

2438: ra_cust_trx_types.allow_overapplication_flag%type;
2439: l_ctt_prev_natural_app_only
2440: ra_cust_trx_types.natural_application_only_flag%type;
2441: l_ct_prev_open_receivables
2442: ra_cust_trx_types.accounting_affect_flag%type; /* Bug-3954193 */
2443: l_ct_prev_post_to_gl_flag
2444: ra_cust_trx_types.post_to_gl%type; /* Bug-3954193 */
2445: l_al_cm_reason_meaning ar_lookups.meaning%type;
2446: l_ct_prev_rowid rowid;

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

2440: ra_cust_trx_types.natural_application_only_flag%type;
2441: l_ct_prev_open_receivables
2442: ra_cust_trx_types.accounting_affect_flag%type; /* Bug-3954193 */
2443: l_ct_prev_post_to_gl_flag
2444: ra_cust_trx_types.post_to_gl%type; /* Bug-3954193 */
2445: l_al_cm_reason_meaning ar_lookups.meaning%type;
2446: l_ct_prev_rowid rowid;
2447: l_commit_memo_line_id ra_customer_trx_lines.memo_line_id%type;
2448: l_commit_memo_line_desc ar_memo_lines.description%type;

Line 2789: ra_cust_trx_types ctt_prev,

2785: ra_cust_trx_line_gl_dist gd_prev,
2786: hz_cust_accounts rac_prev,
2787: hz_parties party,
2788: ra_batch_sources bs_prev,
2789: ra_cust_trx_types ctt_prev,
2790: ar_lookups al_cm_reason
2791: WHERE ct.rowid = p_ct_rowid
2792: and ct.previous_customer_trx_id = ct_prev.customer_trx_id
2793: and ct_prev.batch_source_id = bs_prev.batch_source_id