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 863: -- p_simulation_plan_rec: the record representing AHL_SIMULATION_PLANS_VL

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

Line 882: FROM AHL_SIMULATION_PLANS_VL

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

Line 1129: FROM ahl_simulation_plans_vl

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

Line 1790: FROM AHL_SIMULATION_PLANS_VL

1786: IF (p_plan_id IS NOT NULL AND
1787: p_plan_id <> FND_API.G_MISS_NUM) THEN
1788: SELECT simulation_plan_id,primary_plan_flag
1789: INTO l_simulation_plan_id, l_plan_flag
1790: FROM AHL_SIMULATION_PLANS_VL
1791: WHERE simulation_plan_id = p_plan_id;
1792: ELSE
1793: Fnd_message.SET_NAME('AHL','AHL_LTP_INVALID_SIMUL_NAME');
1794: Fnd_Msg_Pub.ADD;

Line 1828: AHL_SIMULATION_PLANS_VL WHERE simulation_plan_id = p_plan_id;

1824: END IF;
1825: END IF;
1826: --
1827: SELECT object_version_number INTO l_plan_ovn_number FROM
1828: AHL_SIMULATION_PLANS_VL WHERE simulation_plan_id = p_plan_id;
1829: --Check for plan object version number
1830: IF (p_p_ovn IS NOT NULL AND p_p_ovn <> FND_API.G_MISS_NUM )
1831: THEN
1832: IF p_p_ovn <> l_plan_ovn_number THEN

Line 3005: FROM AHL_SIMULATION_PLANS_VL

3001: IS
3002: SELECT simulation_plan_id,
3003: object_version_number,
3004: primary_plan_flag
3005: FROM AHL_SIMULATION_PLANS_VL
3006: WHERE SIMULATION_PLAN_ID = c_plan_id;
3007: --
3008: CURSOR visit_detail_cur (c_plan_id IN NUMBER)
3009: IS

Line 3282: FROM AHL_SIMULATION_PLANS_VL

3278: --
3279: CURSOR check_primary_cur (c_plan_id IN NUMBER)
3280: IS
3281: SELECT simulation_plan_id
3282: FROM AHL_SIMULATION_PLANS_VL
3283: WHERE simulation_plan_id = c_plan_id
3284: AND primary_plan_flag = 'Y';
3285:
3286: --

Line 3676: FROM AHL_SIMULATION_PLANS_VL

3672: SELECT simulation_plan_id,
3673: primary_plan_flag,
3674: object_version_number INTO
3675: l_simulation_plan_id,l_primary_plan_flag, l_s_object_number
3676: FROM AHL_SIMULATION_PLANS_VL
3677: WHERE simulation_plan_id = p_plan_id
3678: AND primary_plan_flag = 'N';
3679: --
3680: IF l_simulation_plan_id IS NULL THEN

Line 3709: FROM ahl_visits_vl a, ahl_simulation_plans_vl b

3705:
3706: SELECT VISIT_ID,VISIT_NUMBER, a.SIMULATION_PLAN_ID INTO
3707: l_primary_visit_id, l_primary_visit_number,
3708: l_simulation_plan_id
3709: FROM ahl_visits_vl a, ahl_simulation_plans_vl b
3710: WHERE a.visit_id = l_simul_visit_rec.asso_primary_visit_id
3711: and a.simulation_plan_id = b.simulation_plan_id
3712: and b.primary_plan_flag = 'Y';
3713: IF G_DEBUG='Y' THEN

Line 4729: FROM ahl_visits_vl vt, ahl_simulation_plans_vl sp

4725: CURSOR Get_simul_visits_cur (C_VISIT_ID IN NUMBER)
4726: IS
4727: SELECT vt.visit_id, vt.visit_number,
4728: vt.asso_primary_visit_id
4729: FROM ahl_visits_vl vt, ahl_simulation_plans_vl sp
4730: WHERE vt.simulation_plan_id = sp.simulation_plan_id
4731: AND sp.primary_plan_flag = 'N'
4732: AND vt.asso_primary_visit_id = C_VISIT_ID;
4733: -- Get all the associated tasks