44: IS
45:
46: BEGIN
47:
48: arp_standard.debug('arp_revenue_assignments.build_for_credit()+');
49:
50: IF (p_request_id is not null)
51: THEN
52:
49:
50: IF (p_request_id is not null)
51: THEN
52:
53: arp_standard.debug('arp_revenue_assignments - using request_id');
54:
55: INSERT INTO AR_REVENUE_ASSIGNMENTS_GT
56: (SESSION_ID,
57: CUSTOMER_TRX_LINE_ID,
118:
119: ELSIF (p_customer_trx_line_id is not null)
120: THEN
121:
122: arp_standard.debug('arp_revenue_assignments - using line_id');
123:
124: INSERT INTO AR_REVENUE_ASSIGNMENTS_GT
125: (SESSION_ID,
126: CUSTOMER_TRX_LINE_ID,
184: and decode(rr.type, 'A',rr.rule_id, -1) = rrs.rule_id;
185:
186: ELSE
187:
188: arp_standard.debug('arp_revenue_assignments - using trx_id');
189:
190: INSERT INTO AR_REVENUE_ASSIGNMENTS_GT
191: (SESSION_ID,
192: CUSTOMER_TRX_LINE_ID,
250: and decode(rr.type, 'A',rr.rule_id, -1) = rrs.rule_id;
251:
252: END IF;
253: IF PG_DEBUG in ('Y', 'C') THEN
254: arp_standard.debug('ar_revenue_assignments_gt ***');
255: DECLARE
256: CURSOR c01 IS
257: SELECT
258: SESSION_ID,
272: ORDER BY CUSTOMER_TRX_LINE_ID, RULE_date;
273: i NUMBER := 1;
274: BEGIN
275: FOR c01_rec IN c01 LOOP
276: arp_standard.debug('['|| i || ']: CUSTOMER_TRX_LINE_ID <' ||
277: c01_rec.CUSTOMER_TRX_LINE_ID || '>');
278: arp_standard.debug('> Complete? <' ||
279: c01_rec.COMPLETE_FLAG || '>');
280: arp_standard.debug('> ACCOUNT_CLASS <' ||
274: BEGIN
275: FOR c01_rec IN c01 LOOP
276: arp_standard.debug('['|| i || ']: CUSTOMER_TRX_LINE_ID <' ||
277: c01_rec.CUSTOMER_TRX_LINE_ID || '>');
278: arp_standard.debug('> Complete? <' ||
279: c01_rec.COMPLETE_FLAG || '>');
280: arp_standard.debug('> ACCOUNT_CLASS <' ||
281: c01_rec.ACCOUNT_CLASS || '> ' );
282: arp_standard.debug('> LUMP_SUM_FLAG <' ||
276: arp_standard.debug('['|| i || ']: CUSTOMER_TRX_LINE_ID <' ||
277: c01_rec.CUSTOMER_TRX_LINE_ID || '>');
278: arp_standard.debug('> Complete? <' ||
279: c01_rec.COMPLETE_FLAG || '>');
280: arp_standard.debug('> ACCOUNT_CLASS <' ||
281: c01_rec.ACCOUNT_CLASS || '> ' );
282: arp_standard.debug('> LUMP_SUM_FLAG <' ||
283: c01_rec.LUMP_SUM_FLAG || '> ' );
284: arp_standard.debug('> RULE_TYPE <' ||
278: arp_standard.debug('> Complete? <' ||
279: c01_rec.COMPLETE_FLAG || '>');
280: arp_standard.debug('> ACCOUNT_CLASS <' ||
281: c01_rec.ACCOUNT_CLASS || '> ' );
282: arp_standard.debug('> LUMP_SUM_FLAG <' ||
283: c01_rec.LUMP_SUM_FLAG || '> ' );
284: arp_standard.debug('> RULE_TYPE <' ||
285: c01_rec.RULE_TYPE || '> ' );
286: arp_standard.debug('> PERIOD_NUMBER <' ||
280: arp_standard.debug('> ACCOUNT_CLASS <' ||
281: c01_rec.ACCOUNT_CLASS || '> ' );
282: arp_standard.debug('> LUMP_SUM_FLAG <' ||
283: c01_rec.LUMP_SUM_FLAG || '> ' );
284: arp_standard.debug('> RULE_TYPE <' ||
285: c01_rec.RULE_TYPE || '> ' );
286: arp_standard.debug('> PERIOD_NUMBER <' ||
287: c01_rec.PERIOD_NUMBER || '> ' );
288: arp_standard.debug('> PERCENT <' ||
282: arp_standard.debug('> LUMP_SUM_FLAG <' ||
283: c01_rec.LUMP_SUM_FLAG || '> ' );
284: arp_standard.debug('> RULE_TYPE <' ||
285: c01_rec.RULE_TYPE || '> ' );
286: arp_standard.debug('> PERIOD_NUMBER <' ||
287: c01_rec.PERIOD_NUMBER || '> ' );
288: arp_standard.debug('> PERCENT <' ||
289: c01_rec.PERCENT || '> ' );
290: arp_standard.debug('> RULE_DATE <' ||
284: arp_standard.debug('> RULE_TYPE <' ||
285: c01_rec.RULE_TYPE || '> ' );
286: arp_standard.debug('> PERIOD_NUMBER <' ||
287: c01_rec.PERIOD_NUMBER || '> ' );
288: arp_standard.debug('> PERCENT <' ||
289: c01_rec.PERCENT || '> ' );
290: arp_standard.debug('> RULE_DATE <' ||
291: c01_rec.RULE_DATE || '> ' );
292: arp_standard.debug('> SET_OF_BOOKS_ID <' ||
286: arp_standard.debug('> PERIOD_NUMBER <' ||
287: c01_rec.PERIOD_NUMBER || '> ' );
288: arp_standard.debug('> PERCENT <' ||
289: c01_rec.PERCENT || '> ' );
290: arp_standard.debug('> RULE_DATE <' ||
291: c01_rec.RULE_DATE || '> ' );
292: arp_standard.debug('> SET_OF_BOOKS_ID <' ||
293: c01_rec.SET_OF_BOOKS_ID || '> ' );
294: arp_standard.debug('> PERIOD_TYPE <' ||
288: arp_standard.debug('> PERCENT <' ||
289: c01_rec.PERCENT || '> ' );
290: arp_standard.debug('> RULE_DATE <' ||
291: c01_rec.RULE_DATE || '> ' );
292: arp_standard.debug('> SET_OF_BOOKS_ID <' ||
293: c01_rec.SET_OF_BOOKS_ID || '> ' );
294: arp_standard.debug('> PERIOD_TYPE <' ||
295: c01_rec.PERIOD_TYPE || '> ' );
296: arp_standard.debug('> MAX_REGULAR_PERIOD_LENGTH <' ||
290: arp_standard.debug('> RULE_DATE <' ||
291: c01_rec.RULE_DATE || '> ' );
292: arp_standard.debug('> SET_OF_BOOKS_ID <' ||
293: c01_rec.SET_OF_BOOKS_ID || '> ' );
294: arp_standard.debug('> PERIOD_TYPE <' ||
295: c01_rec.PERIOD_TYPE || '> ' );
296: arp_standard.debug('> MAX_REGULAR_PERIOD_LENGTH <' ||
297: c01_rec.MAX_REGULAR_PERIOD_LENGTH || '> ' );
298: i := i + 1;
292: arp_standard.debug('> SET_OF_BOOKS_ID <' ||
293: c01_rec.SET_OF_BOOKS_ID || '> ' );
294: arp_standard.debug('> PERIOD_TYPE <' ||
295: c01_rec.PERIOD_TYPE || '> ' );
296: arp_standard.debug('> MAX_REGULAR_PERIOD_LENGTH <' ||
297: c01_rec.MAX_REGULAR_PERIOD_LENGTH || '> ' );
298: i := i + 1;
299: END LOOP;
300: END;
298: i := i + 1;
299: END LOOP;
300: END;
301: END IF;
302: arp_standard.debug('arp_revenue_assignments.build_for_credit()-');
303:
304:
305: END;
306: