APPS.AHL_VWP_TASKS_PUB dependencies on AHL_VWP_RULES_PVT

Line 12: p_x_tasks_tbl IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Tbl_Type);

8: p_visit_id IN NUMBER,
9: p_visit_number IN NUMBER,
10: p_department_id IN NUMBER,
11: p_department_code IN VARCHAR2,
12: p_x_tasks_tbl IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Tbl_Type);
13:
14:
15: -------------------------------------------------------------------------------------------
16: -- Start of Comments

Line 28: -- p_x_tasks_tbl IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Tbl_Type

24: -- p_visit_id IN NUMBER := null Not needed if p_visit_number is given
25: -- p_visit_number IN NUMBER := null Ignored if p_visit_id is given
26: -- p_department_id IN NUMBER := null Not needed if p_department_code is given
27: -- p_department_code IN VARCHAR2 := null Ignored if p_department_id is given
28: -- p_x_tasks_tbl IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Tbl_Type
29: -- UNIT_EFFECTIVITY_ID is Mandatory
30: -- ATTRIBUTE_CATEGORY is Optional
31: -- ATTRIBUTE1..ATTRIBUTE15 are Optional
32: -- All others input attributes are ignored

Line 46: p_x_tasks_tbl IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Tbl_Type,

42: p_visit_id IN NUMBER := null, -- Not needed if p_visit_number is given
43: p_visit_number IN NUMBER := null, -- Ignored if p_visit_id is given
44: p_department_id IN NUMBER := null, -- Not needed if p_department_code is given
45: p_department_code IN VARCHAR2 := null, -- Ignored if p_department_id is given
46: p_x_tasks_tbl IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Tbl_Type,
47: x_return_status OUT NOCOPY VARCHAR2,
48: x_msg_count OUT NOCOPY NUMBER,
49: x_msg_data OUT NOCOPY VARCHAR2
50: ) IS

Line 176: p_x_tasks_tbl IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Tbl_Type

172: p_visit_id IN NUMBER,
173: p_visit_number IN NUMBER,
174: p_department_id IN NUMBER,
175: p_department_code IN VARCHAR2,
176: p_x_tasks_tbl IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Tbl_Type
177: ) IS
178:
179: l_api_name CONSTANT VARCHAR2(30) := 'Validate_And_Prepare_Params';
180: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;

Line 185: l_source_rec AHL_VWP_RULES_PVT.Task_Rec_Type;

181: l_visit_id NUMBER;
182: l_dept_id NUMBER;
183: l_org_id NUMBER := NULL;
184: l_valid_flag BOOLEAN := true;
185: l_source_rec AHL_VWP_RULES_PVT.Task_Rec_Type;
186: l_dest_rec AHL_VWP_RULES_PVT.Task_Rec_Type;
187: l_index NUMBER;
188: l_temp_num NUMBER;
189:

Line 186: l_dest_rec AHL_VWP_RULES_PVT.Task_Rec_Type;

182: l_dept_id NUMBER;
183: l_org_id NUMBER := NULL;
184: l_valid_flag BOOLEAN := true;
185: l_source_rec AHL_VWP_RULES_PVT.Task_Rec_Type;
186: l_dest_rec AHL_VWP_RULES_PVT.Task_Rec_Type;
187: l_index NUMBER;
188: l_temp_num NUMBER;
189:
190: CURSOR validate_visit_id_csr(c_visit_id IN NUMBER) IS