APPS.INL_SIMULATION_PVT dependencies on INL_CHARGE_LINES

Line 380: FROM inl_charge_lines icl,

376: icl.last_update_date,
377: icl.last_update_login,
378: ias.allocation_basis,
379: ias.allocation_uom_code
380: FROM inl_charge_lines icl,
381: inl_associations ias
382: WHERE ias.from_parent_table_name = 'INL_CHARGE_LINES'
383: AND ias.from_parent_table_id = p_from_parent_table_id
384: AND ias.to_parent_table_name = p_to_parent_table_name

Line 382: WHERE ias.from_parent_table_name = 'INL_CHARGE_LINES'

378: ias.allocation_basis,
379: ias.allocation_uom_code
380: FROM inl_charge_lines icl,
381: inl_associations ias
382: WHERE ias.from_parent_table_name = 'INL_CHARGE_LINES'
383: AND ias.from_parent_table_id = p_from_parent_table_id
384: AND ias.to_parent_table_name = p_to_parent_table_name
385: AND ias.to_parent_table_id = p_current_to_parent_table_id
386: AND icl.charge_line_id = p_from_parent_table_id

Line 455: SELECT inl_charge_lines_s.NEXTVAL

451: p_procedure_name => l_api_name,
452: p_debug_info => 'Get the next Charge Line Id');
453:
454: -- Get Charge Line nextval
455: SELECT inl_charge_lines_s.NEXTVAL
456: INTO l_charge_line_id
457: FROM dual;
458:
459: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

Line 461: p_debug_info => 'Insert into INL_CHARGE_LINES');

457: FROM dual;
458:
459: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
460: p_procedure_name => l_api_name,
461: p_debug_info => 'Insert into INL_CHARGE_LINES');
462:
463: INSERT INTO inl_charge_lines (charge_line_id,
464: charge_line_num,
465: charge_line_type_id,

Line 463: INSERT INTO inl_charge_lines (charge_line_id,

459: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
460: p_procedure_name => l_api_name,
461: p_debug_info => 'Insert into INL_CHARGE_LINES');
462:
463: INSERT INTO inl_charge_lines (charge_line_id,
464: charge_line_num,
465: charge_line_type_id,
466: landed_cost_flag,
467: update_allowed,

Line 569: 'INL_CHARGE_LINES',

565: last_update_date,
566: last_update_login)
567: VALUES (inl_associations_s.NEXTVAL,
568: p_new_ship_header_id,
569: 'INL_CHARGE_LINES',
570: l_charge_line_id,
571: p_to_parent_table_name,
572: p_new_to_parent_table_id,
573: ChargeLines_List(i).allocation_basis,

Line 1007: IF l_from_association_tbl(j).from_parent_table_name = 'INL_CHARGE_LINES' THEN

1003: p_procedure_name => l_api_name,
1004: p_var_name => 'from_parent_table_id',
1005: p_var_value => l_from_association_tbl(j).from_parent_table_id);
1006:
1007: IF l_from_association_tbl(j).from_parent_table_name = 'INL_CHARGE_LINES' THEN
1008: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1009: p_procedure_name => l_api_name,
1010: p_debug_info => 'Call Duplicate_Charge');
1011:

Line 1353: IF l_from_association_tbl(j).from_parent_table_name = 'INL_CHARGE_LINES' THEN

1349: p_procedure_name => l_api_name,
1350: p_var_name => 'from_parent_table_id',
1351: p_var_value => l_from_association_tbl(j).from_parent_table_id);
1352:
1353: IF l_from_association_tbl(j).from_parent_table_name = 'INL_CHARGE_LINES' THEN
1354: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1355: p_procedure_name => l_api_name,
1356: p_debug_info => 'Call Duplicate_Charge');
1357:

Line 1809: IF l_from_association_tbl(j).from_parent_table_name = 'INL_CHARGE_LINES' THEN

1805: p_procedure_name => l_api_name,
1806: p_var_name => 'from_parent_table_id',
1807: p_var_value => l_from_association_tbl(j).from_parent_table_id);
1808:
1809: IF l_from_association_tbl(j).from_parent_table_name = 'INL_CHARGE_LINES' THEN
1810: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1811: p_procedure_name => l_api_name,
1812: p_debug_info => 'Call Duplicate_Charge');
1813: