DBA Data[Home] [Help]

APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on INV_RESERVATION_GLOBAL

Line 457: l_rsv_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;

453: l_old_mmtt_cnt NUMBER;
454: l_quantity_delivered NUMBER;
455: l_sec_qty_delivered NUMBER := 0; -- Bug 8312574
456:
457: l_rsv_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;
458: l_dummy_sn INV_Reservation_Global.Serial_Number_Tbl_Type;
459: l_qty_succ_reserved NUMBER;
460: l_sec_qty_succ_reserved NUMBER;
461: l_cc_res_id NUMBER;

Line 458: l_dummy_sn INV_Reservation_Global.Serial_Number_Tbl_Type;

454: l_quantity_delivered NUMBER;
455: l_sec_qty_delivered NUMBER := 0; -- Bug 8312574
456:
457: l_rsv_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;
458: l_dummy_sn INV_Reservation_Global.Serial_Number_Tbl_Type;
459: l_qty_succ_reserved NUMBER;
460: l_sec_qty_succ_reserved NUMBER;
461: l_cc_res_id NUMBER;
462: l_line_status NUMBER;

Line 567: l_original_serial_number inv_reservation_global.serial_number_tbl_type; --Bug#8267628

563:
564:
565: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
566: l_proc_name VARCHAR2(30) := 'Suggest_alternate_location';
567: l_original_serial_number inv_reservation_global.serial_number_tbl_type; --Bug#8267628
568: l_new_rsv_id NUMBER ; --8557758
569: l_parent_line_id NUMBER := NULL ; --Bug8460179
570:
571: BEGIN

Line 1001: l_rsv_rec.demand_source_type_id := inv_reservation_global.g_source_type_cycle_count;

997: l_rsv_rec.reservation_id := NULL; --cannot know
998: l_rsv_rec.requirement_date := SYSDATE;
999: l_rsv_rec.organization_id := l_organization_id;
1000: l_rsv_rec.inventory_item_id := l_item_id;
1001: l_rsv_rec.demand_source_type_id := inv_reservation_global.g_source_type_cycle_count;
1002: l_rsv_rec.demand_source_name := NULL;
1003: l_rsv_rec.demand_source_header_id := -1; --l_header_id;
1004: l_rsv_rec.demand_source_line_id := -1; --l_line_num;
1005: l_rsv_rec.demand_source_delivery := NULL;

Line 1018: l_rsv_rec.supply_source_type_id := INV_Reservation_GLOBAL.g_source_type_inv;

1014: l_rsv_rec.secondary_reservation_quantity:= l_secondary_quantity; --bug 8197499
1015: l_rsv_rec.autodetail_group_id := NULL;
1016: l_rsv_rec.external_source_code := NULL;
1017: l_rsv_rec.external_source_line_id := NULL;
1018: l_rsv_rec.supply_source_type_id := INV_Reservation_GLOBAL.g_source_type_inv;
1019: l_rsv_rec.supply_source_header_id := NULL;
1020: l_rsv_rec.supply_source_line_id := NULL;
1021: l_rsv_rec.supply_source_name := NULL;
1022: l_rsv_rec.supply_source_line_detail := NULL;

Line 2300: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;

2296: l_sec_rsv_uom VARCHAR2(3);
2297: l_rsv_uom VARCHAR2(3);
2298: l_rsv_lot_num VARCHAR2(80); -- Added for Bug 8542094
2299: l_rsv_org_id NUMBER; -- Added for Bug 8542094
2300: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
2301: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
2302: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
2303: --Bug#6027401.
2304:

Line 2301: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;

2297: l_rsv_uom VARCHAR2(3);
2298: l_rsv_lot_num VARCHAR2(80); -- Added for Bug 8542094
2299: l_rsv_org_id NUMBER; -- Added for Bug 8542094
2300: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
2301: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
2302: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
2303: --Bug#6027401.
2304:
2305: l_primary_uom VARCHAR2(3);

Line 2302: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;

2298: l_rsv_lot_num VARCHAR2(80); -- Added for Bug 8542094
2299: l_rsv_org_id NUMBER; -- Added for Bug 8542094
2300: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
2301: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
2302: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
2303: --Bug#6027401.
2304:
2305: l_primary_uom VARCHAR2(3);
2306: l_secondary_uom VARCHAR2(3);