eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on AHL_VWP_RULES_PVT

Line 36: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

32: -- START: Defining local functions and procedures SIGNATURES --
33: --------------------------------------------------------------------
34: -- To Check_Visit_Task_Req_Items
35: PROCEDURE Check_Visit_Task_Req_Items (
36: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
37: x_return_status OUT NOCOPY VARCHAR2
38: );
39:
40: -- To Check_Visit_Task_UK_Items

Line 42: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

38: );
39:
40: -- To Check_Visit_Task_UK_Items
41: PROCEDURE Check_Visit_Task_UK_Items (
42: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
43: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
44: x_return_status OUT NOCOPY VARCHAR2
45: );
46:

Line 49: p_Task_rec IN AHL_VWP_RULES_PVT.task_rec_type,

45: );
46:
47: -- To Check_Task_Items
48: PROCEDURE Check_Task_Items (
49: p_Task_rec IN AHL_VWP_RULES_PVT.task_rec_type,
50: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
51: x_return_status OUT NOCOPY VARCHAR2
52: );
53:

Line 72: p_Task_rec IN AHL_VWP_RULES_PVT.task_rec_type,

68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
70: p_commit IN VARCHAR2 := Fnd_Api.g_false,
71: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
72: p_Task_rec IN AHL_VWP_RULES_PVT.task_rec_type,
73: x_return_status OUT NOCOPY VARCHAR2,
74: x_msg_count OUT NOCOPY NUMBER,
75: x_msg_data OUT NOCOPY VARCHAR2
76: );

Line 80: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type

