DBA Data[Home] [Help]

APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on INV_RESERVATION_GLOBAL

Line 451: l_rsv_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;

447: l_new_mmtt_cnt NUMBER;
448: l_old_mmtt_cnt NUMBER;
449: l_quantity_delivered NUMBER;
450:
451: l_rsv_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;
452: l_dummy_sn INV_Reservation_Global.Serial_Number_Tbl_Type;
453: l_qty_succ_reserved NUMBER;
454: l_sec_qty_succ_reserved NUMBER;
455: l_cc_res_id NUMBER;

Line 452: l_dummy_sn INV_Reservation_Global.Serial_Number_Tbl_Type;

448: l_old_mmtt_cnt NUMBER;
449: l_quantity_delivered NUMBER;
450:
451: l_rsv_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;
452: l_dummy_sn INV_Reservation_Global.Serial_Number_Tbl_Type;
453: l_qty_succ_reserved NUMBER;
454: l_sec_qty_succ_reserved NUMBER;
455: l_cc_res_id NUMBER;
456: l_line_status NUMBER;

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

910: l_rsv_rec.reservation_id := NULL; -- cannot know
911: l_rsv_rec.requirement_date := Sysdate;
912: l_rsv_rec.organization_id := l_organization_id;
913: l_rsv_rec.inventory_item_id := l_item_id;
914: l_rsv_rec.demand_source_type_id := inv_reservation_global.g_source_type_cycle_count;
915: l_rsv_rec.demand_source_name := NULL;
916: l_rsv_rec.demand_source_header_id := -1; --l_header_id;
917: l_rsv_rec.demand_source_line_id := -1; --l_line_num;
918: l_rsv_rec.demand_source_delivery := NULL;

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

926: l_rsv_rec.primary_reservation_quantity := l_primary_qty;
927: l_rsv_rec.autodetail_group_id := NULL;
928: l_rsv_rec.external_source_code := NULL;
929: l_rsv_rec.external_source_line_id := NULL;
930: l_rsv_rec.supply_source_type_id := INV_Reservation_GLOBAL.g_source_type_inv;
931: l_rsv_rec.supply_source_header_id := NULL;
932: l_rsv_rec.supply_source_line_id := NULL;
933: l_rsv_rec.supply_source_name := NULL;
934: l_rsv_rec.supply_source_line_detail := NULL;

Line 1762: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;

1758: l_pri_rsv_qty NUMBER;
1759: l_rsv_qty NUMBER;
1760: l_pri_rsv_uom VARCHAR2(3);
1761: l_rsv_uom VARCHAR2(3);
1762: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
1763: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
1764: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
1765: --Bug#6027401.
1766:

Line 1763: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;

1759: l_rsv_qty NUMBER;
1760: l_pri_rsv_uom VARCHAR2(3);
1761: l_rsv_uom VARCHAR2(3);
1762: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
1763: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
1764: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
1765: --Bug#6027401.
1766:
1767: CURSOR c_mmtt_info IS

Line 1764: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;

1760: l_pri_rsv_uom VARCHAR2(3);
1761: l_rsv_uom VARCHAR2(3);
1762: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
1763: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
1764: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
1765: --Bug#6027401.
1766:
1767: CURSOR c_mmtt_info IS
1768: SELECT mmtt.transaction_header_id