DBA Data[Home] [Help]

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 1301: arp_global.set_of_books_id,

1297: NULL,
1298: NULL,
1299: 'N',
1300: NULL,
1301: arp_global.set_of_books_id,
1302: 222,
1303: l_default_gl_date,
1304: l_defaulting_rule_used,
1305: l_error_message) = TRUE) THEN

Line 1739: WHERE rt.receivables_trx_id = arp_global.G_CB_RT_ID

1735: END IF;
1736: SELECT rt.code_combination_id
1737: INTO l_cb_activity_ccid
1738: FROM ar_receivables_trx rt
1739: WHERE rt.receivables_trx_id = arp_global.G_CB_RT_ID
1740: AND rt.code_combination_id IS NOT NULL;
1741: EXCEPTION
1742: WHEN NO_DATA_FOUND THEN
1743: FND_MESSAGE.set_name('AR', 'AR_RW_NO_GL_ACCT' );

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

1772: | that of Receipt's UNAPP record |
1773: +--------------------------------------------------------------------*/
1774: -- Bugfix 1948917.
1775: IF NVL(FND_PROFILE.value('AR_DISABLE_REC_ACTIVITY_BALSEG_SUBSTITUTION'), 'N') = 'N' THEN
1776: arp_util.Substitute_Ccid(p_coa_id => arp_global.chart_of_accounts_id ,
1777: p_original_ccid => l_ctlgd_row.code_combination_id ,
1778: p_subs_ccid => l_cr_unapp_ccid ,
1779: p_actual_ccid => l_actual_ccid );
1780: ELSE

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

1783: ELSE
1784: -- Regular chargeback should replace the balancing segment of the invoice REC
1785: -- Bugfix 1948917.
1786: IF NVL(FND_PROFILE.value('AR_DISABLE_REC_ACTIVITY_BALSEG_SUBSTITUTION'), 'N') = 'N' THEN
1787: arp_util.Substitute_Ccid(p_coa_id => arp_global.chart_of_accounts_id ,
1788: p_original_ccid => l_ctlgd_row.code_combination_id ,
1789: p_subs_ccid => l_inv_rec_ccid ,
1790: p_actual_ccid => l_actual_ccid );
1791: ELSE

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

1977: -- Store the adjusted invoice ID
1978: l_adj_row.code_combination_id := l_actual_ccid;
1979: l_adj_row.customer_trx_id := p_app_customer_trx_id;
1980: l_adj_row.payment_schedule_id := ln_app_payment_schedule_id;
1981: l_adj_row.receivables_trx_id := arp_global.G_CB_RT_ID;
1982: l_adj_row.postable := 'Y';
1983:
1984: -- This type is just temporary 'CB' type in order to get
1985: -- update_adj_related_columns procedure work properly with

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

2030: -- Set up sequential numbering stuff
2031: SELECT rt.name
2032: INTO l_rec_name
2033: FROM ar_receivables_trx rt
2034: WHERE rt.receivables_trx_id = arp_global.G_CB_RT_ID;
2035:
2036:
2037: -- Bug 686025/694300: instead of calling GET_SEQ_NAME, use
2038: -- proper AOL API GET_NEXT_SEQUENCE to get sequence number.

Line 2044: , arp_global.set_of_books_id

2040: /*
2041: FND_SEQNUM.GET_SEQ_NAME(
2042: arp_standard.application_id
2043: , l_rec_name -- category code
2044: , arp_global.set_of_books_id
2045: , 'A'
2046: , l_adj_row.apply_date
2047: , l_sequence_name
2048: , l_sequence_id

Line 2063: sobid => arp_global.set_of_books_id,

2059: l_adj_row.doc_sequence_value :=
2060: FND_SEQNUM.GET_NEXT_SEQUENCE(
2061: appid => arp_standard.application_id,
2062: cat_code => l_rec_name,
2063: sobid => arp_global.set_of_books_id,
2064: met_code => 'A',
2065: trx_date => l_adj_row.apply_date,
2066: dbseqnm => l_sequence_name,
2067: dbseqid => l_adj_row.doc_sequence_id);