76: );
77: */
78: -- To assign Null to missing attributes of visit while creation/updation.
79: PROCEDURE Default_Missing_Attribs(
80: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type
81: );
82:
83: -- To associated Service Request Or Serial Number to Tasks
84: PROCEDURE Asso_Inst_Dept_to_Tasks (

Line 86: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type

82:
83: -- To associated Service Request Or Serial Number to Tasks
84: PROCEDURE Asso_Inst_Dept_to_Tasks (
85: p_module_type IN VARCHAR2,
86: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type
87: );
88:
89: --------------------------------------------------------------------
90: -- END: Defining local functions and procedures SIGNATURES --

Line 106: ( p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type)

102: -- g_miss_date then Null else the value
103:
104: --------------------------------------------------------------------
105: PROCEDURE Default_Missing_Attribs
106: ( p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type)
107: AS
108: BEGIN
109: IF p_x_task_rec.DURATION = Fnd_Api.G_MISS_NUM THEN
110: p_x_task_rec.DURATION := NULL;

Line 287: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.task_rec_type

283: --------------------------------------------------------------------
284: PROCEDURE Asso_Inst_Dept_to_Tasks
285: (
286: p_module_type IN VARCHAR2,
287: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.task_rec_type
288: )
289: IS
290: L_API_NAME CONSTANT VARCHAR2(30) := 'Asso_Inst_Dept_to_Tasks';
291: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;

Line 326: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id

322:
323: IF c_visit_rec.organization_id IS NOT NULL THEN
324: -- Get dept code using dept description
325: IF (p_x_task_Rec.dept_name IS NOT NULL AND p_x_task_Rec.dept_name <> Fnd_Api.G_MISS_CHAR ) THEN
326: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id
327: (p_organization_id => c_visit_rec.organization_id,
328: p_dept_name => p_x_task_Rec.dept_name,
329: p_department_id => Null,
330: x_department_id => p_x_task_Rec.department_id,

Line 341: AHL_VWP_RULES_PVT.CHECK_DEPARTMENT_SHIFT

337: RAISE Fnd_Api.G_EXC_ERROR;
338: END IF;
339:
340: -- Changes for Post 11.5.10 by amagrawa
341: AHL_VWP_RULES_PVT.CHECK_DEPARTMENT_SHIFT
342: (P_DEPT_ID => p_x_task_Rec.department_id,
343: X_RETURN_STATUS => l_return_status);
344:
345: IF (NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS) THEN

Line 374: AHL_VWP_RULES_PVT.Check_SR_Request_Number_Or_Id

370: END IF; -- End of if visit org exists
371:
372: /*Convert service request number to service request id
373: IF (p_x_task_Rec.service_request_number IS NOT NULL AND p_x_task_Rec.service_request_number <> Fnd_Api.G_MISS_CHAR ) THEN
374: AHL_VWP_RULES_PVT.Check_SR_Request_Number_Or_Id
375: (p_service_id => Null,
376: p_service_number => p_x_task_Rec.service_request_number,
377: x_service_id => p_x_task_Rec.service_request_id,
378: x_return_status => l_return_status,

Line 408: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.task_rec_type,

404: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
405: p_commit IN VARCHAR2 := Fnd_Api.g_false,
406: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
407: p_module_type IN VARCHAR2 := 'JSP',
408: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.task_rec_type,
409: x_return_status OUT NOCOPY VARCHAR2,
410: x_msg_count OUT NOCOPY NUMBER,
411: x_msg_data OUT NOCOPY VARCHAR2
412: )

Line 535: MR_Serial_Tbl AHL_VWP_RULES_PVT.MR_Serial_Tbl_Type;

531: INDEX BY BINARY_INTEGER;
532:
533: -- Table type for storing 'MR_Serial_Rec_Type' record datatype
534: MR_Header_Tbl MR_Header_Tbl_Type;
535: MR_Serial_Tbl AHL_VWP_RULES_PVT.MR_Serial_Tbl_Type;
536:
537: -- To find visit related information
538: CURSOR c_Visit (p_visit_id IN NUMBER) IS
539: SELECT Any_Task_Chg_Flag, Visit_Id

Line 716: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling AHL_VWP_RULES_PVT.Insert_Tasks');

712: FETCH c_item_info INTO l_serial_id,l_service_req_id,l_org_id,l_item_id;
713: CLOSE c_item_info;
714:
715: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
716: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling AHL_VWP_RULES_PVT.Insert_Tasks');
717: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue_id =>' || l_unit_effectivity_id);
718: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || 'null');
719: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);
720: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);

Line 730: AHL_VWP_RULES_PVT.Insert_Tasks

726: FETCH c_task_for_ue INTO l_parent_task_id;
727: /*NR-MR Changes - sowsubra*/
728: --Call Insert_Tasks only if summary task for the SR has not already been created.
729: IF c_task_for_ue%NOTFOUND THEN
730: AHL_VWP_RULES_PVT.Insert_Tasks
731: (p_visit_id => l_visit_id,
732: p_unit_id => l_unit_effectivity_id,
733: p_serial_id => l_serial_id,
734: p_service_id => l_service_req_id,

Line 752: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task');

748: x_msg_data => l_msg_data
749: );
750:
751: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
752: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task');
753: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_return_status' || l_return_status);
754: END IF;
755:
756: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN

Line 796: IF AHL_VWP_RULES_PVT.instance_in_config_tree(l_visit_id, l_serial_id) = FND_API.G_RET_STS_ERROR THEN

792:
793: -- NR-MR Changes - sowsubra
794: -- Done to allow creation of a task for an instance that has already been removed.
795: /***
796: IF AHL_VWP_RULES_PVT.instance_in_config_tree(l_visit_id, l_serial_id) = FND_API.G_RET_STS_ERROR THEN
797: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_SERIAL');
798: Fnd_Msg_Pub.ADD;
799: RAISE Fnd_Api.G_EXC_ERROR;
800: END IF; ***/

Line 804: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task');

800: END IF; ***/
801:
802: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
803: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Inside No Child UEs ELSE BLOCK');
804: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task');
805: END IF;
806:
807: -- Create a Planned Task
808: AHL_VWP_RULES_PVT.Insert_Tasks

Line 808: AHL_VWP_RULES_PVT.Insert_Tasks

804: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task');
805: END IF;
806:
807: -- Create a Planned Task
808: AHL_VWP_RULES_PVT.Insert_Tasks
809: (p_visit_id => l_visit_id,
810: p_unit_id => l_unit_effectivity_id,
811: p_serial_id => l_serial_id,
812: p_service_id => l_service_req_id,

Line 830: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task - l_return_status : '|| l_return_status);

826: x_msg_data => l_msg_data
827: );
828:
829: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
830: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task - l_return_status : '|| l_return_status);
831: END IF;
832:
833: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
834: RAISE Fnd_Api.G_EXC_ERROR;

Line 949: AHL_VWP_RULES_PVT.update_visit_task_flag(

945: OPEN C_VISIT(l_visit_id);
946: fetch c_visit into l_visit_csr_rec;
947: IF C_VISIT%FOUND THEN
948: IF l_visit_csr_rec.Any_Task_Chg_Flag='N' THEN
949: AHL_VWP_RULES_PVT.update_visit_task_flag(
950: p_visit_id =>l_visit_csr_rec.visit_id,
951: p_flag =>'Y',
952: x_return_status =>x_return_status);
953: END IF;

Line 1108: MR_Serial_Tbl AHL_VWP_RULES_PVT.MR_Serial_Tbl_Type;

1104: l_service_request_id NUMBER;
1105:
1106: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || 'CREATE_MR_TASKS';
1107: L_DEBUG CONSTANT VARCHAR2(90) := 'ahl.plsql.'||L_FULL_NAME;
1108: MR_Serial_Tbl AHL_VWP_RULES_PVT.MR_Serial_Tbl_Type;
1109:
1110: BEGIN
1111: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1112: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin', 'At the start of the procedure..');

Line 1142: IF AHL_VWP_RULES_PVT.instance_in_config_tree(p_visit_id, l_serial_id) = FND_API.G_RET_STS_ERROR THEN

1138:
1139: -- NR-MR Changes - sowsubra
1140: -- Done to allow creation of a task for an instance that has already been removed.
1141: /***
1142: IF AHL_VWP_RULES_PVT.instance_in_config_tree(p_visit_id, l_serial_id) = FND_API.G_RET_STS_ERROR THEN
1143: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_SERIAL');
1144: Fnd_Msg_Pub.ADD;
1145: RAISE Fnd_Api.G_EXC_ERROR;
1146: END IF;

Line 1150: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Calling ahl_vwp_rules_pvt.create_tasks_for_mr');

1146: END IF;
1147: ***/
1148:
1149: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1150: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Calling ahl_vwp_rules_pvt.create_tasks_for_mr');
1151: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_visit_id =>' || p_visit_id);
1152: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_serial_id =>' || l_serial_id);
1153: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_mr_id =>' || l_mr_header_id);
1154: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_department_id =>' || l_department_id);

Line 1161: ahl_vwp_rules_pvt.create_tasks_for_mr(p_visit_id => p_visit_id,

1157: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_service_req_id =>' || l_service_request_id);
1158: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_quantity =>' || p_quantity);
1159: END IF;
1160:
1161: ahl_vwp_rules_pvt.create_tasks_for_mr(p_visit_id => p_visit_id,
1162: p_unit_id => l_unit_eff_id,
1163: p_item_id => NULL,
1164: p_org_id => NULL,
1165: p_serial_id => l_serial_id,

Line 1176: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After ahl_vwp_rules_pvt.create_tasks_for_mr');

1172: x_return_status => l_return_status
1173: );
1174:
1175: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1176: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After ahl_vwp_rules_pvt.create_tasks_for_mr');
1177: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_x_parent_MR_Id = ' || l_parent_MR_Id );
1178: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'x_return_status is ' || l_return_status );
1179: END IF;
1180:

Line 1188: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Calling AHL_VWP_RULES_PVT.Tech_Dependency');

1184:
1185: MR_Serial_Tbl(0).MR_ID := l_mr_header_id ;
1186: MR_Serial_Tbl(0).Serial_ID := l_serial_id;
1187: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1188: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Calling AHL_VWP_RULES_PVT.Tech_Dependency');
1189: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'MR_Serial_Tbl(0).MR_ID -->'|| MR_Serial_Tbl(0).MR_ID);
1190: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'MR_Serial_Tbl(0).Serial_ID'|| MR_Serial_Tbl(0).Serial_ID);
1191: END IF;
1192:

Line 1193: AHL_VWP_RULES_PVT.Tech_Dependency

1189: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'MR_Serial_Tbl(0).MR_ID -->'|| MR_Serial_Tbl(0).MR_ID);
1190: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'MR_Serial_Tbl(0).Serial_ID'|| MR_Serial_Tbl(0).Serial_ID);
1191: END IF;
1192:
1193: AHL_VWP_RULES_PVT.Tech_Dependency
1194: (p_visit_id => p_visit_id,
1195: p_task_type => 'PLANNED',
1196: p_MR_Serial_Tbl => MR_Serial_Tbl,
1197: x_return_status => l_return_status

Line 1201: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After AHL_VWP_RULES_PVT.Tech_Dependency - l_return_status : '||l_return_status);

1197: x_return_status => l_return_status
1198: );
1199:
1200: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1201: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After AHL_VWP_RULES_PVT.Tech_Dependency - l_return_status : '||l_return_status);
1202: END IF;
1203:
1204: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
1205: RAISE Fnd_Api.G_EXC_ERROR;

