eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_MM_RESERVATIONS_PVT dependencies on INV_RESERVATION_GLOBAL

Line 21: x_mtl_reservation_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,

17: x_return_status OUT NOCOPY VARCHAR2
18: );
19: PROCEDURE CONVERT_TO_INV_TABLE_TYPE(p_mtl_reservation_rec IN mtl_reservation_rec_type ,
20: p_serial_number_tbl IN serial_number_tbl_type ,
21: x_mtl_reservation_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
22: x_serial_number_tbl OUT NOCOPY inv_reservation_global.serial_number_tbl_type);
23: PROCEDURE INITIALIZE_REC_FROM_RESV(
24: p_reservation_id IN NUMBER,
25: p_x_rsv_rec IN OUT NOCOPY mtl_reservation_rec_type) ;

Line 22: x_serial_number_tbl OUT NOCOPY inv_reservation_global.serial_number_tbl_type);

18: );
19: PROCEDURE CONVERT_TO_INV_TABLE_TYPE(p_mtl_reservation_rec IN mtl_reservation_rec_type ,
20: p_serial_number_tbl IN serial_number_tbl_type ,
21: x_mtl_reservation_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
22: x_serial_number_tbl OUT NOCOPY inv_reservation_global.serial_number_tbl_type);
23: PROCEDURE INITIALIZE_REC_FROM_RESV(
24: p_reservation_id IN NUMBER,
25: p_x_rsv_rec IN OUT NOCOPY mtl_reservation_rec_type) ;
26:

Line 94: l_create_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

90: l_msg_data VARCHAR2(2000);
91: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
92:
93: l_rsv_rec mtl_reservation_rec_type := p_rsv_rec;
94: l_create_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
95: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
96: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
97: l_x_quantity_reserved NUMBER;
98: l_scheduled_material_id NUMBER := p_rsv_rec.demand_source_line_detail;

Line 95: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

91: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
92:
93: l_rsv_rec mtl_reservation_rec_type := p_rsv_rec;
94: l_create_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
95: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
96: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
97: l_x_quantity_reserved NUMBER;
98: l_scheduled_material_id NUMBER := p_rsv_rec.demand_source_line_detail;
99: l_x_reservation_id NUMBER;

Line 96: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

92:
93: l_rsv_rec mtl_reservation_rec_type := p_rsv_rec;
94: l_create_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
95: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
96: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
97: l_x_quantity_reserved NUMBER;
98: l_scheduled_material_id NUMBER := p_rsv_rec.demand_source_line_detail;
99: l_x_reservation_id NUMBER;
100:

Line 194: IF(l_create_rsv_rec.supply_source_type_id = inv_reservation_global.g_source_type_inv) THEN

190: END IF;
191: RAISE FND_API.G_EXC_ERROR;
192: END IF;
193:
194: IF(l_create_rsv_rec.supply_source_type_id = inv_reservation_global.g_source_type_inv) THEN
195:
196: -- Validate to make sure that the Serial Number is not empty, when Supply is Inventory.
197: IF (l_serial_number_tbl.COUNT < 1) THEN
198: FND_MESSAGE.set_name( 'AHL', 'AHL_PP_SERIAL_MISSING' );

Line 408: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

404: SELECT mrsv.primary_reservation_quantity,mrsv.inventory_item_id
405: FROM mtl_reservations mrsv
406: WHERE mrsv.reservation_id = c_resrv_id;
407:
408: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
409: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
410: --dummy variables
411: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
412: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

Line 409: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

405: FROM mtl_reservations mrsv
406: WHERE mrsv.reservation_id = c_resrv_id;
407:
408: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
409: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
410: --dummy variables
411: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
412: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
413: l_primary_reservation_quantity NUMBER;

Line 411: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

407:
408: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
409: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
410: --dummy variables
411: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
412: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
413: l_primary_reservation_quantity NUMBER;
414: l_scheduled_material_id NUMBER;
415: l_inventory_item_id NUMBER;

Line 412: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

408: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
409: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
410: --dummy variables
411: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
412: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
413: l_primary_reservation_quantity NUMBER;
414: l_scheduled_material_id NUMBER;
415: l_inventory_item_id NUMBER;
416:

Line 688: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

684: l_msg_count NUMBER;
685: l_msg_data VARCHAR2(2000);
686:
687:
688: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
689: --dummy
690: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
691:
692: l_ret_value NUMBER;

Line 690: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

686:
687:
688: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
689: --dummy
690: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
691:
692: l_ret_value NUMBER;
693: l_reservation_id NUMBER;
694:

Line 891: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

887: l_msg_count NUMBER;
888: l_msg_data VARCHAR2(2000);
889: l_commit VARCHAR2(1) := 'F';
890:
891: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
892: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
893: l_reservation_id NUMBER;
894: l_reserved_quantity NUMBER;
895: l_x_primary_relieved_quantity NUMBER;

Line 892: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

