53:
54: BEGIN
55: IF PG_DEBUG IN ('Y','C')
56: THEN
57: arp_standard.debug('arp_revenue_assignments.build_for_credit()+');
58: arp_standard.debug(' p_session_id = ' || p_session_id);
59: arp_standard.debug(' p_period_set_name = ' || p_period_set_name);
60: arp_standard.debug(' p_use_inv_acctg = ' || p_use_inv_acctg);
61: arp_standard.debug(' p_request_id = ' || p_request_id);
54: BEGIN
55: IF PG_DEBUG IN ('Y','C')
56: THEN
57: arp_standard.debug('arp_revenue_assignments.build_for_credit()+');
58: arp_standard.debug(' p_session_id = ' || p_session_id);
59: arp_standard.debug(' p_period_set_name = ' || p_period_set_name);
60: arp_standard.debug(' p_use_inv_acctg = ' || p_use_inv_acctg);
61: arp_standard.debug(' p_request_id = ' || p_request_id);
62: arp_standard.debug(' p_customer_trx_id = ' || p_customer_trx_id);
55: IF PG_DEBUG IN ('Y','C')
56: THEN
57: arp_standard.debug('arp_revenue_assignments.build_for_credit()+');
58: arp_standard.debug(' p_session_id = ' || p_session_id);
59: arp_standard.debug(' p_period_set_name = ' || p_period_set_name);
60: arp_standard.debug(' p_use_inv_acctg = ' || p_use_inv_acctg);
61: arp_standard.debug(' p_request_id = ' || p_request_id);
62: arp_standard.debug(' p_customer_trx_id = ' || p_customer_trx_id);
63: arp_standard.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
56: THEN
57: arp_standard.debug('arp_revenue_assignments.build_for_credit()+');
58: arp_standard.debug(' p_session_id = ' || p_session_id);
59: arp_standard.debug(' p_period_set_name = ' || p_period_set_name);
60: arp_standard.debug(' p_use_inv_acctg = ' || p_use_inv_acctg);
61: arp_standard.debug(' p_request_id = ' || p_request_id);
62: arp_standard.debug(' p_customer_trx_id = ' || p_customer_trx_id);
63: arp_standard.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
64: END IF;
57: arp_standard.debug('arp_revenue_assignments.build_for_credit()+');
58: arp_standard.debug(' p_session_id = ' || p_session_id);
59: arp_standard.debug(' p_period_set_name = ' || p_period_set_name);
60: arp_standard.debug(' p_use_inv_acctg = ' || p_use_inv_acctg);
61: arp_standard.debug(' p_request_id = ' || p_request_id);
62: arp_standard.debug(' p_customer_trx_id = ' || p_customer_trx_id);
63: arp_standard.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
64: END IF;
65:
58: arp_standard.debug(' p_session_id = ' || p_session_id);
59: arp_standard.debug(' p_period_set_name = ' || p_period_set_name);
60: arp_standard.debug(' p_use_inv_acctg = ' || p_use_inv_acctg);
61: arp_standard.debug(' p_request_id = ' || p_request_id);
62: arp_standard.debug(' p_customer_trx_id = ' || p_customer_trx_id);
63: arp_standard.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
64: END IF;
65:
66: IF (p_request_id is not null)
59: arp_standard.debug(' p_period_set_name = ' || p_period_set_name);
60: arp_standard.debug(' p_use_inv_acctg = ' || p_use_inv_acctg);
61: arp_standard.debug(' p_request_id = ' || p_request_id);
62: arp_standard.debug(' p_customer_trx_id = ' || p_customer_trx_id);
63: arp_standard.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
64: END IF;
65:
66: IF (p_request_id is not null)
67: THEN
66: IF (p_request_id is not null)
67: THEN
68: IF PG_DEBUG IN ('Y','C')
69: THEN
70: arp_standard.debug('arp_revenue_assignments - using request_id');
71: END IF;
72:
73: INSERT INTO AR_REVENUE_ASSIGNMENTS_GT
74: (SESSION_ID,
136: ELSIF (p_customer_trx_line_id is not null)
137: THEN
138: IF PG_DEBUG IN ('Y','C')
139: THEN
140: arp_standard.debug('arp_revenue_assignments - using line_id');
141: END IF;
142:
143: INSERT INTO AR_REVENUE_ASSIGNMENTS_GT
144: (SESSION_ID,
203:
204: ELSE
205: IF PG_DEBUG IN ('Y','C')
206: THEN
207: arp_standard.debug('arp_revenue_assignments - using trx_id');
208: END IF;
209:
210: INSERT INTO AR_REVENUE_ASSIGNMENTS_GT
211: (SESSION_ID,
300: AND ragt.session_id = p_session_id;
301:
302: IF PG_DEBUG IN ('Y','C')
303: THEN
304: arp_standard.debug(' row(s) updated for pprr = ' || SQL%ROWCOUNT);
305: END IF;
306: END IF;
307:
308: IF PG_DEBUG in ('Y', 'C') THEN
305: END IF;
306: END IF;
307:
308: IF PG_DEBUG in ('Y', 'C') THEN
309: arp_standard.debug('DUMP of ar_revenue_assignments_gt ');
310: DECLARE
311: CURSOR c01 IS
312: SELECT
313: SESSION_ID,
328: ORDER BY CUSTOMER_TRX_LINE_ID, PERIOD_NUMBER;
329: i NUMBER := 1;
330: BEGIN
331: FOR c01_rec IN c01 LOOP
332: arp_standard.debug('['|| i || ']:' ||
333: c01_rec.CUSTOMER_TRX_LINE_ID || '~' ||
334: c01_rec.COMPLETE_FLAG || '~' ||
335: c01_rec.ACCOUNT_CLASS || '~' ||
336: c01_rec.LUMP_SUM_FLAG || '~' ||
345: i := i + 1;
346: END LOOP;
347: END;
348:
349: arp_standard.debug('arp_revenue_assignments.build_for_credit()-');
350:
351: END IF;
352:
353: END;