APPS.AHL_VWP_RULES_PVT dependencies on AHL_VISITS_B

Line 110: FROM ahl_visits_b

106: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
107:
108: CURSOR get_visit_instance IS
109: SELECT item_instance_id
110: FROM ahl_visits_b
111: WHERE visit_id = p_visit_id;
112: CURSOR check_instance_in_tree(c_top_instance_id NUMBER, c_instance_id NUMBER) IS
113: SELECT subject_id
114: FROM csi_ii_relationships

Line 668: FROM ahl_visits_b

664: SELECT 'x'
665: FROM ahl_simulation_plans_vl ASP
666: WHERE primary_plan_flag = 'Y'
667: AND EXISTS ( SELECT 1
668: FROM ahl_visits_b
669: WHERE visit_id = x_id
670: AND NVL(simulation_plan_id,-99) = ASP.simulation_plan_id);
671: */
672: BEGIN

Line 2515: UPDATE AHL_VISITS_B

2511: 'p_flag' || p_flag);
2512: END IF;
2513: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2514: IF p_visit_id IS NOT NULL THEN
2515: UPDATE AHL_VISITS_B
2516: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
2517: ANY_TASK_CHG_FLAG = p_flag
2518: WHERE VISIT_ID = p_visit_id;
2519: END IF;

Line 2545: SELECT service_request_id FROM ahl_visits_b

2541: L_API_NAME CONSTANT VARCHAR2(30) := 'Check_Price_List_Name_Or_Id';
2542: L_DEBUG_KEY CONSTANT VARCHAR2(100):= 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
2543:
2544: CURSOR visit_info_csr(p_visit_id IN NUMBER)IS
2545: SELECT service_request_id FROM ahl_visits_b
2546: WHERE visit_id = p_visit_id;
2547:
2548: l_service_request_id NUMBER;
2549:

Line 2608: 'Visit id not found in AHL_VISITS_B table');

2604: FND_MSG_PUB.ADD;
2605: IF (l_log_unexpected >= l_log_current_level)THEN
2606: fnd_log.string(l_log_unexpected,
2607: L_DEBUG_KEY,
2608: 'Visit id not found in AHL_VISITS_B table');
2609: END IF;
2610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2611: ELSIF(l_service_request_id IS NULL)THEN
2612: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT_UPDT_NOS');

Line 2939: SELECT VST.organization_id FROM AHL_VISITS_B VST

2935: L_API_NAME CONSTANT VARCHAR2(30) := 'Check_Currency_for_Costing';
2936: L_DEBUG_KEY CONSTANT VARCHAR2(100):= 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
2937:
2938: CURSOR organization_csr(p_visit_id IN NUMBER)IS
2939: SELECT VST.organization_id FROM AHL_VISITS_B VST
2940: WHERE VST.visit_id = p_visit_id;
2941:
2942: l_org_id NUMBER;
2943:

Line 2954: FROM CST_ORGANIZATION_DEFINITIONS COD --,AHL_VISITS_B VST

2950: AND NVL(operating_unit, mo_global.get_current_org_id())= mo_global.get_current_org_id();
2951:
2952: /*SELECT currency_code
2953: -- into x_currency_code
2954: FROM CST_ORGANIZATION_DEFINITIONS COD --,AHL_VISITS_B VST
2955: WHERE --VST.visit_id = p_visit_id AND
2956: --COD.Organization_Id = VST.organization_id
2957: COD.Organization_Id = p_org_id
2958: AND NVL(operating_unit, mo_global.get_current_org_id())