DBA Data[Home] [Help]

APPS.INL_CHARGE_PVT dependencies on INL_SHIP_LINE_GROUPS

Line 623: l_to_parent_tbl_name_order CONSTANT VARCHAR2(30) := 'INL_SHIP_LINE_GROUPS';

619: x_return_status OUT NOCOPY VARCHAR2
620: ) IS
621:
622: l_proc_name CONSTANT VARCHAR2(30) := 'Get_ChargesFromQP';
623: l_to_parent_tbl_name_order CONSTANT VARCHAR2(30) := 'INL_SHIP_LINE_GROUPS';
624: l_to_parent_tbl_name_line CONSTANT VARCHAR2(30) := 'INL_SHIP_LINES';
625: l_no_freight_charge EXCEPTION;
626:
627: l_debug_info VARCHAR2(200);

Line 2667: FROM inl_ship_line_groups lg

2663: WHERE sh.ship_header_id = p_ship_header_id;
2664:
2665: SELECT *
2666: BULK COLLECT INTO l_ship_ln_group_tbl
2667: FROM inl_ship_line_groups lg
2668: WHERE lg.ship_header_id = p_ship_header_id
2669: ORDER BY ship_line_group_id; -- line in the same order
2670:
2671: INL_LOGGING_PVT.Log_Variable (