APPS.INV_TRX_RELIEF_C_PVT dependencies on INV_RESERVATION_GLOBAL

Line 45: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

41: )
42: IS
43: l_primary_qty NUMBER;
44: l_reservation_id NUMBER;
45: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
46: l_total_qty_to_relieve NUMBER;
47: l_qty_to_relieve NUMBER;
48: l_qty_reserved NUMBER;
49: l_dummy_serial_numbers inv_reservation_global.serial_number_tbl_type;

Line 49: l_dummy_serial_numbers inv_reservation_global.serial_number_tbl_type;

45: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
46: l_total_qty_to_relieve NUMBER;
47: l_qty_to_relieve NUMBER;
48: l_qty_reserved NUMBER;
49: l_dummy_serial_numbers inv_reservation_global.serial_number_tbl_type;
50: l_qty_relieved NUMBER;
51: l_remain_qty NUMBER;
52: l_ship_qty NUMBER;
53: l_msg_count NUMBER;

Line 773: if (p_dsrc_type in (inv_reservation_global.g_source_type_oe,

769: debug_print (' total qty TO relieve ' || l_total_qty_to_relieve);
770: END IF;
771: END LOOP;
772:
773: if (p_dsrc_type in (inv_reservation_global.g_source_type_oe,
774: inv_reservation_global.g_source_type_internal_ord)) then
775: l_stmt := '15';
776:
777: open l_oe_cur ;

Line 774: inv_reservation_global.g_source_type_internal_ord)) then

770: END IF;
771: END LOOP;
772:
773: if (p_dsrc_type in (inv_reservation_global.g_source_type_oe,
774: inv_reservation_global.g_source_type_internal_ord)) then
775: l_stmt := '15';
776:
777: open l_oe_cur ;
778: fetch l_oe_cur into

Line 890: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

886: )
887: IS
888: l_primary_qty NUMBER;
889: l_reservation_id NUMBER;
890: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
891: l_total_qty_to_relieve NUMBER;
892: l_total_secondary_to_relieve NUMBER; -- INVCONV
893: l_qty_to_relieve NUMBER;
894: l_secondary_to_relieve NUMBER; -- INVCONV

Line 897: l_original_serial_numbers inv_reservation_global.serial_number_tbl_type;

893: l_qty_to_relieve NUMBER;
894: l_secondary_to_relieve NUMBER; -- INVCONV
895: l_qty_reserved NUMBER;
896: l_secondary_qty_reserved NUMBER; -- INVCONV
897: l_original_serial_numbers inv_reservation_global.serial_number_tbl_type;
898: l_qty_relieved NUMBER;
899: l_secondary_qty_relieved NUMBER; -- INVCONV
900: l_remain_qty NUMBER;
901: l_secondary_remain_qty NUMBER; -- INVCONV

Line 917: l_serial_number_table inv_reservation_global.serial_number_tbl_type;

913: l_miss_num NUMBER;
914: l_supply_src_type_id NUMBER := 13;
915: -- end declaration for 3347075
916: l_tracking_quantity_ind VARCHAR2(30); -- INVCONV
917: l_serial_number_table inv_reservation_global.serial_number_tbl_type;
918:
919: CURSOR l_mps_flag_cur IS
920: SELECT 1 FROM dual WHERE exists (SELECT NULL FROM mrp_parameters);
921:

Line 1701: if (p_dsrc_type in (inv_reservation_global.g_source_type_oe,

1697: debug_print (' total secondary TO relieve ' || l_total_secondary_to_relieve); -- INVCONV
1698: END IF;
1699: END LOOP;
1700:
1701: if (p_dsrc_type in (inv_reservation_global.g_source_type_oe,
1702: inv_reservation_global.g_source_type_internal_ord)) then
1703: l_stmt := '15';
1704:
1705: open l_oe_cur ;

Line 1702: inv_reservation_global.g_source_type_internal_ord)) then

1698: END IF;
1699: END LOOP;
1700:
1701: if (p_dsrc_type in (inv_reservation_global.g_source_type_oe,
1702: inv_reservation_global.g_source_type_internal_ord)) then
1703: l_stmt := '15';
1704:
1705: open l_oe_cur ;
1706: fetch l_oe_cur into