888: l_msg_data VARCHAR2(2000);
889: l_commit VARCHAR2(1) := 'F';
890:
891: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
892: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
893: l_reservation_id NUMBER;
894: l_reserved_quantity NUMBER;
895: l_x_primary_relieved_quantity NUMBER;
896: l_x_primary_remain_quantity NUMBER;

Line 1154: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1150: l_reservation_id NUMBER;
1151: l_wip_entity_id NUMBER;
1152: l_rsv_rec mtl_reservation_rec_type := p_to_rsv_rec;
1153: l_serial_number_tbl serial_number_tbl_type := p_serial_number_tbl;
1154: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1155: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1156: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type ; -- dummy
1157: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type ;
1158: l_x_to_reservation_id NUMBER;

Line 1155: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1151: l_wip_entity_id NUMBER;
1152: l_rsv_rec mtl_reservation_rec_type := p_to_rsv_rec;
1153: l_serial_number_tbl serial_number_tbl_type := p_serial_number_tbl;
1154: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1155: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1156: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type ; -- dummy
1157: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type ;
1158: l_x_to_reservation_id NUMBER;
1159: l_subinventory_name VARCHAR2(10);

Line 1156: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type ; -- dummy

1152: l_rsv_rec mtl_reservation_rec_type := p_to_rsv_rec;
1153: l_serial_number_tbl serial_number_tbl_type := p_serial_number_tbl;
1154: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1155: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1156: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type ; -- dummy
1157: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type ;
1158: l_x_to_reservation_id NUMBER;
1159: l_subinventory_name VARCHAR2(10);
1160: l_locator_id NUMBER;

Line 1157: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type ;

1153: l_serial_number_tbl serial_number_tbl_type := p_serial_number_tbl;
1154: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1155: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1156: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type ; -- dummy
1157: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type ;
1158: l_x_to_reservation_id NUMBER;
1159: l_subinventory_name VARCHAR2(10);
1160: l_locator_id NUMBER;
1161: l_scheduled_material_id NUMBER;

Line 1612: IF(l_create_rsv_rec.supply_source_type_id = inv_reservation_global.g_source_type_inv) THEN

1608: END IF;
1609:
1610:
1611:
1612: IF(l_create_rsv_rec.supply_source_type_id = inv_reservation_global.g_source_type_inv) THEN
1613:
1614: -- If reservation Id passed, then call Update reservation directly.
1615: -- For the case when we want to update reservation from IR to Inv
1616: IF(l_create_rsv_rec.reservation_id IS NOT NULL AND l_create_rsv_rec.reservation_id <> FND_API.G_MISS_NUM)

Line 1962: ELSIF(l_create_rsv_rec.supply_source_type_id = inv_reservation_global.g_source_type_wip OR l_create_rsv_rec.supply_source_type_id = inv_reservation_global.g_source_type_internal_req)

1958: END IF;
1959: END IF; -- Reservation_id is not null
1960: --------------------------------------------------------
1961: -- PEKAMBAR - Enhanced to support supply source is WIP Entity Type , Internal Requesition(i.e Workorder)
1962: ELSIF(l_create_rsv_rec.supply_source_type_id = inv_reservation_global.g_source_type_wip OR l_create_rsv_rec.supply_source_type_id = inv_reservation_global.g_source_type_internal_req)
1963: THEN
1964: IF (l_log_statement >= l_log_current_level) THEN
1965: IF(l_create_rsv_rec.supply_source_type_id = inv_reservation_global.g_source_type_wip)
1966: THEN

Line 1965: IF(l_create_rsv_rec.supply_source_type_id = inv_reservation_global.g_source_type_wip)

1961: -- PEKAMBAR - Enhanced to support supply source is WIP Entity Type , Internal Requesition(i.e Workorder)
1962: ELSIF(l_create_rsv_rec.supply_source_type_id = inv_reservation_global.g_source_type_wip OR l_create_rsv_rec.supply_source_type_id = inv_reservation_global.g_source_type_internal_req)
1963: THEN
1964: IF (l_log_statement >= l_log_current_level) THEN
1965: IF(l_create_rsv_rec.supply_source_type_id = inv_reservation_global.g_source_type_wip)
1966: THEN
1967: fnd_log.string
1968: (
1969: fnd_log.level_statement,

Line 2140: END IF; -- supply type inventory => l_create_rsv_rec.supply_source_type_id = inv_reservation_global.g_source_type_inv

2136: );
2137: END IF;
2138: RAISE FND_API.G_EXC_ERROR;
2139:
2140: END IF; -- supply type inventory => l_create_rsv_rec.supply_source_type_id = inv_reservation_global.g_source_type_inv
2141:
2142: -- Check Error Message stack.
2143: x_msg_count := FND_MSG_PUB.count_msg;
2144: IF x_msg_count > 0

Line 2689: p_x_rsv_rec.demand_source_type_id := inv_reservation_global.g_source_type_wip;

