10: | |
11: | SCOPE - PUBLIC |
12: | |
13: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
14: | arp_util.debug |
15: | |
16: | ARGUMENTS : IN: |
17: | p_customer_trx_id |
18: | OUT: |
37:
38: BEGIN
39:
40: IF PG_DEBUG in ('Y', 'C') THEN
41: arp_util.debug('arp_trx_tax_util.get_default_line_num()+');
42: END IF;
43:
44: SELECT nvl( max(line_number), 0 ) + 1
45: INTO p_line_number
48: AND link_to_cust_trx_line_id = p_customer_trx_line_id
49: AND line_type = 'TAX';
50:
51: IF PG_DEBUG in ('Y', 'C') THEN
52: arp_util.debug('arp_trx_tax_util.get_default_line_num()-');
53: END IF;
54:
55: EXCEPTION
56: WHEN OTHERS THEN
54:
55: EXCEPTION
56: WHEN OTHERS THEN
57: IF PG_DEBUG in ('Y', 'C') THEN
58: arp_util.debug('EXCEPTION: arp_trx_tax_util.get_default_line_num()');
59: arp_util.debug('get_default_line_num: ' ||
60: '---------- ' ||
61: 'Parameters for arp_trx_tax_util.get_default_line_num() ' ||
62: '---------- ');
55: EXCEPTION
56: WHEN OTHERS THEN
57: IF PG_DEBUG in ('Y', 'C') THEN
58: arp_util.debug('EXCEPTION: arp_trx_tax_util.get_default_line_num()');
59: arp_util.debug('get_default_line_num: ' ||
60: '---------- ' ||
61: 'Parameters for arp_trx_tax_util.get_default_line_num() ' ||
62: '---------- ');
63: arp_util.debug('get_default_line_num: ' || 'p_customer_trx_id = ' || p_customer_trx_id);
59: arp_util.debug('get_default_line_num: ' ||
60: '---------- ' ||
61: 'Parameters for arp_trx_tax_util.get_default_line_num() ' ||
62: '---------- ');
63: arp_util.debug('get_default_line_num: ' || 'p_customer_trx_id = ' || p_customer_trx_id);
64: END IF;
65:
66: RAISE;
67:
76: | |
77: | SCOPE - PUBLIC |
78: | |
79: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
80: | arp_util.debug |
81: | |
82: | ARGUMENTS : IN: |
83: | p_inventory_item_id |
84: | p_organization_id |
129:
130: BEGIN
131:
132: IF PG_DEBUG in ('Y', 'C') THEN
133: arp_util.debug('arp_trx_tax_util.get_item_flex_defaults()+');
134: END IF;
135:
136: SELECT msi.description,
137: DECODE( SIGN( p_trx_date - TRUNC( NVL(muom.disable_date,
197: rr.occurrences,
198: rr.frequency;
199:
200: IF PG_DEBUG in ('Y', 'C') THEN
201: arp_util.debug('arp_trx_tax_util.get_item_flex_defaults()-');
202: END IF;
203:
204: EXCEPTION
205: WHEN OTHERS THEN
203:
204: EXCEPTION
205: WHEN OTHERS THEN
206: IF PG_DEBUG in ('Y', 'C') THEN
207: arp_util.debug('EXCEPTION: arp_trx_tax_util.get_item_flex_defaults()');
208: arp_util.debug('get_item_flex_defaults: ' ||
209: '---------- ' ||
210: 'Parameters for arp_trx_tax_util.get_item_flex_defaults() ' ||
211: '---------- ');
204: EXCEPTION
205: WHEN OTHERS THEN
206: IF PG_DEBUG in ('Y', 'C') THEN
207: arp_util.debug('EXCEPTION: arp_trx_tax_util.get_item_flex_defaults()');
208: arp_util.debug('get_item_flex_defaults: ' ||
209: '---------- ' ||
210: 'Parameters for arp_trx_tax_util.get_item_flex_defaults() ' ||
211: '---------- ');
212: arp_util.debug('get_item_flex_defaults: ' || 'p_inventory_item_id = ' || p_inventory_item_id);
208: arp_util.debug('get_item_flex_defaults: ' ||
209: '---------- ' ||
210: 'Parameters for arp_trx_tax_util.get_item_flex_defaults() ' ||
211: '---------- ');
212: arp_util.debug('get_item_flex_defaults: ' || 'p_inventory_item_id = ' || p_inventory_item_id);
213: arp_util.debug('get_item_flex_defaults: ' || 'p_organization_id = ' || p_organization_id );
214: arp_util.debug('get_item_flex_defaults: ' || 'p_trx_date = ' || p_trx_date );
215: arp_util.debug('get_item_flex_defaults: ' || 'p_invoicing_rule_id = ' || p_invoicing_rule_id );
216: END IF;
209: '---------- ' ||
210: 'Parameters for arp_trx_tax_util.get_item_flex_defaults() ' ||
211: '---------- ');
212: arp_util.debug('get_item_flex_defaults: ' || 'p_inventory_item_id = ' || p_inventory_item_id);
213: arp_util.debug('get_item_flex_defaults: ' || 'p_organization_id = ' || p_organization_id );
214: arp_util.debug('get_item_flex_defaults: ' || 'p_trx_date = ' || p_trx_date );
215: arp_util.debug('get_item_flex_defaults: ' || 'p_invoicing_rule_id = ' || p_invoicing_rule_id );
216: END IF;
217:
210: 'Parameters for arp_trx_tax_util.get_item_flex_defaults() ' ||
211: '---------- ');
212: arp_util.debug('get_item_flex_defaults: ' || 'p_inventory_item_id = ' || p_inventory_item_id);
213: arp_util.debug('get_item_flex_defaults: ' || 'p_organization_id = ' || p_organization_id );
214: arp_util.debug('get_item_flex_defaults: ' || 'p_trx_date = ' || p_trx_date );
215: arp_util.debug('get_item_flex_defaults: ' || 'p_invoicing_rule_id = ' || p_invoicing_rule_id );
216: END IF;
217:
218: RAISE;
211: '---------- ');
212: arp_util.debug('get_item_flex_defaults: ' || 'p_inventory_item_id = ' || p_inventory_item_id);
213: arp_util.debug('get_item_flex_defaults: ' || 'p_organization_id = ' || p_organization_id );
214: arp_util.debug('get_item_flex_defaults: ' || 'p_trx_date = ' || p_trx_date );
215: arp_util.debug('get_item_flex_defaults: ' || 'p_invoicing_rule_id = ' || p_invoicing_rule_id );
216: END IF;
217:
218: RAISE;
219:
228: | |
229: | SCOPE - PUBLIC |
230: | |
231: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
232: | arp_util.debug |
233: | |
234: | ARGUMENTS : IN: |
235: | p_customer_trx_id |
236: | OUT: |
256:
257: BEGIN
258:
259: IF PG_DEBUG in ('Y', 'C') THEN
260: arp_util.debug('arp_trx_tax_util.select_summary()+');
261: END IF;
262:
263: SELECT nvl(sum(extended_amount),0), nvl(sum(extended_amount),0)
264: INTO p_total, p_total_rtot_db
271: -10 )
272: AND line_type = 'TAX';
273:
274: IF PG_DEBUG in ('Y', 'C') THEN
275: arp_util.debug('arp_trx_tax_util.select_summary()-');
276: END IF;
277:
278: EXCEPTION
279: WHEN OTHERS THEN
277:
278: EXCEPTION
279: WHEN OTHERS THEN
280: IF PG_DEBUG in ('Y', 'C') THEN
281: arp_util.debug('EXCEPTION: arp_trx_tax_util.select_summary()');
282: arp_util.debug('select_summary: ' || 'p_customer_trx_id = ' || p_customer_trx_id);
283: END IF;
284: RAISE;
285: END select_summary;
278: EXCEPTION
279: WHEN OTHERS THEN
280: IF PG_DEBUG in ('Y', 'C') THEN
281: arp_util.debug('EXCEPTION: arp_trx_tax_util.select_summary()');
282: arp_util.debug('select_summary: ' || 'p_customer_trx_id = ' || p_customer_trx_id);
283: END IF;
284: RAISE;
285: END select_summary;
286: /*===========================================================================+
292: | |
293: | SCOPE - PUBLIC |
294: | |
295: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
296: | arp_util.debug |
297: | |
298: | ARGUMENTS : IN: |
299: | p_customer_trx_line_id |
300: | OUT: |
314: IS
315: l_only_tax_line_flag varchar2(2);
316: BEGIN
317:
318: arp_util.debug('arp_trx_tax_util.check_last_line_on_delete()+');
319: SELECT decode(max(dummy),
320: '', 'N',
321: 'Y')
322: INTO l_only_tax_line_flag
333: THEN p_only_tax_line_flag := TRUE;
334: ELSE p_only_tax_line_flag := FALSE;
335: END IF;
336:
337: arp_util.debug('arp_trx_tax_util.check_last_line_on_delete()-');
338:
339: EXCEPTION
340: WHEN OTHERS THEN
341: arp_util.debug('EXCEPTION: arp_trx_tax_util.check_last_line_on_delete()');
337: arp_util.debug('arp_trx_tax_util.check_last_line_on_delete()-');
338:
339: EXCEPTION
340: WHEN OTHERS THEN
341: arp_util.debug('EXCEPTION: arp_trx_tax_util.check_last_line_on_delete()');
342: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
343: RAISE;
344:
345: END;
338:
339: EXCEPTION
340: WHEN OTHERS THEN
341: arp_util.debug('EXCEPTION: arp_trx_tax_util.check_last_line_on_delete()');
342: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
343: RAISE;
344:
345: END;
346: /*===========================================================================+
351: | Returns whether the new tax line number is unique for the invoice line |
352: | SCOPE - PUBLIC |
353: | |
354: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
355: | arp_util.debug |
356: | |
357: | ARGUMENTS : IN: |
358: | p_customer_trx_line_id |
359: | p_customer_trx_tax_line_num |
377: IS
378: l_unique_line_flag varchar2(2);
379: BEGIN
380:
381: arp_util.debug('arp_trx_tax_util.check_unique_line()+');
382: SELECT decode(max(dummy),
383: '', 'N',
384: 'Y')
385: INTO l_unique_line_flag
398: ELSE
399: p_unique_line_flag := TRUE;
400: END IF;
401:
402: arp_util.debug('arp_trx_tax_util.check_unique_line()-');
403:
404: EXCEPTION
405: WHEN OTHERS THEN
406: arp_util.debug('EXCEPTION: arp_trx_tax_util.check_unique_line()');
402: arp_util.debug('arp_trx_tax_util.check_unique_line()-');
403:
404: EXCEPTION
405: WHEN OTHERS THEN
406: arp_util.debug('EXCEPTION: arp_trx_tax_util.check_unique_line()');
407: arp_util.debug(
408: '---------- ' ||
409: 'Parameters for arp_trx_tax_util.check_unique_line() ' ||
410: '---------- ');
403:
404: EXCEPTION
405: WHEN OTHERS THEN
406: arp_util.debug('EXCEPTION: arp_trx_tax_util.check_unique_line()');
407: arp_util.debug(
408: '---------- ' ||
409: 'Parameters for arp_trx_tax_util.check_unique_line() ' ||
410: '---------- ');
411: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
407: arp_util.debug(
408: '---------- ' ||
409: 'Parameters for arp_trx_tax_util.check_unique_line() ' ||
410: '---------- ');
411: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
412: arp_util.debug('p_customer_trx_line_number = ' || p_customer_trx_line_num);
413:
414: RAISE;
415: END;
408: '---------- ' ||
409: 'Parameters for arp_trx_tax_util.check_unique_line() ' ||
410: '---------- ');
411: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
412: arp_util.debug('p_customer_trx_line_number = ' || p_customer_trx_line_num);
413:
414: RAISE;
415: END;
416: /*===========================================================================+
422: | |
423: | SCOPE - PUBLIC |
424: | |
425: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
426: | arp_util.debug |
427: | |
428: | ARGUMENTS : IN: |
429: | p_customer_trx_line_id |
430: | OUT: |
442:
443: RETURN NUMBER IS
444: l_balance_due number;
445: Begin
446: arp_util.debug('arp_trx_tax_util.tax_balance()+');
447:
448: /* Calculate Balance Due By Checking Any other Credit Memos
449: Which Are Complete */
450:
458: AND ct.complete_flag = 'Y';
459:
460: return(l_balance_due);
461:
462: arp_util.debug('arp_trx_tax_util.tax_balance()-');
463:
464: EXCEPTION
465: WHEN OTHERS THEN
466: arp_util.debug('EXCEPTION: arp_trx_tax_util.tax_balance');
462: arp_util.debug('arp_trx_tax_util.tax_balance()-');
463:
464: EXCEPTION
465: WHEN OTHERS THEN
466: arp_util.debug('EXCEPTION: arp_trx_tax_util.tax_balance');
467: RAISE;
468: End;
469:
470: /*===========================================================================+
475: | Returns whether the tax code is adhoc or not. |
476: | SCOPE - PUBLIC |
477: | |
478: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
479: | arp_util.debug |
480: | |
481: | ARGUMENTS : IN: |
482: | p_tax_code |
483: | OUT: |
498: IS
499: l_adhoc_tax_flag varchar2(2);
500: BEGIN
501:
502: arp_util.debug('arp_trx_tax_util.check_tax_code()+');
503: SELECT validate_flag
504: INTO l_adhoc_tax_flag
505: FROM ar_vat_tax
506: WHERE tax_code = p_tax_code;
511: ELSE
512: p_adhoc_tax_flag := FALSE;
513: END IF;
514:
515: arp_util.debug('arp_trx_tax_util.check_tax_code()-');
516:
517: EXCEPTION
518: WHEN OTHERS THEN
519: arp_util.debug('EXCEPTION: arp_trx_tax_util.check_tax_code()');
515: arp_util.debug('arp_trx_tax_util.check_tax_code()-');
516:
517: EXCEPTION
518: WHEN OTHERS THEN
519: arp_util.debug('EXCEPTION: arp_trx_tax_util.check_tax_code()');
520: arp_util.debug(
521: '---------- ' ||
522: 'Parameters for arp_trx_tax_util.check_tax_code() ' ||
523: '---------- ');
516:
517: EXCEPTION
518: WHEN OTHERS THEN
519: arp_util.debug('EXCEPTION: arp_trx_tax_util.check_tax_code()');
520: arp_util.debug(
521: '---------- ' ||
522: 'Parameters for arp_trx_tax_util.check_tax_code() ' ||
523: '---------- ');
524: arp_util.debug('p_tax_code = ' || p_tax_code);
520: arp_util.debug(
521: '---------- ' ||
522: 'Parameters for arp_trx_tax_util.check_tax_code() ' ||
523: '---------- ');
524: arp_util.debug('p_tax_code = ' || p_tax_code);
525:
526: RAISE;
527: END;
528: END ARP_TRX_TAX_UTIL;