1081: -- Parameters :
1082: --
1083: -- Standard IN Parameters :
1084: -- p_api_version IN NUMBER Required
1085: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1086: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1087: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1088: --
1089: -- Standard OUT Parameters :
1082: --
1083: -- Standard IN Parameters :
1084: -- p_api_version IN NUMBER Required
1085: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1086: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1087: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1088: --
1089: -- Standard OUT Parameters :
1090: -- x_return_status OUT VARCHAR2 Required
1083: -- Standard IN Parameters :
1084: -- p_api_version IN NUMBER Required
1085: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1086: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1087: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1088: --
1089: -- Standard OUT Parameters :
1090: -- x_return_status OUT VARCHAR2 Required
1091: -- x_msg_count OUT NUMBER Required
1100: -- Initial Version 1.0
1101: -------------------------------------------------------------------
1102: PROCEDURE Handle_Task_Dependency (
1103: p_api_version IN NUMBER,
1104: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
1105: p_commit IN VARCHAR2 := Fnd_Api.g_false,
1106: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
1107:
1108: p_visit_id IN NUMBER,
1101: -------------------------------------------------------------------
1102: PROCEDURE Handle_Task_Dependency (
1103: p_api_version IN NUMBER,
1104: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
1105: p_commit IN VARCHAR2 := Fnd_Api.g_false,
1106: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
1107:
1108: p_visit_id IN NUMBER,
1109: p_task_tbl IN AHL_VWP_RULES_PVT.Task_Tbl_Type,
1102: PROCEDURE Handle_Task_Dependency (
1103: p_api_version IN NUMBER,
1104: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
1105: p_commit IN VARCHAR2 := Fnd_Api.g_false,
1106: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
1107:
1108: p_visit_id IN NUMBER,
1109: p_task_tbl IN AHL_VWP_RULES_PVT.Task_Tbl_Type,
1110:
1119:
1120: --SKPATHAK :: 02-MAY-2011 :: VWPE :: start
1121: PROCEDURE Warranty_Not_Applicable (
1122: p_api_version IN NUMBER,
1123: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
1124: p_commit IN VARCHAR2 := Fnd_Api.g_false,
1125: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
1126: p_task_tbl IN Task_Tbl_Type,
1127: x_return_status OUT NOCOPY VARCHAR2,
1120: --SKPATHAK :: 02-MAY-2011 :: VWPE :: start
1121: PROCEDURE Warranty_Not_Applicable (
1122: p_api_version IN NUMBER,
1123: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
1124: p_commit IN VARCHAR2 := Fnd_Api.g_false,
1125: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
1126: p_task_tbl IN Task_Tbl_Type,
1127: x_return_status OUT NOCOPY VARCHAR2,
1128: x_msg_count OUT NOCOPY NUMBER,
1121: PROCEDURE Warranty_Not_Applicable (
1122: p_api_version IN NUMBER,
1123: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
1124: p_commit IN VARCHAR2 := Fnd_Api.g_false,
1125: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
1126: p_task_tbl IN Task_Tbl_Type,
1127: x_return_status OUT NOCOPY VARCHAR2,
1128: x_msg_count OUT NOCOPY NUMBER,
1129: x_msg_data OUT NOCOPY VARCHAR2
1138: -- Parameters :
1139: --
1140: -- Standard IN Parameters :
1141: -- p_api_version IN NUMBER Required
1142: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1143: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1144: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1145: -- Standard OUT Parameters :
1146: -- x_return_status OUT VARCHAR2 Required
1139: --
1140: -- Standard IN Parameters :
1141: -- p_api_version IN NUMBER Required
1142: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1143: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1144: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1145: -- Standard OUT Parameters :
1146: -- x_return_status OUT VARCHAR2 Required
1147: -- x_msg_count OUT NUMBER Required
1140: -- Standard IN Parameters :
1141: -- p_api_version IN NUMBER Required
1142: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1143: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1144: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1145: -- Standard OUT Parameters :
1146: -- x_return_status OUT VARCHAR2 Required
1147: -- x_msg_count OUT NUMBER Required
1148: -- x_msg_data OUT VARCHAR2 Required
1153: -- Initial Version 1.0
1154: -------------------------------------------------------------------
1155: PROCEDURE Add_Return_To_Supply (
1156: p_api_version IN NUMBER,
1157: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1158: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1160: p_task_tbl_type IN AHL_VWP_RULES_PVT.Task_Tbl_Type,
1161: x_return_status OUT NOCOPY VARCHAR2,
1154: -------------------------------------------------------------------
1155: PROCEDURE Add_Return_To_Supply (
1156: p_api_version IN NUMBER,
1157: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1158: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1160: p_task_tbl_type IN AHL_VWP_RULES_PVT.Task_Tbl_Type,
1161: x_return_status OUT NOCOPY VARCHAR2,
1162: x_msg_count OUT NOCOPY NUMBER,
1155: PROCEDURE Add_Return_To_Supply (
1156: p_api_version IN NUMBER,
1157: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1158: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1160: p_task_tbl_type IN AHL_VWP_RULES_PVT.Task_Tbl_Type,
1161: x_return_status OUT NOCOPY VARCHAR2,
1162: x_msg_count OUT NOCOPY NUMBER,
1163: x_msg_data OUT NOCOPY VARCHAR2
1170: -- Parameters :
1171: --
1172: -- Standard IN Parameters :
1173: -- p_api_version IN NUMBER Required
1174: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1175: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1176: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1177: -- Standard OUT Parameters :
1178: -- x_return_status OUT VARCHAR2 Required
1171: --
1172: -- Standard IN Parameters :
1173: -- p_api_version IN NUMBER Required
1174: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1175: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1176: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1177: -- Standard OUT Parameters :
1178: -- x_return_status OUT VARCHAR2 Required
1179: -- x_msg_count OUT NUMBER Required
1172: -- Standard IN Parameters :
1173: -- p_api_version IN NUMBER Required
1174: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1175: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1176: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1177: -- Standard OUT Parameters :
1178: -- x_return_status OUT VARCHAR2 Required
1179: -- x_msg_count OUT NUMBER Required
1180: -- x_msg_data OUT VARCHAR2 Required
1185: -- Initial Version 1.0
1186: -------------------------------------------------------------------
1187: PROCEDURE Remove_Return_To_Supply (
1188: p_api_version IN NUMBER,
1189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1192: p_task_tbl_type IN AHL_VWP_RULES_PVT.Task_Tbl_Type,
1193: x_return_status OUT NOCOPY VARCHAR2,
1186: -------------------------------------------------------------------
1187: PROCEDURE Remove_Return_To_Supply (
1188: p_api_version IN NUMBER,
1189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1192: p_task_tbl_type IN AHL_VWP_RULES_PVT.Task_Tbl_Type,
1193: x_return_status OUT NOCOPY VARCHAR2,
1194: x_msg_count OUT NOCOPY NUMBER,
1187: PROCEDURE Remove_Return_To_Supply (
1188: p_api_version IN NUMBER,
1189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1192: p_task_tbl_type IN AHL_VWP_RULES_PVT.Task_Tbl_Type,
1193: x_return_status OUT NOCOPY VARCHAR2,
1194: x_msg_count OUT NOCOPY NUMBER,
1195: x_msg_data OUT NOCOPY VARCHAR2
1202: -- Parameters :
1203: --
1204: -- Standard IN Parameters :
1205: -- p_api_version IN NUMBER Required
1206: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1207: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1208: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1209: -- p_module_type IN VARCHAR2 Required
1210: -- Standard OUT Parameters :
1203: --
1204: -- Standard IN Parameters :
1205: -- p_api_version IN NUMBER Required
1206: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1207: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1208: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1209: -- p_module_type IN VARCHAR2 Required
1210: -- Standard OUT Parameters :
1211: -- x_return_status OUT VARCHAR2 Required
1204: -- Standard IN Parameters :
1205: -- p_api_version IN NUMBER Required
1206: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1207: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1208: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1209: -- p_module_type IN VARCHAR2 Required
1210: -- Standard OUT Parameters :
1211: -- x_return_status OUT VARCHAR2 Required
1212: -- x_msg_count OUT NUMBER Required
1218: -- Initial Version 1.0
1219: -------------------------------------------------------------------
1220: PROCEDURE Validate_Return_To_Supply (
1221: p_api_version IN NUMBER,
1222: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1223: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1224: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1225: p_module_type IN VARCHAR2,
1226: p_visit_id IN NUMBER,
1219: -------------------------------------------------------------------
1220: PROCEDURE Validate_Return_To_Supply (
1221: p_api_version IN NUMBER,
1222: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1223: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1224: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1225: p_module_type IN VARCHAR2,
1226: p_visit_id IN NUMBER,
1227: p_tasks_tbl IN Task_Tbl_Type,
1220: PROCEDURE Validate_Return_To_Supply (
1221: p_api_version IN NUMBER,
1222: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1223: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1224: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1225: p_module_type IN VARCHAR2,
1226: p_visit_id IN NUMBER,
1227: p_tasks_tbl IN Task_Tbl_Type,
1228: x_return_status OUT NOCOPY VARCHAR2,
1241: -- Parameters :
1242: --
1243: -- Standard IN Parameters :
1244: -- p_api_version IN NUMBER Required
1245: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1246: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1247: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1248: -- p_module_type IN VARCHAR2 Default NULL
1249: -- Standard OUT Parameters :
1242: --
1243: -- Standard IN Parameters :
1244: -- p_api_version IN NUMBER Required
1245: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1246: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1247: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1248: -- p_module_type IN VARCHAR2 Default NULL
1249: -- Standard OUT Parameters :
1250: -- x_return_status OUT VARCHAR2 Required
1243: -- Standard IN Parameters :
1244: -- p_api_version IN NUMBER Required
1245: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1246: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1247: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1248: -- p_module_type IN VARCHAR2 Default NULL
1249: -- Standard OUT Parameters :
1250: -- x_return_status OUT VARCHAR2 Required
1251: -- x_msg_count OUT NUMBER Required
1258: -------------------------------------------------------------------
1259: PROCEDURE Flag_Duplicate_Task
1260: (
1261: p_api_version IN NUMBER,
1262: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
1263: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
1264: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
1265: p_module_type IN VARCHAR2 := NULL,
1266: p_task_rec_tbl IN AHL_VWP_RULES_PVT.Task_Tbl_Type,
1259: PROCEDURE Flag_Duplicate_Task
1260: (
1261: p_api_version IN NUMBER,
1262: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
1263: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
1264: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
1265: p_module_type IN VARCHAR2 := NULL,
1266: p_task_rec_tbl IN AHL_VWP_RULES_PVT.Task_Tbl_Type,
1267: x_return_status OUT NOCOPY VARCHAR2,
1260: (
1261: p_api_version IN NUMBER,
1262: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
1263: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
1264: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
1265: p_module_type IN VARCHAR2 := NULL,
1266: p_task_rec_tbl IN AHL_VWP_RULES_PVT.Task_Tbl_Type,
1267: x_return_status OUT NOCOPY VARCHAR2,
1268: x_msg_count OUT NOCOPY NUMBER,
1274: -- Parameters :
1275: --
1276: -- Standard IN Parameters :
1277: -- p_api_version IN NUMBER Required
1278: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1279: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1280: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1281: -- p_module_type IN VARCHAR2 Default NULL
1282: -- Standard OUT Parameters :
1275: --
1276: -- Standard IN Parameters :
1277: -- p_api_version IN NUMBER Required
1278: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1279: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1280: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1281: -- p_module_type IN VARCHAR2 Default NULL
1282: -- Standard OUT Parameters :
1283: -- x_return_status OUT VARCHAR2 Required
1276: -- Standard IN Parameters :
1277: -- p_api_version IN NUMBER Required
1278: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1279: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1280: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1281: -- p_module_type IN VARCHAR2 Default NULL
1282: -- Standard OUT Parameters :
1283: -- x_return_status OUT VARCHAR2 Required
1284: -- x_msg_count OUT NUMBER Required
1291: -------------------------------------------------------------------
1292: PROCEDURE Remove_Duplicate_Task_Flag
1293: (
1294: p_api_version IN NUMBER,
1295: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
1296: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
1297: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
1298: p_module_type IN VARCHAR2 := NULL,
1299: p_task_rec_tbl IN AHL_VWP_RULES_PVT.Task_Tbl_Type,
1292: PROCEDURE Remove_Duplicate_Task_Flag
1293: (
1294: p_api_version IN NUMBER,
1295: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
1296: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
1297: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
1298: p_module_type IN VARCHAR2 := NULL,
1299: p_task_rec_tbl IN AHL_VWP_RULES_PVT.Task_Tbl_Type,
1300: x_return_status OUT NOCOPY VARCHAR2,
1293: (
1294: p_api_version IN NUMBER,
1295: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
1296: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
1297: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
1298: p_module_type IN VARCHAR2 := NULL,
1299: p_task_rec_tbl IN AHL_VWP_RULES_PVT.Task_Tbl_Type,
1300: x_return_status OUT NOCOPY VARCHAR2,
1301: x_msg_count OUT NOCOPY NUMBER,
1309: -- Parameters :
1310: --
1311: -- Standard IN Parameters :
1312: -- p_api_version IN NUMBER Required
1313: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1314: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1315: --
1316: -- Standard OUT Parameters :
1317: -- x_return_status OUT VARCHAR2 Required
1310: --
1311: -- Standard IN Parameters :
1312: -- p_api_version IN NUMBER Required
1313: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1314: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1315: --
1316: -- Standard OUT Parameters :
1317: -- x_return_status OUT VARCHAR2 Required
1318: -- x_msg_count OUT NUMBER Required
1322: -- p_ue_id IN NUMBER Required
1323: --------------------------------------------------------------------------------------------------------------------
1324: PROCEDURE Cancel_Planning_tasks (
1325: p_api_version IN NUMBER,
1326: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1327: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1328: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1329: p_ue_id IN NUMBER,
1330: x_return_status OUT NOCOPY VARCHAR2,
1323: --------------------------------------------------------------------------------------------------------------------
1324: PROCEDURE Cancel_Planning_tasks (
1325: p_api_version IN NUMBER,
1326: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1327: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1328: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1329: p_ue_id IN NUMBER,
1330: x_return_status OUT NOCOPY VARCHAR2,
1331: x_msg_count OUT NOCOPY NUMBER,
1324: PROCEDURE Cancel_Planning_tasks (
1325: p_api_version IN NUMBER,
1326: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1327: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1328: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1329: p_ue_id IN NUMBER,
1330: x_return_status OUT NOCOPY VARCHAR2,
1331: x_msg_count OUT NOCOPY NUMBER,
1332: x_msg_data OUT NOCOPY VARCHAR2);