DBA Data[Home] [Help]

APPS.AR_REVENUE_ADJUSTMENT_PVT dependencies on ARP_STANDARD

Line 2780: arp_standard.sysparm.set_of_books_id, /* set_of_books_id */

2776: SELECT /*+ ORDERED push_pred(ra.lgd) index(dist ra_cust_trx_line_gl_dist_n1)*/
2777: ra.customer_trx_line_id, /* customer_trx_line_id */
2778: l.customer_trx_id, /* customer_trx_id */
2779: dist.code_combination_id, /* code_combination_id */
2780: arp_standard.sysparm.set_of_books_id, /* set_of_books_id */
2781: ra.account_class, /* account_class */
2782: 'N', /* account_set_flag */
2783: ROUND((((ra.amount * dist.percent
2784: * p_revenue_amount)

Line 2812: arp_standard.profile.request_id,

2808: * g_bmau)), /* Acctd_amount */
2809: DECODE(l.accounting_rule_duration, 1, p_gl_date,
2810: arp_auto_rule.assign_gl_date(ra.gl_date)),/* Derived gl_date */
2811: dist.cust_trx_line_salesrep_id, /* Srep ID */
2812: arp_standard.profile.request_id,
2813: arp_standard.application_id,
2814: arp_standard.profile.program_id,
2815: sysdate,
2816: sysdate,

Line 2813: arp_standard.application_id,

2809: DECODE(l.accounting_rule_duration, 1, p_gl_date,
2810: arp_auto_rule.assign_gl_date(ra.gl_date)),/* Derived gl_date */
2811: dist.cust_trx_line_salesrep_id, /* Srep ID */
2812: arp_standard.profile.request_id,
2813: arp_standard.application_id,
2814: arp_standard.profile.program_id,
2815: sysdate,
2816: sysdate,
2817: arp_standard.profile.user_id,

Line 2814: arp_standard.profile.program_id,

2810: arp_auto_rule.assign_gl_date(ra.gl_date)),/* Derived gl_date */
2811: dist.cust_trx_line_salesrep_id, /* Srep ID */
2812: arp_standard.profile.request_id,
2813: arp_standard.application_id,
2814: arp_standard.profile.program_id,
2815: sysdate,
2816: sysdate,
2817: arp_standard.profile.user_id,
2818: sysdate,

Line 2817: arp_standard.profile.user_id,

2813: arp_standard.application_id,
2814: arp_standard.profile.program_id,
2815: sysdate,
2816: sysdate,
2817: arp_standard.profile.user_id,
2818: sysdate,
2819: arp_standard.profile.user_id,
2820: -3,
2821: ra.gl_date, /* original_gl_date */

Line 2819: arp_standard.profile.user_id,

2815: sysdate,
2816: sysdate,
2817: arp_standard.profile.user_id,
2818: sysdate,
2819: arp_standard.profile.user_id,
2820: -3,
2821: ra.gl_date, /* original_gl_date */
2822: ra_cust_trx_line_gl_dist_s.NEXTVAL, /* cust_trx_line_gl_dist_id */
2823: p_adjustment_id,

Line 2825: arp_standard.sysparm.org_id

2821: ra.gl_date, /* original_gl_date */
2822: ra_cust_trx_line_gl_dist_s.NEXTVAL, /* cust_trx_line_gl_dist_id */
2823: p_adjustment_id,
2824: p_user_generated_flag,
2825: arp_standard.sysparm.org_id
2826: FROM
2827: ra_customer_trx_lines l,
2828: ra_customer_trx h,
2829: fnd_currencies fc,

Line 2848: arp_standard.debug('Total lines inserted: ' || rows);

2844: rows := sql%rowcount;
2845:
2846:
2847: IF PG_DEBUG in ('Y', 'C') THEN
2848: arp_standard.debug('Total lines inserted: ' || rows);
2849: END IF;
2850:
2851: /* Note: rounding will be handled at the transaction level
2852: in a call to arp_rounding.correct_rev_adj_by_line */

Line 4700: ,arp_standard.sysparm.org_id ); -- Bug 4607673

4696: ,SYSDATE
4697: ,FND_GLOBAL.user_id
4698: ,SYSDATE
4699: ,FND_GLOBAL.user_id
4700: ,arp_standard.sysparm.org_id ); -- Bug 4607673
4701: IF PG_DEBUG in ('Y', 'C') THEN
4702: arp_util.debug('AR_Revenue_Adjustment_PVT.create_adjustment()-');
4703: END IF;
4704:

Line 5034: ,arp_standard.sysparm.org_id

5030: ,p_acctd_amount
5031: ,-3
5032: ,p_adjustment_id
5033: ,p_user_generated_flag
5034: ,arp_standard.sysparm.org_id
5035: ,p_rounding_flag); -- Bug 4607673
5036:
5037: --{BUG#5064609 call XLA event
5038: OPEN cu_trx;

Line 5186: ,arp_standard.sysparm.org_id);

5182: ,DECODE(p_type,'N',p_amount,NULL)
5183: ,DECODE(p_type,'R',p_percent,NULL)
5184: ,DECODE(p_type,'N',p_percent,NULL)
5185: ,p_adjustment_id
5186: ,arp_standard.sysparm.org_id);
5187:
5188: IF PG_DEBUG in ('Y', 'C') THEN
5189: arp_util.debug(' Inserted salescredit row w/ ID = ' ||
5190: p_sales_credit_id);

Line 5304: arp_standard.sysparm.set_of_books_id,

5300: VALUES
5301: ( p_cust_trx_line_id,
5302: p_customer_trx_id,
5303: l_ccid,
5304: arp_standard.sysparm.set_of_books_id,
5305: l_account_class,
5306: 'Y',
5307: p_percent,
5308: NULL,

Line 5312: arp_standard.profile.request_id,

5308: NULL,
5309: NULL,
5310: NULL,
5311: p_sales_credit_id,
5312: arp_standard.profile.request_id,
5313: arp_standard.application_id,
5314: arp_standard.profile.program_id,
5315: sysdate,
5316: sysdate,

Line 5313: arp_standard.application_id,

5309: NULL,
5310: NULL,
5311: p_sales_credit_id,
5312: arp_standard.profile.request_id,
5313: arp_standard.application_id,
5314: arp_standard.profile.program_id,
5315: sysdate,
5316: sysdate,
5317: l_user_id,

Line 5314: arp_standard.profile.program_id,

5310: NULL,
5311: p_sales_credit_id,
5312: arp_standard.profile.request_id,
5313: arp_standard.application_id,
5314: arp_standard.profile.program_id,
5315: sysdate,
5316: sysdate,
5317: l_user_id,
5318: sysdate,

Line 5325: arp_standard.sysparm.org_id

5321: NULL,
5322: l_gl_dist_id,
5323: p_adjustment_id,
5324: 'Y',
5325: arp_standard.sysparm.org_id
5326: );
5327:
5328: IF PG_DEBUG in ('Y', 'C') THEN
5329: arp_util.debug(' Inserted ' || l_account_class ||