2685: CLOSE get_resrv_detials_csr;
2686:
2687: --Demand Details
2688: p_x_rsv_rec.demand_source_name := 'CMRO'||'.'||'WO:';
2689: p_x_rsv_rec.demand_source_type_id := inv_reservation_global.g_source_type_wip;
2690: p_x_rsv_rec.demand_source_header_id := rsv_rec.demand_source_header_id;
2691: p_x_rsv_rec.demand_source_line_id := rsv_rec.demand_source_line_id;
2692: p_x_rsv_rec.demand_source_line_detail := rsv_rec.demand_source_line_detail;
2693: p_x_rsv_rec.requirement_date := rsv_rec.requirement_date;

Line 2814: p_x_rsv_rec.demand_source_type_id := inv_reservation_global.g_source_type_wip;

2810:
2811:
2812: --Demand Details
2813: p_x_rsv_rec.demand_source_name := 'CMRO'||'.'||'WO:'||l_mtl_req_dtls_rec.workorder_id; --||'.'||'Wip:header'||'.'||'ASM:detail'
2814: p_x_rsv_rec.demand_source_type_id := inv_reservation_global.g_source_type_wip;
2815: p_x_rsv_rec.demand_source_header_id := l_mtl_req_dtls_rec.wip_entity_id;
2816: p_x_rsv_rec.demand_source_line_id := l_mtl_req_dtls_rec.operation_sequence;
2817: p_x_rsv_rec.demand_source_line_detail := p_schedule_material_id;
2818: p_x_rsv_rec.requirement_date := l_mtl_req_dtls_rec.requested_date;

Line 2838: p_x_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;

2834: p_x_rsv_rec.subinventory_code := NULL;
2835: END IF;
2836: --Defaulting to inventory reservation. Otherwise, expected to be passed by the caller API.
2837: IF(p_x_rsv_rec.supply_source_type_id IS NULL OR p_x_rsv_rec.supply_source_type_id = FND_API.G_MISS_NUM) THEN
2838: p_x_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;
2839: p_x_rsv_rec.supply_source_header_id := NULL;
2840: p_x_rsv_rec.supply_source_line_id := NULL;
2841: p_x_rsv_rec.supply_source_line_detail := NULL;
2842: END IF;

Line 2986: x_mtl_reservation_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,

2982: END GET_MATCHING_RESERVATION;
2983:
2984: PROCEDURE CONVERT_TO_INV_TABLE_TYPE(p_mtl_reservation_rec IN mtl_reservation_rec_type ,
2985: p_serial_number_tbl IN serial_number_tbl_type,
2986: x_mtl_reservation_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
2987: x_serial_number_tbl OUT NOCOPY inv_reservation_global.serial_number_tbl_type) IS
2988: -- Declare local variables
2989: l_api_name CONSTANT VARCHAR2(30) := 'CONVERT_TO_INV_TABLE_TYPE';
2990: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;

Line 2987: x_serial_number_tbl OUT NOCOPY inv_reservation_global.serial_number_tbl_type) IS

2983:
2984: PROCEDURE CONVERT_TO_INV_TABLE_TYPE(p_mtl_reservation_rec IN mtl_reservation_rec_type ,
2985: p_serial_number_tbl IN serial_number_tbl_type,
2986: x_mtl_reservation_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
2987: x_serial_number_tbl OUT NOCOPY inv_reservation_global.serial_number_tbl_type) IS
2988: -- Declare local variables
2989: l_api_name CONSTANT VARCHAR2(30) := 'CONVERT_TO_INV_TABLE_TYPE';
2990: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
2991:

Line 3177: p_x_rsv_rec.demand_source_type_id := inv_reservation_global.g_source_type_wip;

3173: END IF;
3174:
3175: --Demand Details
3176: p_x_rsv_rec.demand_source_name := 'CMRO'||'.'||'WO:'||l_mtl_req_dtls_rec.workorder_id; --||'.'||'Wip:header'||'.'||'ASM:detail'
3177: p_x_rsv_rec.demand_source_type_id := inv_reservation_global.g_source_type_wip;
3178: p_x_rsv_rec.demand_source_header_id := l_mtl_req_dtls_rec.wip_entity_id;
3179: p_x_rsv_rec.demand_source_line_id := l_mtl_req_dtls_rec.operation_sequence;
3180: p_x_rsv_rec.demand_source_line_detail := p_schedule_material_id;
3181: p_x_rsv_rec.requirement_date := l_mtl_req_dtls_rec.requested_date;

Line 3205: p_x_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;

3201:
3202:
3203: /* Removed extra supply details from the record
3204: IF(p_x_rsv_rec.supply_source_type_id IS NULL OR p_x_rsv_rec.supply_source_type_id = FND_API.G_MISS_NUM) THEN
3205: p_x_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;
3206: p_x_rsv_rec.supply_source_header_id := NULL;
3207: p_x_rsv_rec.supply_source_line_id := NULL;
3208: p_x_rsv_rec.supply_source_line_detail := NULL;
3209: END IF;