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_CHARGEBACK dependencies on ARP_GLOBAL

Line 96: l_app_rec arp_global.app_rec_type;

92: --
93: l_adj_rec ar_adjustments%ROWTYPE;
94: --
95: l_return_code VARCHAR2(20);
96: l_app_rec arp_global.app_rec_type;
97: --
98: l_msg_count number;
99: l_msg_data varchar2(250);
100: l_return_status varchar2(10);

Line 231: l_adj_rec.receivables_trx_id := arp_global.G_CB_REV_RT_ID;

227: --
228: l_adj_rec.customer_trx_id := p_cb_ct_id;
229: --
230: l_adj_rec.payment_schedule_id := l_ps_id;
231: l_adj_rec.receivables_trx_id := arp_global.G_CB_REV_RT_ID;
232: l_adj_rec.POSTABLE := 'Y';
233: l_adj_rec.type := 'INVOICE';
234: l_adj_rec.adjustment_type := 'M';
235: --

Line 384: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID

380: WHERE ra.applied_customer_trx_id in (
381: SELECT a.chargeback_customer_trx_id
382: FROM ar_adjustments b,
383: ar_adjustments a
384: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
385: AND a.associated_cash_receipt_id = p_ass_cr_id
386: AND a.payment_schedule_id = p_ps_id
387: AND b.receivables_trx_id(+) =
388: arp_global.G_CB_REV_RT_ID

Line 388: arp_global.G_CB_REV_RT_ID

384: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
385: AND a.associated_cash_receipt_id = p_ass_cr_id
386: AND a.payment_schedule_id = p_ps_id
387: AND b.receivables_trx_id(+) =
388: arp_global.G_CB_REV_RT_ID
389: AND b.customer_trx_id(+) = a.chargeback_customer_trx_id
390: AND b.customer_trx_id is NULL );
391: --
392: IF PG_DEBUG in ('Y', 'C') THEN

Line 417: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID

413: WHERE customer_trx_id in (
414: SELECT a.chargeback_customer_trx_id
415: FROM ar_adjustments a,
416: ar_adjustments b
417: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
418: AND a.associated_cash_receipt_id = p_ass_cr_id
419: AND a.payment_schedule_id = p_ps_id
420: AND b.receivables_trx_id(+) =
421: arp_global.G_CB_REV_RT_ID

Line 421: arp_global.G_CB_REV_RT_ID

417: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
418: AND a.associated_cash_receipt_id = p_ass_cr_id
419: AND a.payment_schedule_id = p_ps_id
420: AND b.receivables_trx_id(+) =
421: arp_global.G_CB_REV_RT_ID
422: AND b.customer_trx_id(+) = a.chargeback_customer_trx_id
423: AND b.customer_trx_id is NULL )
424: AND NVL( postable, 'Y') = 'Y';
425: --

Line 456: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID

452: WHERE ct.customer_trx_id in (
453: SELECT a.chargeback_customer_trx_id
454: FROM ar_adjustments b,
455: ar_adjustments a
456: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
457: AND a.associated_cash_receipt_id = p_ass_cr_id
458: AND a.payment_schedule_id = p_ps_id
459: AND b.receivables_trx_id(+) =
460: arp_global.G_CB_REV_RT_ID

Line 460: arp_global.G_CB_REV_RT_ID

456: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
457: AND a.associated_cash_receipt_id = p_ass_cr_id
458: AND a.payment_schedule_id = p_ps_id
459: AND b.receivables_trx_id(+) =
460: arp_global.G_CB_REV_RT_ID
461: AND b.customer_trx_id(+) =
462: a.chargeback_customer_trx_id
463: AND b.customer_trx_id is NULL )
464: AND ps.customer_trx_id = ct.customer_trx_id

Line 1315: arp_global.set_of_books_id,

1311: NULL,
1312: NULL,
1313: 'N',
1314: NULL,
1315: arp_global.set_of_books_id,
1316: 222,
1317: l_default_gl_date,
1318: l_defaulting_rule_used,
1319: l_error_message) = TRUE) THEN

Line 1866: WHERE rt.receivables_trx_id = arp_global.G_CB_RT_ID

