APPS.AHL_MM_MTL_MGT_PVT dependencies on DUAL

Line 1223: FROM DUAL;

1219:
1220: --Get the profile value
1221: SELECT TO_NUMBER(FND_PROFILE.VALUE('AHL_GOP_ATP_PLANNING_WINDOW'))
1222: INTO l_planning_window
1223: FROM DUAL;
1224:
1225: --If Planning window is not defined, or if its null
1226: IF(l_planning_window IS NULL) THEN
1227: FND_FILE.put_line(FND_FILE.log, 'Planning Window is not defined');

Line 4568: FROM DUAL;

4564: l_transaction_header_id := NULL; -- this will identify the records to be picked up by transaction Manager
4565:
4566: SELECT Mtl_Material_Transactions_S.nextval
4567: INTO l_transaction_header_id
4568: FROM DUAL;
4569:
4570: --log
4571: G_DEBUG_LINE_NUM := 155;
4572: IF (l_log_statement >= l_log_current_level) THEN

Line 4837: SELECT Mtl_Material_Transactions_S.nextval INTO p_x_txn_hdr_id FROM DUAL;

4833: ',transaction header id '||p_x_txn_hdr_id);
4834: END IF;
4835:
4836: IF(p_x_txn_hdr_id IS NULL) THEN
4837: SELECT Mtl_Material_Transactions_S.nextval INTO p_x_txn_hdr_id FROM DUAL;
4838: END IF;
4839: G_DEBUG_LINE_NUM := 210;
4840: SELECT Mtl_Material_Transactions_S.nextval INTO p_x_txn_intf_id FROM DUAL;
4841: IF (l_log_statement >= l_log_current_level) THEN

Line 4840: SELECT Mtl_Material_Transactions_S.nextval INTO p_x_txn_intf_id FROM DUAL;

4836: IF(p_x_txn_hdr_id IS NULL) THEN
4837: SELECT Mtl_Material_Transactions_S.nextval INTO p_x_txn_hdr_id FROM DUAL;
4838: END IF;
4839: G_DEBUG_LINE_NUM := 210;
4840: SELECT Mtl_Material_Transactions_S.nextval INTO p_x_txn_intf_id FROM DUAL;
4841: IF (l_log_statement >= l_log_current_level) THEN
4842: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Interface Id created - '||p_x_txn_intf_id);
4843:
4844: END IF;

Line 4851: --SELECT AHL_SHIPMENT_NUMBER_S.nextval INTO l_shipment_num FROM dual;

4847: THEN
4848: G_DEBUG_LINE_NUM := 220;
4849: l_qty := -1;
4850: l_transaction_type_id := C_INTRANSIT_SHIPMENT;
4851: --SELECT AHL_SHIPMENT_NUMBER_S.nextval INTO l_shipment_num FROM dual;
4852:
4853: -- Check if shipment number already exists for this combination of organizations
4854: IF (ship_id_tbl IS NULL)
4855: THEN

Line 4856: SELECT AHL_SHIPMENT_NUMBER_S.nextval INTO l_shipment_num FROM dual;

4852:
4853: -- Check if shipment number already exists for this combination of organizations
4854: IF (ship_id_tbl IS NULL)
4855: THEN
4856: SELECT AHL_SHIPMENT_NUMBER_S.nextval INTO l_shipment_num FROM dual;
4857: ship_id_tbl := Shipping_Id_Tbl_type();
4858: ship_id_tbl.EXTEND;
4859: ship_id_tbl(1).source_org_id := p_x_mtltfr_rec.source_org_id;
4860: ship_id_tbl(1).dest_org_id := p_x_mtltfr_rec.dest_org_id;

Line 4874: SELECT AHL_SHIPMENT_NUMBER_S.nextval INTO l_shipment_num FROM dual;

4870: l_ship_id_present := 'Y';
4871: l_shipment_num := ship_id_tbl(i).shipment_num;
4872: EXIT;
4873: ELSE
4874: SELECT AHL_SHIPMENT_NUMBER_S.nextval INTO l_shipment_num FROM dual;
4875: ship_id_tbl.EXTEND;
4876: ship_id_tbl(i).source_org_id := p_x_mtltfr_rec.source_org_id;
4877: ship_id_tbl(i).dest_org_id := p_x_mtltfr_rec.dest_org_id;
4878: ship_id_tbl(i).shipment_num := l_shipment_num;

Line 6324: SELECT mrp_atp_schedule_temp_s.nextval INTO l_session_id FROM dual;

6320: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
6321: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
6322: FND_MSG_PUB.INITIALIZE;
6323: END IF;
6324: SELECT mrp_atp_schedule_temp_s.nextval INTO l_session_id FROM dual;
6325: -- Get Session ID
6326: SELECT MRP_ATP_SCHEDULE_TEMP_S.NEXTVAL
6327: INTO l_session_id
6328: FROM dual;

Line 6328: FROM dual;

6324: SELECT mrp_atp_schedule_temp_s.nextval INTO l_session_id FROM dual;
6325: -- Get Session ID
6326: SELECT MRP_ATP_SCHEDULE_TEMP_S.NEXTVAL
6327: INTO l_session_id
6328: FROM dual;
6329: OPEN Instance_Id_Cur;
6330: FETCH Instance_Id_Cur INTO l_instance_id;
6331: IF instance_id_cur%notfound THEN
6332: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_ATP_INS_ENABLE' );