APPS.AHL_LTP_SIMUL_PLAN_PVT dependencies on AHL_SIMULATION_PLANS_VL

Line 15: -- AHL_SIMULATION_PLANS_VL:

11: -- PURPOSE
12: -- This package is a Private API for managing Simulation plans information in
13: -- Advanced Services Online. It contains specification for pl/sql records and tables
14: --
15: -- AHL_SIMULATION_PLANS_VL:
16: -- Create_Simulation_plan (see below for specification)
17: -- Update_Simulation_plan (see below for specification)
18: -- Delete_Simulation_plan (see below for specification)
19: -- Validate_Simulation_plan (see below for specification)

Line 51: FROM AHL_SIMULATION_PLANS_VL

47: IF (p_simulation_plan_id IS NOT NULL)
48: THEN
49: SELECT simulation_plan_id
50: INTO x_plan_id
51: FROM AHL_SIMULATION_PLANS_VL
52: WHERE simulation_plan_id = p_simulation_plan_id;
53: ELSE
54: SELECT simulation_plan_id
55: INTO x_plan_id

Line 56: FROM AHL_SIMULATION_PLANS_VL

52: WHERE simulation_plan_id = p_simulation_plan_id;
53: ELSE
54: SELECT simulation_plan_id
55: INTO x_plan_id
56: FROM AHL_SIMULATION_PLANS_VL
57: WHERE SIMULATION_PLAN_NAME = p_plan_name;
58: END IF;
59: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
60: EXCEPTION

Line 147: FROM ahl_simulation_plans_vl

143: ATTRIBUTE12,
144: ATTRIBUTE13,
145: ATTRIBUTE14,
146: ATTRIBUTE15
147: FROM ahl_simulation_plans_vl
148: WHERE simulation_plan_id = p_simulation_rec.simulation_plan_id;
149: --
150: -- This is the only exception for using %ROWTYPE.
151: l_simulation_rec c_simulation_rec%ROWTYPE;

Line 346: AHL_SIMULATION_PLANS_VL

342: --
343: CURSOR check_plan_name_cur (c_plan_name IN VARCHAR2)
344: IS
345: SELECT 1 FROM
346: AHL_SIMULATION_PLANS_VL
347: WHERE simulation_plan_name = c_plan_name
348: AND primary_plan_flag = 'N';
349:
350:

Line 530: -- p_x_simulation_plan_rec: the record representing AHL_SIMULATION_PLANS_VL view..

526: -- PURPOSE
527: -- Create Simulation plan Record
528: --
529: -- PARAMETERS
530: -- p_x_simulation_plan_rec: the record representing AHL_SIMULATION_PLANS_VL view..
531: --
532: -- NOTES
533: --------------------------------------------------------------------
534:

Line 861: -- p_simulation_plan_rec: the record representing AHL_SIMULATION_PLANS_VL