Line 1281: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,

1277: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
1278: p_commit IN VARCHAR2 := Fnd_Api.g_false,
1279: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
1280: p_module_type IN VARCHAR2 := 'JSP',
1281: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
1282: x_return_status OUT NOCOPY VARCHAR2,
1283: x_msg_count OUT NOCOPY NUMBER,
1284: x_msg_data OUT NOCOPY VARCHAR2
1285: )

Line 1293: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := p_x_task_rec;

1289: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;
1290: L_DEBUG CONSTANT VARCHAR2(90) := 'ahl.plsql.'||L_FULL_NAME;
1291:
1292: -- local variables defined for the procedure
1293: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := p_x_task_rec;
1294: l_return_status VARCHAR2(1);
1295: l_msg_data VARCHAR2(2000);
1296: l_planned_order_flag VARCHAR2(1);
1297: l_msg_count NUMBER;

Line 1368: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id

1364: -- For DEPARTMENT
1365: -- Convert department name to department id
1366: IF (l_task_rec.dept_name IS NOT NULL AND l_task_rec.dept_name <> Fnd_Api.G_MISS_CHAR ) THEN
1367:
1368: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id
1369: (p_organization_id => c_visit_rec.organization_id,
1370: p_dept_name => l_task_rec.dept_name,
1371: p_department_id => NULL,
1372: x_department_id => l_department_id,

Line 1398: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID

1394: -- Convert cost parent number to id
1395: IF (l_Task_rec.cost_parent_number IS NOT NULL AND
1396: l_Task_rec.cost_parent_number <> Fnd_Api.G_MISS_NUM ) THEN
1397:
1398: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID
1399: (p_visit_task_id => l_Task_rec.cost_parent_id,
1400: p_visit_task_number => l_Task_rec.cost_parent_number,
1401: p_visit_id => l_Task_rec.visit_id,
1402: x_visit_task_id => l_cost_parent_id,

Line 1426: AHL_VWP_RULES_PVT.Check_Cost_Parent_Loop

1422: -- To Check for cost parent task id not forming loop
1423: IF (l_Task_rec.cost_parent_id IS NOT NULL AND
1424: l_Task_rec.cost_parent_id <> Fnd_Api.G_MISS_NUM ) THEN
1425:
1426: AHL_VWP_RULES_PVT.Check_Cost_Parent_Loop
1427: (p_visit_id => l_Task_rec.visit_id,
1428: p_visit_task_id => l_Task_rec.visit_task_id ,
1429: p_cost_parent_id => l_Task_rec.cost_parent_id
1430: );

Line 1635: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag

1631: END IF;
1632: END IF;
1633:
1634: IF c_visit_rec.any_task_chg_flag = 'N' THEN
1635: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag
1636: (p_visit_id => l_task_rec.visit_id,
1637: p_flag => 'Y',
1638: x_return_status => x_return_status);
1639: END IF;

Line 1857: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

1853: -- PURPOSE
1854: --
1855: ---------------------------------------------------------------------
1856: PROCEDURE Check_Task_Items (
1857: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
1858: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
1859:
1860: x_return_status OUT NOCOPY VARCHAR2
1861: )

Line 1918: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

1914: --
1915: ---------------------------------------------------------------------
1916: /* It doesn't seem to be used anywhere
1917: PROCEDURE Complete_Visit_Task_Rec (
1918: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
1919: x_complete_rec OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type
1920: )
1921: IS
1922: CURSOR c_Visit_Task IS

Line 1919: x_complete_rec OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type

1915: ---------------------------------------------------------------------
1916: /* It doesn't seem to be used anywhere
1917: PROCEDURE Complete_Visit_Task_Rec (
1918: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
1919: x_complete_rec OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type
1920: )
1921: IS
1922: CURSOR c_Visit_Task IS
1923: SELECT *

Line 1955: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

1951: -- PURPOSE
1952: --
1953: ---------------------------------------------------------------------
1954: PROCEDURE Check_Visit_Task_Req_Items (
1955: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
1956: x_return_status OUT NOCOPY VARCHAR2
1957: )
1958: IS
1959: l_api_name CONSTANT VARCHAR2(30) := 'Check_Visit_Task_Req_Items';

Line 2002: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

1998: -- PURPOSE
1999: --
2000: ---------------------------------------------------------------------
2001: PROCEDURE Check_Visit_Task_UK_Items (
2002: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
2003: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
2004: x_return_status OUT NOCOPY VARCHAR2
2005: )
2006: IS