APPS.INL_CHARGE_PVT dependencies on INL_ASSOCIATIONS

Line 77: l_debug_info := 'Insert into INL Associations table';

73: WHERE ab.allocation_basis_code (+) = icv.allocation_basis
74: AND icv.charge_line_type_id (+) = icl.charge_line_type_id
75: AND icl.charge_line_id = p_from_parent_table_id;
76:
77: l_debug_info := 'Insert into INL Associations table';
78: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
79: p_procedure_name => l_proc_name,
80: p_debug_info => l_debug_info);
81:

Line 82: INSERT INTO inl_associations(

78: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
79: p_procedure_name => l_proc_name,
80: p_debug_info => l_debug_info);
81:
82: INSERT INTO inl_associations(
83: association_id,
84: ship_header_id,
85: from_parent_table_name,
86: from_parent_table_id,

Line 97: inl_associations_s.NEXTVAL,

93: last_updated_by,
94: last_update_date,
95: last_update_login)
96: VALUES (
97: inl_associations_s.NEXTVAL,
98: p_ship_header_id,
99: p_from_parent_table_name,
100: p_from_parent_table_id,
101: p_to_parent_table_name,

Line 249: inl_associations ias

245:
246: SELECT NVL(MAX(icl.charge_line_num),0) + 1
247: INTO l_charge_line_num
248: FROM inl_charge_lines icl,
249: inl_associations ias
250: WHERE ias.from_parent_table_name = 'INL_CHARGE_LINES'
251: AND ias.from_parent_table_id = icl.charge_line_id
252: AND ias.ship_header_id = p_ship_header_id;
253:

Line 2588: FROM inl_associations ias,

2584: p_debug_info => l_debug_info);
2585:
2586: SELECT COUNT(*)
2587: INTO l_count_dual_assoc
2588: FROM inl_associations ias,
2589: inl_charge_lines icl
2590: WHERE ias.from_parent_table_id = icl.charge_line_id
2591: AND ias.from_parent_table_name = 'INL_CHARGE_LINES'
2592: AND ias.ship_header_id = p_ship_header_id

Line 2594: FROM inl_associations ia2

2590: WHERE ias.from_parent_table_id = icl.charge_line_id
2591: AND ias.from_parent_table_name = 'INL_CHARGE_LINES'
2592: AND ias.ship_header_id = p_ship_header_id
2593: AND EXISTS (SELECT 1
2594: FROM inl_associations ia2
2595: WHERE ia2.from_parent_table_name = 'INL_CHARGE_LINES'
2596: AND ia2.from_parent_table_id = ias.from_parent_table_id
2597: AND ia2.ship_header_id <> p_ship_header_id);
2598: IF NVL(l_count_dual_assoc,0) > 0 THEN

Line 2627: FROM inl_associations ias

2623: DELETE
2624: FROM inl_charge_lines icl
2625: WHERE icl.charge_line_id
2626: IN (SELECT ias.from_parent_table_id
2627: FROM inl_associations ias
2628: WHERE ias.from_parent_table_name = 'INL_CHARGE_LINES'
2629: AND ias.ship_header_id = p_ship_header_id);
2630: */
2631: --Bug#9660056

Line 2636: FROM inl_associations ias

2632: DELETE
2633: FROM inl_charge_lines icl
2634: WHERE
2635: EXISTS ( SELECT 1
2636: FROM inl_associations ias
2637: WHERE ias.from_parent_table_name = 'INL_CHARGE_LINES'
2638: AND ias.ship_header_id = p_ship_header_id
2639: AND ias.from_parent_table_id = icl.charge_line_id );
2640: --Bug#9660056

Line 2649: FROM inl_associations ias

2645: p_procedure_name => l_api_name,
2646: p_debug_info => l_debug_info);
2647:
2648: DELETE
2649: FROM inl_associations ias
2650: WHERE ias.from_parent_table_name = 'INL_CHARGE_LINES'
2651: AND ias.ship_header_id = p_ship_header_id;
2652:
2653: l_debug_info := 'Deleted '|| SQL%ROWCOUNT||' ASSOCIATION LINES.';

Line 2883: -- into INL Charge Lines and INL Associations table

2879: RAISE L_FND_EXC_ERROR;
2880: -- Otherwise charges were generated and now we can process them
2881: ELSE
2882: -- Iterate through all generated Charges to insert
2883: -- into INL Charge Lines and INL Associations table
2884: FOR j IN 1 .. l_charge_ln_tbl.COUNT LOOP
2885: l_debug_info := 'Call Insert_ChargeLines(...)';
2886: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
2887: p_procedure_name => l_api_name,