APPS.AP_XML_TAX_DERIVATION_PKG dependencies on ARP_UTIL_TAX

Line 64: arp_util_tax.debug('AP_XML_TAX_DERIVATION_PKG.correct_tax(+)');

60: l_tax_code VARCHAR2(30);
61: l_po_numbers char_table_type;
62:
63: begin
64: arp_util_tax.debug('AP_XML_TAX_DERIVATION_PKG.correct_tax(+)');
65: arp_util_tax.debug('p_invoice_id:'||to_char(p_invoice_id));
66: arp_util_tax.debug('p_vendor_id:'||to_char(p_vendor_id));
67: --
68: open num_of_tax_lines;

Line 65: arp_util_tax.debug('p_invoice_id:'||to_char(p_invoice_id));

61: l_po_numbers char_table_type;
62:
63: begin
64: arp_util_tax.debug('AP_XML_TAX_DERIVATION_PKG.correct_tax(+)');
65: arp_util_tax.debug('p_invoice_id:'||to_char(p_invoice_id));
66: arp_util_tax.debug('p_vendor_id:'||to_char(p_vendor_id));
67: --
68: open num_of_tax_lines;
69: fetch num_of_tax_lines into l_num_of_tax_lines;

Line 66: arp_util_tax.debug('p_vendor_id:'||to_char(p_vendor_id));

62:
63: begin
64: arp_util_tax.debug('AP_XML_TAX_DERIVATION_PKG.correct_tax(+)');
65: arp_util_tax.debug('p_invoice_id:'||to_char(p_invoice_id));
66: arp_util_tax.debug('p_vendor_id:'||to_char(p_vendor_id));
67: --
68: open num_of_tax_lines;
69: fetch num_of_tax_lines into l_num_of_tax_lines;
70: close num_of_tax_lines;

Line 80: arp_util_tax.debug('num_of_tax_lines:'||to_char(l_num_of_tax_lines));

76: open org_id;
77: fetch org_id into l_org_id;
78: close org_id;
79:
80: arp_util_tax.debug('num_of_tax_lines:'||to_char(l_num_of_tax_lines));
81:
82: if l_num_of_tax_lines = 0 and nvl(l_po_numbers.last, 0) = 1 then
83: select ap_invoice_lines_interface_s.nextval
84: into l_invoice_line_id

Line 99: arp_util_tax.debug('po_number:'||l_po_numbers(1));

95:
96: if l_num_of_tax_lines = 1 and
97: nvl(l_po_numbers.last, 0) = 1 then
98:
99: arp_util_tax.debug('po_number:'||l_po_numbers(1));
100: arp_util_tax.debug('org_id:'||to_char(l_org_id));
101:
102: open ship_to(l_po_numbers(1), l_org_id);
103: fetch ship_to bulk collect into l_countries, l_states;

Line 100: arp_util_tax.debug('org_id:'||to_char(l_org_id));

96: if l_num_of_tax_lines = 1 and
97: nvl(l_po_numbers.last, 0) = 1 then
98:
99: arp_util_tax.debug('po_number:'||l_po_numbers(1));
100: arp_util_tax.debug('org_id:'||to_char(l_org_id));
101:
102: open ship_to(l_po_numbers(1), l_org_id);
103: fetch ship_to bulk collect into l_countries, l_states;
104: close ship_to;

Line 107: arp_util_tax.debug('country:'||l_countries(1));

103: fetch ship_to bulk collect into l_countries, l_states;
104: close ship_to;
105:
106: if nvl(l_countries.last, 0) <> 0 then
107: arp_util_tax.debug('country:'||l_countries(1));
108: arp_util_tax.debug('state:'||l_states(1));
109:
110: open tax_code(l_countries(1), l_states(1), p_vendor_id);
111: fetch tax_code into l_tax_code;

Line 108: arp_util_tax.debug('state:'||l_states(1));

104: close ship_to;
105:
106: if nvl(l_countries.last, 0) <> 0 then
107: arp_util_tax.debug('country:'||l_countries(1));
108: arp_util_tax.debug('state:'||l_states(1));
109:
110: open tax_code(l_countries(1), l_states(1), p_vendor_id);
111: fetch tax_code into l_tax_code;
112: close tax_code;

Line 119: arp_util_tax.debug('tax_code:'||l_tax_code);

115: if l_tax_code is null then
116: l_tax_code := l_states(1)||'-Taxable';
117: end if;
118:
119: arp_util_tax.debug('tax_code:'||l_tax_code);
120:
121: UPDATE AP_INVOICE_LINES_INTERFACE
122: SET TAX_CODE = l_tax_code
123: WHERE INVOICE_ID = p_invoice_id and

Line 128: arp_util_tax.debug('AP_XML_TAX_DERIVATION_PKG.correct_tax(-)');

124: TAX_CODE is NULL;
125: end if;
126: end if;
127: --
128: arp_util_tax.debug('AP_XML_TAX_DERIVATION_PKG.correct_tax(-)');
129: end;
130:
131: END AP_XML_TAX_DERIVATION_PKG;