1: package body arp_tax_view_taxware as
2: /* $Header: zxtxvwab.pls 120.8 2006/10/06 11:41:08 vchallur ship $ */
3:
4: USE_SHIP_TO_GEO CONSTANT VARCHAR2(10) := 'XXXXXXXXX';
5:
37: p_memo_line_id IN NUMBER)
38: RETURN VARCHAR2 IS
39: BEGIN
40: IF (g_level_procedure >= g_current_runtime_level ) THEN
41: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.PRODUCT_CODE',
42: 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.PRODUCT_CODE(+)');
43: END IF;
44:
45: RETURN to_char(NULL);
38: RETURN VARCHAR2 IS
39: BEGIN
40: IF (g_level_procedure >= g_current_runtime_level ) THEN
41: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.PRODUCT_CODE',
42: 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.PRODUCT_CODE(+)');
43: END IF;
44:
45: RETURN to_char(NULL);
46:
44:
45: RETURN to_char(NULL);
46:
47: IF (g_level_procedure >= g_current_runtime_level ) THEN
48: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.PRODUCT_CODE',
49: 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.PRODUCT_CODE(-)');
50: END IF;
51:
52: END PRODUCT_CODE;
45: RETURN to_char(NULL);
46:
47: IF (g_level_procedure >= g_current_runtime_level ) THEN
48: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.PRODUCT_CODE',
49: 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.PRODUCT_CODE(-)');
50: END IF;
51:
52: END PRODUCT_CODE;
53:
473: return Varchar2 is
474: l_audit_flag Varchar2(10);
475: begin
476: IF (g_level_procedure >= g_current_runtime_level ) THEN
477: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG',
478: 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG(+)');
479: END IF;
480: IF (g_level_procedure >= g_current_runtime_level ) THEN
481: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG',
474: l_audit_flag Varchar2(10);
475: begin
476: IF (g_level_procedure >= g_current_runtime_level ) THEN
477: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG',
478: 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG(+)');
479: END IF;
480: IF (g_level_procedure >= g_current_runtime_level ) THEN
481: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG',
482: 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG(-)');
477: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG',
478: 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG(+)');
479: END IF;
480: IF (g_level_procedure >= g_current_runtime_level ) THEN
481: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG',
482: 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG(-)');
483: END IF;
484: return null;
485: exception
478: 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG(+)');
479: END IF;
480: IF (g_level_procedure >= g_current_runtime_level ) THEN
481: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG',
482: 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG(-)');
483: END IF;
484: return null;
485: exception
486: When others then
485: exception
486: When others then
487: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
488: IF (g_level_unexpected >= g_current_runtime_level ) THEN
489: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG EXCEPTION ERROR:',
490: g_error_buffer);
491: END IF;
492: end audit_flag;
493:
593: begin
594: return NULL;
595: end customer_name;
596:
597: end ARP_TAX_VIEW_TAXWARE;