857: -- PURPOSE
858: -- Update Simulation plan Record.
859: --
860: -- PARAMETERS
861: -- p_simulation_plan_rec: the record representing AHL_SIMULATION_PLANS_VL
862: --
863: -- NOTES
864: --------------------------------------------------------------------
865: PROCEDURE Update_Simulation_plan (

Line 880: FROM AHL_SIMULATION_PLANS_VL

876: IS
877: CURSOR primary_plan_cur(c_plan_id IN NUMBER)
878: IS
879: SELECT primary_plan_flag
880: FROM AHL_SIMULATION_PLANS_VL
881: WHERE simulation_plan_id = c_plan_id;
882:
883: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_SIMULATION_PLAN';
884: l_api_version CONSTANT NUMBER := 1.0;

Line 1125: FROM ahl_simulation_plans_vl

1121: (c_simulation_plan_id IN NUMBER)
1122: IS
1123: SELECT simulation_plan_id,object_version_number,
1124: primary_plan_flag
1125: FROM ahl_simulation_plans_vl
1126: WHERE simulation_plan_id = c_simulation_plan_id
1127: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1128:
1129: -- Added by mpothuku on 12/22/04 to retrieve the associated simulation visits.

Line 1774: FROM AHL_SIMULATION_PLANS_VL

1770: IF (p_plan_id IS NOT NULL AND
1771: p_plan_id <> FND_API.G_MISS_NUM) THEN
1772: SELECT simulation_plan_id,primary_plan_flag
1773: INTO l_simulation_plan_id, l_plan_flag
1774: FROM AHL_SIMULATION_PLANS_VL
1775: WHERE simulation_plan_id = p_plan_id;
1776: ELSE
1777: Fnd_message.SET_NAME('AHL','AHL_LTP_INVALID_SIMUL_NAME');
1778: Fnd_Msg_Pub.ADD;

Line 1812: AHL_SIMULATION_PLANS_VL WHERE simulation_plan_id = p_plan_id;

1808: END IF;
1809: END IF;
1810: --
1811: SELECT object_version_number INTO l_plan_ovn_number FROM
1812: AHL_SIMULATION_PLANS_VL WHERE simulation_plan_id = p_plan_id;
1813: --Check for plan object version number
1814: IF (p_p_ovn IS NOT NULL AND p_p_ovn <> FND_API.G_MISS_NUM )
1815: THEN
1816: IF p_p_ovn <> l_plan_ovn_number THEN

Line 2965: FROM AHL_SIMULATION_PLANS_VL

2961: IS
2962: SELECT simulation_plan_id,
2963: object_version_number,
2964: primary_plan_flag
2965: FROM AHL_SIMULATION_PLANS_VL
2966: WHERE SIMULATION_PLAN_ID = c_plan_id;
2967: --
2968: CURSOR visit_detail_cur (c_plan_id IN NUMBER)
2969: IS

Line 3242: FROM AHL_SIMULATION_PLANS_VL

3238: --
3239: CURSOR check_primary_cur (c_plan_id IN NUMBER)
3240: IS
3241: SELECT simulation_plan_id
3242: FROM AHL_SIMULATION_PLANS_VL
3243: WHERE simulation_plan_id = c_plan_id
3244: AND primary_plan_flag = 'Y';
3245:
3246: --

Line 3630: FROM AHL_SIMULATION_PLANS_VL

3626: SELECT simulation_plan_id,
3627: primary_plan_flag,
3628: object_version_number INTO
3629: l_simulation_plan_id,l_primary_plan_flag, l_s_object_number
3630: FROM AHL_SIMULATION_PLANS_VL
3631: WHERE simulation_plan_id = p_plan_id
3632: AND primary_plan_flag = 'N';
3633: --
3634: IF l_simulation_plan_id IS NULL THEN

Line 3663: FROM ahl_visits_vl a, ahl_simulation_plans_vl b

3659:
3660: SELECT VISIT_ID,VISIT_NUMBER, a.SIMULATION_PLAN_ID INTO
3661: l_primary_visit_id, l_primary_visit_number,
3662: l_simulation_plan_id
3663: FROM ahl_visits_vl a, ahl_simulation_plans_vl b
3664: WHERE a.visit_id = l_simul_visit_rec.asso_primary_visit_id
3665: and a.simulation_plan_id = b.simulation_plan_id
3666: and b.primary_plan_flag = 'Y';
3667: IF G_DEBUG='Y' THEN

Line 4665: FROM ahl_visits_vl vt, ahl_simulation_plans_vl sp

4661: CURSOR Get_simul_visits_cur (C_VISIT_ID IN NUMBER)
4662: IS
4663: SELECT vt.visit_id, vt.visit_number,
4664: vt.asso_primary_visit_id
4665: FROM ahl_visits_vl vt, ahl_simulation_plans_vl sp
4666: WHERE vt.simulation_plan_id = sp.simulation_plan_id
4667: AND sp.primary_plan_flag = 'N'
4668: AND vt.asso_primary_visit_id = C_VISIT_ID;
4669: -- Get all the associated tasks