1862: END IF;
1863: SELECT rt.code_combination_id
1864: INTO l_cb_activity_ccid
1865: FROM ar_receivables_trx rt
1866: WHERE rt.receivables_trx_id = arp_global.G_CB_RT_ID
1867: AND rt.code_combination_id IS NOT NULL;
1868: EXCEPTION
1869: WHEN NO_DATA_FOUND THEN
1870: FND_MESSAGE.set_name('AR', 'AR_RW_NO_GL_ACCT' );

Line 1903: arp_util.Substitute_Ccid(p_coa_id => arp_global.chart_of_accounts_id ,

1899: | that of Receipt's UNAPP record |
1900: +--------------------------------------------------------------------*/
1901: -- Bugfix 1948917.
1902: IF NVL(FND_PROFILE.value('AR_DISABLE_REC_ACTIVITY_BALSEG_SUBSTITUTION'), 'N') = 'N' THEN
1903: arp_util.Substitute_Ccid(p_coa_id => arp_global.chart_of_accounts_id ,
1904: p_original_ccid => l_ctlgd_row.code_combination_id ,
1905: p_subs_ccid => l_cr_unapp_ccid ,
1906: p_actual_ccid => l_actual_ccid );
1907: ELSE

Line 1914: arp_util.Substitute_Ccid(p_coa_id => arp_global.chart_of_accounts_id ,

1910: ELSE
1911: -- Regular chargeback should replace the balancing segment of the invoice REC
1912: -- Bugfix 1948917.
1913: IF NVL(FND_PROFILE.value('AR_DISABLE_REC_ACTIVITY_BALSEG_SUBSTITUTION'), 'N') = 'N' THEN
1914: arp_util.Substitute_Ccid(p_coa_id => arp_global.chart_of_accounts_id ,
1915: p_original_ccid => l_ctlgd_row.code_combination_id ,
1916: p_subs_ccid => l_inv_rec_ccid ,
1917: p_actual_ccid => l_actual_ccid );
1918: ELSE

Line 2108: l_adj_row.receivables_trx_id := arp_global.G_CB_RT_ID;

2104: -- Store the adjusted invoice ID
2105: l_adj_row.code_combination_id := l_actual_ccid;
2106: l_adj_row.customer_trx_id := p_app_customer_trx_id;
2107: l_adj_row.payment_schedule_id := ln_app_payment_schedule_id;
2108: l_adj_row.receivables_trx_id := arp_global.G_CB_RT_ID;
2109: l_adj_row.postable := 'Y';
2110:
2111: -- This type is just temporary 'CB' type in order to get
2112: -- update_adj_related_columns procedure work properly with

Line 2161: WHERE rt.receivables_trx_id = arp_global.G_CB_RT_ID;

2157: -- Set up sequential numbering stuff
2158: SELECT rt.name
2159: INTO l_rec_name
2160: FROM ar_receivables_trx rt
2161: WHERE rt.receivables_trx_id = arp_global.G_CB_RT_ID;
2162:
2163:
2164: -- Bug 686025/694300: instead of calling GET_SEQ_NAME, use
2165: -- proper AOL API GET_NEXT_SEQUENCE to get sequence number.

Line 2171: , arp_global.set_of_books_id

2167: /*
2168: FND_SEQNUM.GET_SEQ_NAME(
2169: arp_standard.application_id
2170: , l_rec_name -- category code
2171: , arp_global.set_of_books_id
2172: , 'A'
2173: , l_adj_row.apply_date
2174: , l_sequence_name
2175: , l_sequence_id

Line 2190: sobid => arp_global.set_of_books_id,

2186: l_adj_row.doc_sequence_value :=
2187: FND_SEQNUM.GET_NEXT_SEQUENCE(
2188: appid => arp_standard.application_id,
2189: cat_code => l_rec_name,
2190: sobid => arp_global.set_of_books_id,
2191: met_code => 'A',
2192: trx_date => l_adj_row.apply_date,
2193: dbseqnm => l_sequence_name,
2194: dbseqid => l_adj_row.doc_sequence_id);