DBA Data[Home] [Help]

APPS.INL_SIMULATION_PVT dependencies on INL_TAX_LINES

Line 77: FROM inl_tax_lines itl,

73: itl.last_update_date,
74: itl.last_update_login,
75: ias.allocation_basis,
76: ias.allocation_uom_code
77: FROM inl_tax_lines itl,
78: inl_associations ias
79: WHERE ias.from_parent_table_name = 'INL_TAX_LINES'
80: AND ias.from_parent_table_id = p_from_parent_table_id
81: AND ias.to_parent_table_name = p_to_parent_table_name

Line 79: WHERE ias.from_parent_table_name = 'INL_TAX_LINES'

75: ias.allocation_basis,
76: ias.allocation_uom_code
77: FROM inl_tax_lines itl,
78: inl_associations ias
79: WHERE ias.from_parent_table_name = 'INL_TAX_LINES'
80: AND ias.from_parent_table_id = p_from_parent_table_id
81: AND ias.to_parent_table_name = p_to_parent_table_name
82: AND ias.to_parent_table_id = p_current_to_parent_table_id
83: AND itl.tax_line_id = p_from_parent_table_id

Line 152: SELECT inl_tax_lines_s.NEXTVAL

148: p_procedure_name => l_api_name,
149: p_debug_info => 'Get the next Tax Line Id');
150:
151: -- Get Charge Line nextval
152: SELECT inl_tax_lines_s.NEXTVAL
153: INTO l_tax_line_id
154: FROM dual;
155:
156: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

Line 158: p_debug_info => 'Insert into INL_TAX_LINES');

154: FROM dual;
155:
156: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
157: p_procedure_name => l_api_name,
158: p_debug_info => 'Insert into INL_TAX_LINES');
159:
160: INSERT INTO inl_tax_lines (tax_line_id,
161: tax_line_num,
162: tax_code,

Line 160: INSERT INTO inl_tax_lines (tax_line_id,

156: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
157: p_procedure_name => l_api_name,
158: p_debug_info => 'Insert into INL_TAX_LINES');
159:
160: INSERT INTO inl_tax_lines (tax_line_id,
161: tax_line_num,
162: tax_code,
163: ship_header_id,
164: parent_tax_line_id,

Line 224: 'INL_TAX_LINES',

220: last_update_date,
221: last_update_login)
222: VALUES (inl_associations_s.NEXTVAL,
223: p_new_ship_header_id,
224: 'INL_TAX_LINES',
225: l_tax_line_id,
226: p_to_parent_table_name,
227: p_new_to_parent_table_id,
228: TaxLines_List(i).allocation_basis,

Line 1032: ELSIF l_from_association_tbl(j).from_parent_table_name = 'INL_TAX_LINES' THEN

1028: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1030: END IF;
1031:
1032: ELSIF l_from_association_tbl(j).from_parent_table_name = 'INL_TAX_LINES' THEN
1033: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1034: p_procedure_name => l_api_name,
1035: p_debug_info => 'Call Duplicate_Tax');
1036: