APPS.INL_CHARGE_PVT dependencies on DUAL

Line 237: FROM dual;

233: );
234:
235: SELECT inl_charge_lines_s.NEXTVAL
236: INTO l_charge_line_id
237: FROM dual;
238:
239: l_debug_info := 'Get the Charge Line Number';
240: INL_LOGGING_PVT.Log_Statement (
241: p_module_name => g_module_name,

Line 2503: l_count_dual_assoc NUMBER;

2499:
2500: l_charge_ln_tbl charge_ln_tbl;
2501:
2502: l_currency_conversion_rate NUMBER;
2503: l_count_dual_assoc NUMBER;
2504:
2505: -- ln group
2506: l_ship_ln_group_tbl ship_ln_group_tbl_tp;
2507:

Line 2580: l_debug_info := 'Verifying if there is charge with dual association.';

2576: p_debug_info => l_debug_info);
2577:
2578: -- Error if exist any estimated charge associated to different Shipment
2579: -- this situation is not covered yet
2580: l_debug_info := 'Verifying if there is charge with dual association.';
2581: INL_LOGGING_PVT.Log_Statement (
2582: p_module_name => g_module_name,
2583: p_procedure_name => l_api_name,
2584: p_debug_info => l_debug_info);

Line 2587: INTO l_count_dual_assoc

2583: p_procedure_name => l_api_name,
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'

Line 2598: IF NVL(l_count_dual_assoc,0) > 0 THEN

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
2599: INL_LOGGING_PVT.Log_Variable (
2600: p_module_name => g_module_name,
2601: p_procedure_name => l_api_name,
2602: p_var_name => 'l_count_dual_assoc',

Line 2602: p_var_name => 'l_count_dual_assoc',

2598: IF NVL(l_count_dual_assoc,0) > 0 THEN
2599: INL_LOGGING_PVT.Log_Variable (
2600: p_module_name => g_module_name,
2601: p_procedure_name => l_api_name,
2602: p_var_name => 'l_count_dual_assoc',
2603: p_var_value => l_count_dual_assoc);
2604:
2605: l_debug_info := 'No data found in Shipment Line Groups / Shipment Line. Raising expected error.';
2606: INL_LOGGING_PVT.Log_Statement (

Line 2603: p_var_value => l_count_dual_assoc);

2599: INL_LOGGING_PVT.Log_Variable (
2600: p_module_name => g_module_name,
2601: p_procedure_name => l_api_name,
2602: p_var_name => 'l_count_dual_assoc',
2603: p_var_value => l_count_dual_assoc);
2604:
2605: l_debug_info := 'No data found in Shipment Line Groups / Shipment Line. Raising expected error.';
2606: INL_LOGGING_PVT.Log_Statement (
2607: p_module_name => g_module_name,