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.GMO_VBATCH_PVT dependencies on GMO_CONSTANTS_GRP

Line 70: l_locked := GMO_CONSTANTS_GRP.NO;

66: close is_step_locked_by_user;
67: END IF;
68:
69: IF (l_count = 0) THEN
70: l_locked := GMO_CONSTANTS_GRP.NO;
71: ELSE
72: l_locked := GMO_CONSTANTS_GRP.YES;
73: END IF;
74:

Line 72: l_locked := GMO_CONSTANTS_GRP.YES;

68:
69: IF (l_count = 0) THEN
70: l_locked := GMO_CONSTANTS_GRP.NO;
71: ELSE
72: l_locked := GMO_CONSTANTS_GRP.YES;
73: END IF;
74:
75: return l_locked;
76:

Line 86: IF (P_VBATCH_MODE = GMO_CONSTANTS_GRP.VBATCH_ADMIN_MODE) then

82: IS
83: l_locked varchar2(1);
84:
85: BEGIN
86: IF (P_VBATCH_MODE = GMO_CONSTANTS_GRP.VBATCH_ADMIN_MODE) then
87: l_locked := IS_STEP_LOCKED (P_BATCHSTEP_ID => P_BATCHSTEP_ID);
88: else
89: l_locked := IS_STEP_LOCKED (P_BATCHSTEP_ID => P_BATCHSTEP_ID, P_REQUESTER => P_REQUESTER);
90: end if;

Line 298: l_material_available := GMO_CONSTANTS_GRP.NO;

294: end if;
295: end loop;
296:
297: if (l_material_unavailable > 0) then
298: l_material_available := GMO_CONSTANTS_GRP.NO;
299: else
300: l_material_available := GMO_CONSTANTS_GRP.YES;
301: end if;
302:

Line 300: l_material_available := GMO_CONSTANTS_GRP.YES;

296:
297: if (l_material_unavailable > 0) then
298: l_material_available := GMO_CONSTANTS_GRP.NO;
299: else
300: l_material_available := GMO_CONSTANTS_GRP.YES;
301: end if;
302:
303: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
304:

Line 701: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_BATCH) THEN

697: NO_BATCH_FOUND_ERR exception;
698:
699: BEGIN
700:
701: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_BATCH) THEN
702: l_batch_id := to_number (P_ENTITY_KEY);
703: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN
704: open get_batch_id_for_step;
705: fetch get_batch_id_for_step into l_batch_id;

Line 703: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN

699: BEGIN
700:
701: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_BATCH) THEN
702: l_batch_id := to_number (P_ENTITY_KEY);
703: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN
704: open get_batch_id_for_step;
705: fetch get_batch_id_for_step into l_batch_id;
706: close get_batch_id_for_step;
707: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN

Line 707: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN

703: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN
704: open get_batch_id_for_step;
705: fetch get_batch_id_for_step into l_batch_id;
706: close get_batch_id_for_step;
707: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN
708: open get_batch_id_for_activity;
709: fetch get_batch_id_for_activity into l_batch_id;
710: close get_batch_id_for_activity;
711: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN

Line 711: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN

707: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN
708: open get_batch_id_for_activity;
709: fetch get_batch_id_for_activity into l_batch_id;
710: close get_batch_id_for_activity;
711: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN
712: open get_batch_id_for_resource;
713: fetch get_batch_id_for_resource into l_batch_id;
714: close get_batch_id_for_resource;
715: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_MATERIAL) THEN

Line 715: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_MATERIAL) THEN

711: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN
712: open get_batch_id_for_resource;
713: fetch get_batch_id_for_resource into l_batch_id;
714: close get_batch_id_for_resource;
715: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_MATERIAL) THEN
716: open get_batch_id_for_material;
717: fetch get_batch_id_for_material into l_batch_id;
718: close get_batch_id_for_material;
719: ELSE

Line 792: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN

788: NO_BATCHSTEP_FOUND_ERR exception;
789:
790: BEGIN
791:
792: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN
793: l_batchstep_id := to_number (P_ENTITY_KEY);
794: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN
795: open get_batchstep_id_for_activity;
796: fetch get_batchstep_id_for_activity into l_batchstep_id;

Line 794: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN

790: BEGIN
791:
792: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN
793: l_batchstep_id := to_number (P_ENTITY_KEY);
794: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN
795: open get_batchstep_id_for_activity;
796: fetch get_batchstep_id_for_activity into l_batchstep_id;
797: close get_batchstep_id_for_activity;
798: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN

Line 798: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN

794: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN
795: open get_batchstep_id_for_activity;
796: fetch get_batchstep_id_for_activity into l_batchstep_id;
797: close get_batchstep_id_for_activity;
798: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN
799: open get_batchstep_id_for_resource;
800: fetch get_batchstep_id_for_resource into l_batchstep_id;
801: close get_batchstep_id_for_resource;
802: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_MATERIAL) THEN

Line 802: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_MATERIAL) THEN

798: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN
799: open get_batchstep_id_for_resource;
800: fetch get_batchstep_id_for_resource into l_batchstep_id;
801: close get_batchstep_id_for_resource;
802: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_MATERIAL) THEN
803: open get_batchstep_id_for_material;
804: fetch get_batchstep_id_for_material into l_batchstep_id;
805: close get_batchstep_id_for_material;
806: ELSE

Line 864: if (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.YES) then

860: -- this function is internally used by the apis to
861: -- check if gmo is enabled or not.
862: function is_gmo_enabled return boolean is
863: begin
864: if (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.YES) then
865: return true;
866: else
867: return false;
868: end if;

Line 955: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) then

951: close get_task;
952:
953:
954: IF (L_TASK = 'UPDATE_ACTIVITY' or L_TASK='VIEW_ACTIVITY') then
955: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) then
956: l_batchstep_id := to_number(p_entity_key);
957: if (l_task_attribute is not null and l_task_attribute <> gmo_constants_grp.all_attribute) then
958: l_oprn_line_id := to_number (l_task_attribute);
959: open get_activity;

Line 957: if (l_task_attribute is not null and l_task_attribute <> gmo_constants_grp.all_attribute) then

953:
954: IF (L_TASK = 'UPDATE_ACTIVITY' or L_TASK='VIEW_ACTIVITY') then
955: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) then
956: l_batchstep_id := to_number(p_entity_key);
957: if (l_task_attribute is not null and l_task_attribute <> gmo_constants_grp.all_attribute) then
958: l_oprn_line_id := to_number (l_task_attribute);
959: open get_activity;
960: fetch get_activity into l_batchstep_activity_id;
961: close get_activity;

Line 972: ELSIF (L_TASK = 'UPDATE_RESOURCE' or L_TASK='VIEW_RESOURCE' or L_TASK = GMO_CONSTANTS_GRP.TASK_RESOURCE_TRANSACTION) then

968: end if;
969: l_task_attribute_id_inst := l_batchstep_activity_id;
970: end if;
971:
972: ELSIF (L_TASK = 'UPDATE_RESOURCE' or L_TASK='VIEW_RESOURCE' or L_TASK = GMO_CONSTANTS_GRP.TASK_RESOURCE_TRANSACTION) then
973:
974: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION or P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY ) THEN
975: -- pattern = OprnLineId$Resources
976: l_oprn_line_id := to_number (substr(l_task_attribute, 1, instr (l_task_attribute, '$') - 1));

Line 974: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION or P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY ) THEN

970: end if;
971:
972: ELSIF (L_TASK = 'UPDATE_RESOURCE' or L_TASK='VIEW_RESOURCE' or L_TASK = GMO_CONSTANTS_GRP.TASK_RESOURCE_TRANSACTION) then
973:
974: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION or P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY ) THEN
975: -- pattern = OprnLineId$Resources
976: l_oprn_line_id := to_number (substr(l_task_attribute, 1, instr (l_task_attribute, '$') - 1));
977: l_resources := substr(l_task_attribute, instr (l_task_attribute, '$') + 1);
978:

Line 979: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) then

975: -- pattern = OprnLineId$Resources
976: l_oprn_line_id := to_number (substr(l_task_attribute, 1, instr (l_task_attribute, '$') - 1));
977: l_resources := substr(l_task_attribute, instr (l_task_attribute, '$') + 1);
978:
979: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) then
980: l_batchstep_id := to_number(p_entity_key);
981: open get_activity;
982: fetch get_activity into l_batchstep_activity_id;
983: close get_activity;

Line 988: if (l_resources <> gmo_constants_grp.all_attribute) then

984: ELSE
985: l_batchstep_activity_id := to_number(p_entity_key);
986: END IF;
987:
988: if (l_resources <> gmo_constants_grp.all_attribute) then
989: open get_resource;
990: fetch get_resource into l_batchstep_resource_id;
991: close get_resource;
992:

Line 1004: ELSIF (L_TASK = GMO_CONSTANTS_GRP.TASK_PROCESS_PARAMETER) then

1000: l_task_attribute_id_inst := l_batchstep_resource_id;
1001:
1002: END IF;
1003:
1004: ELSIF (L_TASK = GMO_CONSTANTS_GRP.TASK_PROCESS_PARAMETER) then
1005:
1006: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION or P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY
1007: or P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN
1008: -- pattern = OprnLineId$Resources$ParameterId

Line 1006: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION or P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY

1002: END IF;
1003:
1004: ELSIF (L_TASK = GMO_CONSTANTS_GRP.TASK_PROCESS_PARAMETER) then
1005:
1006: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION or P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY
1007: or P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN
1008: -- pattern = OprnLineId$Resources$ParameterId
1009: l_oprn_line_id := to_number (substr(l_task_attribute, 1, instr (l_task_attribute, '$') - 1));
1010: l_resources := substr(l_task_attribute, instr (l_task_attribute, '$') + 1, (instr (l_task_attribute, '$', 1,2 )-1) - instr (l_task_attribute, '$'));

Line 1007: or P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN

1003:
1004: ELSIF (L_TASK = GMO_CONSTANTS_GRP.TASK_PROCESS_PARAMETER) then
1005:
1006: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION or P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY
1007: or P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN
1008: -- pattern = OprnLineId$Resources$ParameterId
1009: l_oprn_line_id := to_number (substr(l_task_attribute, 1, instr (l_task_attribute, '$') - 1));
1010: l_resources := substr(l_task_attribute, instr (l_task_attribute, '$') + 1, (instr (l_task_attribute, '$', 1,2 )-1) - instr (l_task_attribute, '$'));
1011: l_param_id_vchar := substr(l_task_attribute, instr (l_task_attribute, '$', 1,2) + 1);

Line 1013: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) then

1009: l_oprn_line_id := to_number (substr(l_task_attribute, 1, instr (l_task_attribute, '$') - 1));
1010: l_resources := substr(l_task_attribute, instr (l_task_attribute, '$') + 1, (instr (l_task_attribute, '$', 1,2 )-1) - instr (l_task_attribute, '$'));
1011: l_param_id_vchar := substr(l_task_attribute, instr (l_task_attribute, '$', 1,2) + 1);
1012:
1013: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) then
1014: l_batchstep_id := to_number(p_entity_key);
1015: open get_activity;
1016: fetch get_activity into l_batchstep_activity_id;
1017: close get_activity;

Line 1022: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN

1018:
1019: open get_resource;
1020: fetch get_resource into l_batchstep_resource_id;
1021: close get_resource;
1022: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN
1023: l_batchstep_activity_id := to_number(p_entity_key);
1024:
1025: open get_resource;
1026: fetch get_resource into l_batchstep_resource_id;

Line 1032: if (l_param_id_vchar <> gmo_constants_grp.all_attribute) then

1028: ELSE
1029: l_batchstep_resource_id := to_number(p_entity_key);
1030: END IF;
1031:
1032: if (l_param_id_vchar <> gmo_constants_grp.all_attribute) then
1033: l_param_id := to_number(l_param_id_vchar);
1034: open get_param;
1035: fetch get_param into l_process_param_id;
1036: close get_param;

Line 1050: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION or P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY

1046: END IF;
1047:
1048: ELSIF (L_TASK = 'MATERIAL' OR L_TASK = 'RESERVATIONS' OR L_TASK = 'VIEW_MATERIAL' OR L_TASK = 'UPDATE_MATERIAL' OR L_TASK='MATERIAL_TRANSACTIONS' OR L_TASK = 'QUALITY') THEN
1049:
1050: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION or P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY
1051: or P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN
1052:
1053: GET_BATCH_ID_FOR_ENTITY(P_ENTITY_NAME => P_ENTITY_NAME,
1054: P_ENTITY_KEY => P_ENTITY_KEY,

Line 1051: or P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN

1047:
1048: ELSIF (L_TASK = 'MATERIAL' OR L_TASK = 'RESERVATIONS' OR L_TASK = 'VIEW_MATERIAL' OR L_TASK = 'UPDATE_MATERIAL' OR L_TASK='MATERIAL_TRANSACTIONS' OR L_TASK = 'QUALITY') THEN
1049:
1050: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION or P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY
1051: or P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN
1052:
1053: GET_BATCH_ID_FOR_ENTITY(P_ENTITY_NAME => P_ENTITY_NAME,
1054: P_ENTITY_KEY => P_ENTITY_KEY,
1055: X_BATCH_ID => l_batch_id,

Line 1067: if (l_task_attribute is not null and l_task_attribute <> gmo_constants_grp.all_attribute) then

1063: X_RETURN_STATUS => l_return_status,
1064: X_MSG_COUNT => l_msg_count,
1065: X_MSG_DATA => l_msg_data);
1066:
1067: if (l_task_attribute is not null and l_task_attribute <> gmo_constants_grp.all_attribute) then
1068: l_formula_line_id := to_number(l_task_attribute);
1069: open get_material;
1070: fetch get_material into l_material_detail_id;
1071: close get_material;

Line 1195: IF (P_ENTITY_NAME <> GMO_CONSTANTS_GRP.ENTITY_BATCH OR p_entity_key is null) THEN

1191: IF (NOT IS_BATCH_ENHANCED_PI (P_ENTITY_NAME => P_ENTITY_NAME, P_ENTITY_KEY => P_ENTITY_KEY) ) THEN
1192: RAISE GMO_NOT_ENHANCED_PI_ERR;
1193: END IF;
1194:
1195: IF (P_ENTITY_NAME <> GMO_CONSTANTS_GRP.ENTITY_BATCH OR p_entity_key is null) THEN
1196: RAISE GMO_INVALID_ENTITY_ERR;
1197: END IF;
1198:
1199: open c_get_recipe;

Line 1228: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,

1224: P_API_VERSION => '1.0',
1225: X_RETURN_STATUS => l_return_status,
1226: X_MSG_COUNT => l_msg_count,
1227: X_MSG_DATA => l_msg_data,
1228: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
1229: P_DEFINITION_ENTITY_KEY => l_recipe_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_id,
1230: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
1231: P_INSTANCE_ENTITY_KEY => l_batchstep_id,
1232: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

Line 1229: P_DEFINITION_ENTITY_KEY => l_recipe_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_id,

1225: X_RETURN_STATUS => l_return_status,
1226: X_MSG_COUNT => l_msg_count,
1227: X_MSG_DATA => l_msg_data,
1228: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
1229: P_DEFINITION_ENTITY_KEY => l_recipe_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_id,
1230: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
1231: P_INSTANCE_ENTITY_KEY => l_batchstep_id,
1232: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
1233: X_INSTRUCTION_SET_ID => l_instruction_set_id

Line 1230: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,

1226: X_MSG_COUNT => l_msg_count,
1227: X_MSG_DATA => l_msg_data,
1228: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
1229: P_DEFINITION_ENTITY_KEY => l_recipe_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_id,
1230: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
1231: P_INSTANCE_ENTITY_KEY => l_batchstep_id,
1232: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
1233: X_INSTRUCTION_SET_ID => l_instruction_set_id
1234: );

Line 1232: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

1228: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
1229: P_DEFINITION_ENTITY_KEY => l_recipe_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_id,
1230: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
1231: P_INSTANCE_ENTITY_KEY => l_batchstep_id,
1232: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
1233: X_INSTRUCTION_SET_ID => l_instruction_set_id
1234: );
1235:
1236: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

Line 1241: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,

1237: RAISE instruction_create_err;
1238: end if;
1239: update_task_attribute
1240: (
1241: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
1242: P_ENTITY_KEY => l_batchstep_id,
1243: P_INSTRUCTION_SET_ID => l_instruction_set_id,
1244: X_ATTRIBUTE_STATUS => l_attribute_status,
1245: X_INVALID_INSTR => l_invalid_instr

Line 1280: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,

1276: P_API_VERSION => '1.0',
1277: X_RETURN_STATUS => l_return_status,
1278: X_MSG_COUNT => l_msg_count,
1279: X_MSG_DATA => l_msg_data,
1280: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
1281: P_DEFINITION_ENTITY_KEY => l_recipe_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_line_id,
1282: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
1283: P_INSTANCE_ENTITY_KEY => l_batchstep_activity_id,
1284: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

Line 1281: P_DEFINITION_ENTITY_KEY => l_recipe_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_line_id,

1277: X_RETURN_STATUS => l_return_status,
1278: X_MSG_COUNT => l_msg_count,
1279: X_MSG_DATA => l_msg_data,
1280: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
1281: P_DEFINITION_ENTITY_KEY => l_recipe_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_line_id,
1282: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
1283: P_INSTANCE_ENTITY_KEY => l_batchstep_activity_id,
1284: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
1285: X_INSTRUCTION_SET_ID => l_instruction_set_id

Line 1282: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,

1278: X_MSG_COUNT => l_msg_count,
1279: X_MSG_DATA => l_msg_data,
1280: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
1281: P_DEFINITION_ENTITY_KEY => l_recipe_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_line_id,
1282: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
1283: P_INSTANCE_ENTITY_KEY => l_batchstep_activity_id,
1284: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
1285: X_INSTRUCTION_SET_ID => l_instruction_set_id
1286: );

Line 1284: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

1280: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
1281: P_DEFINITION_ENTITY_KEY => l_recipe_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_line_id,
1282: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
1283: P_INSTANCE_ENTITY_KEY => l_batchstep_activity_id,
1284: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
1285: X_INSTRUCTION_SET_ID => l_instruction_set_id
1286: );
1287:
1288: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

Line 1294: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,

1290: end if;
1291:
1292: update_task_attribute
1293: (
1294: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
1295: P_ENTITY_KEY => l_batchstep_activity_id,
1296: P_INSTRUCTION_SET_ID => l_instruction_set_id,
1297: X_ATTRIBUTE_STATUS => l_attribute_status,
1298: X_INVALID_INSTR => l_invalid_instr

Line 1333: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,

1329: P_API_VERSION => '1.0',
1330: X_RETURN_STATUS => l_return_status,
1331: X_MSG_COUNT => l_msg_count,
1332: X_MSG_DATA => l_msg_data,
1333: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
1334: P_DEFINITION_ENTITY_KEY => l_recipe_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_line_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_resources,
1335: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
1336: P_INSTANCE_ENTITY_KEY => l_batchstep_resource_id,
1337: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

Line 1334: P_DEFINITION_ENTITY_KEY => l_recipe_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_line_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_resources,

1330: X_RETURN_STATUS => l_return_status,
1331: X_MSG_COUNT => l_msg_count,
1332: X_MSG_DATA => l_msg_data,
1333: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
1334: P_DEFINITION_ENTITY_KEY => l_recipe_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_line_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_resources,
1335: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
1336: P_INSTANCE_ENTITY_KEY => l_batchstep_resource_id,
1337: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
1338: X_INSTRUCTION_SET_ID => l_instruction_set_id

Line 1335: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,

1331: X_MSG_COUNT => l_msg_count,
1332: X_MSG_DATA => l_msg_data,
1333: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
1334: P_DEFINITION_ENTITY_KEY => l_recipe_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_line_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_resources,
1335: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
1336: P_INSTANCE_ENTITY_KEY => l_batchstep_resource_id,
1337: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
1338: X_INSTRUCTION_SET_ID => l_instruction_set_id
1339: );

Line 1337: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

1333: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
1334: P_DEFINITION_ENTITY_KEY => l_recipe_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_line_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_resources,
1335: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
1336: P_INSTANCE_ENTITY_KEY => l_batchstep_resource_id,
1337: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
1338: X_INSTRUCTION_SET_ID => l_instruction_set_id
1339: );
1340:
1341: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

Line 1347: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,

1343: end if;
1344:
1345: update_task_attribute
1346: (
1347: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
1348: P_ENTITY_KEY => l_batchstep_resource_id,
1349: P_INSTRUCTION_SET_ID => l_instruction_set_id,
1350: X_ATTRIBUTE_STATUS => l_attribute_status,
1351: X_INVALID_INSTR => l_invalid_instr

Line 1386: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,

1382: P_API_VERSION => '1.0',
1383: X_RETURN_STATUS => l_return_status,
1384: X_MSG_COUNT => l_msg_count,
1385: X_MSG_DATA => l_msg_data,
1386: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
1387: P_DEFINITION_ENTITY_KEY => l_recipe_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_formulaline_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_inventory_item_id,
1388: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
1389: P_INSTANCE_ENTITY_KEY => l_material_detail_id,
1390: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

Line 1387: P_DEFINITION_ENTITY_KEY => l_recipe_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_formulaline_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_inventory_item_id,

1383: X_RETURN_STATUS => l_return_status,
1384: X_MSG_COUNT => l_msg_count,
1385: X_MSG_DATA => l_msg_data,
1386: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
1387: P_DEFINITION_ENTITY_KEY => l_recipe_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_formulaline_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_inventory_item_id,
1388: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
1389: P_INSTANCE_ENTITY_KEY => l_material_detail_id,
1390: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
1391: X_INSTRUCTION_SET_ID => l_instruction_set_id

Line 1388: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,

1384: X_MSG_COUNT => l_msg_count,
1385: X_MSG_DATA => l_msg_data,
1386: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
1387: P_DEFINITION_ENTITY_KEY => l_recipe_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_formulaline_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_inventory_item_id,
1388: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
1389: P_INSTANCE_ENTITY_KEY => l_material_detail_id,
1390: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
1391: X_INSTRUCTION_SET_ID => l_instruction_set_id
1392: );

Line 1390: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

1386: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
1387: P_DEFINITION_ENTITY_KEY => l_recipe_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_formulaline_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_inventory_item_id,
1388: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
1389: P_INSTANCE_ENTITY_KEY => l_material_detail_id,
1390: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
1391: X_INSTRUCTION_SET_ID => l_instruction_set_id
1392: );
1393:
1394: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

Line 1400: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,

1396: end if;
1397:
1398: update_task_attribute
1399: (
1400: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
1401: P_ENTITY_KEY => l_material_detail_id,
1402: P_INSTRUCTION_SET_ID => l_instruction_set_id,
1403: X_ATTRIBUTE_STATUS => l_attribute_status,
1404: X_INVALID_INSTR => l_invalid_instr

Line 1584: IF (P_FROM_MODULE <> GMO_CONSTANTS_GRP.FROM_MODULE_PI AND P_FROM_MODULE <> GMO_CONSTANTS_GRP.FROM_MODULE_VBATCH) THEN

1580: END IF;
1581:
1582:
1583: --validte if the module is in vbatch or pi
1584: IF (P_FROM_MODULE <> GMO_CONSTANTS_GRP.FROM_MODULE_PI AND P_FROM_MODULE <> GMO_CONSTANTS_GRP.FROM_MODULE_VBATCH) THEN
1585: RAISE GMO_INVALID_MODULE_ERR;
1586: END IF;
1587:
1588:

Line 1595: if (P_VBATCH_MODE = GMO_CONSTANTS_GRP.VBATCH_ADMIN_MODE) then

1591: --we should check the admin privleges from the function access instead
1592: --of banking on the parameter.
1593: /*
1594:
1595: if (P_VBATCH_MODE = GMO_CONSTANTS_GRP.VBATCH_ADMIN_MODE) then
1596: l_vbatch_mode := GMO_CONSTANTS_GRP.VBATCH_ADMIN_MODE;
1597: else
1598: l_vbatch_mode := GMO_CONSTANTS_GRP.VBATCH_NORMAL_MODE;
1599: end if;

Line 1596: l_vbatch_mode := GMO_CONSTANTS_GRP.VBATCH_ADMIN_MODE;

1592: --of banking on the parameter.
1593: /*
1594:
1595: if (P_VBATCH_MODE = GMO_CONSTANTS_GRP.VBATCH_ADMIN_MODE) then
1596: l_vbatch_mode := GMO_CONSTANTS_GRP.VBATCH_ADMIN_MODE;
1597: else
1598: l_vbatch_mode := GMO_CONSTANTS_GRP.VBATCH_NORMAL_MODE;
1599: end if;
1600:

Line 1598: l_vbatch_mode := GMO_CONSTANTS_GRP.VBATCH_NORMAL_MODE;

1594:
1595: if (P_VBATCH_MODE = GMO_CONSTANTS_GRP.VBATCH_ADMIN_MODE) then
1596: l_vbatch_mode := GMO_CONSTANTS_GRP.VBATCH_ADMIN_MODE;
1597: else
1598: l_vbatch_mode := GMO_CONSTANTS_GRP.VBATCH_NORMAL_MODE;
1599: end if;
1600:
1601: if (P_FROM_MODULE = GMO_CONSTANTS_GRP.FROM_MODULE_PI) then
1602:

Line 1601: if (P_FROM_MODULE = GMO_CONSTANTS_GRP.FROM_MODULE_PI) then

1597: else
1598: l_vbatch_mode := GMO_CONSTANTS_GRP.VBATCH_NORMAL_MODE;
1599: end if;
1600:
1601: if (P_FROM_MODULE = GMO_CONSTANTS_GRP.FROM_MODULE_PI) then
1602:
1603: GMO_INSTRUCTION_GRP.GET_TASK_PARAMETER
1604: (
1605: P_API_VERSION => '1.0',

Line 1610: P_ATTRIBUTE_NAME => GMO_CONSTANTS_GRP.VBATCH_MODE_PARAMETER,

1606: X_RETURN_STATUS => l_return_status,
1607: X_MSG_COUNT => l_msg_count,
1608: X_MSG_DATA => l_msg_data,
1609: P_INSTRUCTION_PROCESS_ID => P_INSTRUCTION_PROCESS_ID,
1610: P_ATTRIBUTE_NAME => GMO_CONSTANTS_GRP.VBATCH_MODE_PARAMETER,
1611: X_ATTRIBUTE_VALUE => l_vbatch_mode
1612: );
1613:
1614:

Line 1623: l_vbatch_mode := GMO_CONSTANTS_GRP.VBATCH_ADMIN_MODE;

1619: end if;
1620: --if (l_vbatch_mode is null) then
1621: */
1622: if (FND_FUNCTION.TEST('GMO_VBATCH_DETAIL_ADMIN')) then
1623: l_vbatch_mode := GMO_CONSTANTS_GRP.VBATCH_ADMIN_MODE;
1624: else
1625: l_vbatch_mode := GMO_CONSTANTS_GRP.VBATCH_NORMAL_MODE;
1626: end if;
1627:

Line 1625: l_vbatch_mode := GMO_CONSTANTS_GRP.VBATCH_NORMAL_MODE;

1621: */
1622: if (FND_FUNCTION.TEST('GMO_VBATCH_DETAIL_ADMIN')) then
1623: l_vbatch_mode := GMO_CONSTANTS_GRP.VBATCH_ADMIN_MODE;
1624: else
1625: l_vbatch_mode := GMO_CONSTANTS_GRP.VBATCH_NORMAL_MODE;
1626: end if;
1627:
1628: l_requester := P_REQUESTER;
1629:

Line 1636: IF (P_ENTITY_NAME <> GMO_CONSTANTS_GRP.ENTITY_BATCH) THEN

1632: END IF;
1633:
1634: IF (P_TASK = 'VIEW_BATCH' or P_TASK = 'UPDATE_BATCH') THEN
1635:
1636: IF (P_ENTITY_NAME <> GMO_CONSTANTS_GRP.ENTITY_BATCH) THEN
1637: RAISE GMO_INVALID_TASK_ERR;
1638: END IF;
1639:
1640: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_BATCH;

Line 1640: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_BATCH;

1636: IF (P_ENTITY_NAME <> GMO_CONSTANTS_GRP.ENTITY_BATCH) THEN
1637: RAISE GMO_INVALID_TASK_ERR;
1638: END IF;
1639:
1640: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_BATCH;
1641: X_TASK_ENTITY_KEY := P_ENTITY_KEY;
1642: X_TASK_NAME := null;
1643: X_TASK_KEY := null;
1644:

Line 1646: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;

1642: X_TASK_NAME := null;
1643: X_TASK_KEY := null;
1644:
1645: IF (P_TASK = 'UPDATE_BATCH') THEN
1646: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1647: ELSE
1648: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1649:
1650: END IF;

Line 1648: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;

1644:
1645: IF (P_TASK = 'UPDATE_BATCH') THEN
1646: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1647: ELSE
1648: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1649:
1650: END IF;
1651:
1652: ELSIF (P_TASK = 'VIEW_OPERATION' or P_TASK = 'UPDATE_OPERATION' or P_TASK = 'RELEASE_STEP' or P_TASK = 'CLOSE_STEP') THEN

Line 1654: IF (P_ENTITY_NAME <> GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN

1650: END IF;
1651:
1652: ELSIF (P_TASK = 'VIEW_OPERATION' or P_TASK = 'UPDATE_OPERATION' or P_TASK = 'RELEASE_STEP' or P_TASK = 'CLOSE_STEP') THEN
1653:
1654: IF (P_ENTITY_NAME <> GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN
1655: RAISE GMO_INVALID_TASK_ERR;
1656: END IF;
1657:
1658: l_batchstep_id := to_number (p_entity_key);

Line 1659: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_OPERATION;

1655: RAISE GMO_INVALID_TASK_ERR;
1656: END IF;
1657:
1658: l_batchstep_id := to_number (p_entity_key);
1659: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_OPERATION;
1660: X_TASK_ENTITY_KEY := P_ENTITY_KEY;
1661: X_TASK_NAME := null;
1662: X_TASK_KEY := null;
1663:

Line 1665: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;

1661: X_TASK_NAME := null;
1662: X_TASK_KEY := null;
1663:
1664: IF (P_TASK = 'VIEW_OPERATION') THEN
1665: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1666: ELSE
1667: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);
1668:
1669: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN

Line 1669: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN

1665: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1666: ELSE
1667: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);
1668:
1669: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN
1670: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1671: ELSE
1672: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1673: END IF;

Line 1670: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;

1666: ELSE
1667: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);
1668:
1669: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN
1670: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1671: ELSE
1672: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1673: END IF;
1674:

Line 1672: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;

1668:
1669: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN
1670: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1671: ELSE
1672: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1673: END IF;
1674:
1675: END IF;
1676:

Line 1679: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN

1675: END IF;
1676:
1677: ELSIF (P_TASK = 'UPDATE_ACTIVITY' OR P_TASK = 'VIEW_ACTIVITY') THEN
1678:
1679: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN
1680: l_batchstep_id := to_number (p_entity_key);
1681: l_batchstep_activity_id := to_number(p_task_attribute);
1682:
1683: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN

Line 1683: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN

1679: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN
1680: l_batchstep_id := to_number (p_entity_key);
1681: l_batchstep_activity_id := to_number(p_task_attribute);
1682:
1683: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN
1684: l_batchstep_activity_id := to_number (p_entity_key);
1685:
1686: ELSE
1687: RAISE GMO_INVALID_TASK_ERR;

Line 1694: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_OPERATION;

1690: open get_activity_detail_from_id;
1691: fetch get_activity_detail_from_id into l_batch_id, l_batchstep_id, l_batchstep_activity_id;
1692: close get_activity_detail_from_id;
1693:
1694: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_OPERATION;
1695: X_TASK_ENTITY_KEY := l_batchstep_id;
1696: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_ACTIVITY;
1697: X_TASK_KEY := l_batchstep_activity_id;
1698:

Line 1696: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_ACTIVITY;

1692: close get_activity_detail_from_id;
1693:
1694: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_OPERATION;
1695: X_TASK_ENTITY_KEY := l_batchstep_id;
1696: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_ACTIVITY;
1697: X_TASK_KEY := l_batchstep_activity_id;
1698:
1699: IF (P_TASK = 'VIEW_ACTIVITY') THEN
1700: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;

Line 1700: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;

1696: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_ACTIVITY;
1697: X_TASK_KEY := l_batchstep_activity_id;
1698:
1699: IF (P_TASK = 'VIEW_ACTIVITY') THEN
1700: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1701: ELSE
1702:
1703: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);
1704:

Line 1705: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN

1701: ELSE
1702:
1703: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);
1704:
1705: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN
1706: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1707: ELSE
1708: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1709: END IF;

Line 1706: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;

1702:
1703: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);
1704:
1705: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN
1706: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1707: ELSE
1708: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1709: END IF;
1710:

Line 1708: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;

1704:
1705: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN
1706: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1707: ELSE
1708: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1709: END IF;
1710:
1711: END IF;
1712:

Line 1714: ELSIF (P_TASK = 'UPDATE_RESOURCE' OR P_TASK = 'VIEW_RESOURCE' OR P_TASK = GMO_CONSTANTS_GRP.TASK_RESOURCE_TRANSACTION) THEN

1710:
1711: END IF;
1712:
1713:
1714: ELSIF (P_TASK = 'UPDATE_RESOURCE' OR P_TASK = 'VIEW_RESOURCE' OR P_TASK = GMO_CONSTANTS_GRP.TASK_RESOURCE_TRANSACTION) THEN
1715:
1716: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN
1717: l_batchstep_id := to_number (p_entity_key);
1718: l_batchstep_resource_id := to_number(p_task_attribute);

Line 1716: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN

1712:
1713:
1714: ELSIF (P_TASK = 'UPDATE_RESOURCE' OR P_TASK = 'VIEW_RESOURCE' OR P_TASK = GMO_CONSTANTS_GRP.TASK_RESOURCE_TRANSACTION) THEN
1715:
1716: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN
1717: l_batchstep_id := to_number (p_entity_key);
1718: l_batchstep_resource_id := to_number(p_task_attribute);
1719:
1720: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN

Line 1720: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN

1716: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN
1717: l_batchstep_id := to_number (p_entity_key);
1718: l_batchstep_resource_id := to_number(p_task_attribute);
1719:
1720: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN
1721:
1722: l_batchstep_activity_id := to_number (p_entity_key);
1723: l_batchstep_resource_id := to_number(p_task_attribute);
1724:

Line 1725: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN

1721:
1722: l_batchstep_activity_id := to_number (p_entity_key);
1723: l_batchstep_resource_id := to_number(p_task_attribute);
1724:
1725: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN
1726:
1727: l_batchstep_resource_id := to_number(p_entity_key);
1728:
1729: ELSE

Line 1737: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_ACTIVITY;

1733: open get_resource_detail_from_id;
1734: fetch get_resource_detail_from_id into l_batch_id, l_batchstep_id, l_batchstep_activity_id, l_batchstep_resource_id;
1735: close get_resource_detail_from_id;
1736:
1737: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_ACTIVITY;
1738: X_TASK_ENTITY_KEY := l_batchstep_activity_id;
1739: IF (P_TASK = GMO_CONSTANTS_GRP.TASK_RESOURCE_TRANSACTION) THEN
1740: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_RESOURCE_TRANSACTION;
1741: ELSE

Line 1739: IF (P_TASK = GMO_CONSTANTS_GRP.TASK_RESOURCE_TRANSACTION) THEN

1735: close get_resource_detail_from_id;
1736:
1737: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_ACTIVITY;
1738: X_TASK_ENTITY_KEY := l_batchstep_activity_id;
1739: IF (P_TASK = GMO_CONSTANTS_GRP.TASK_RESOURCE_TRANSACTION) THEN
1740: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_RESOURCE_TRANSACTION;
1741: ELSE
1742: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_RESOURCE;
1743: END IF;

Line 1740: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_RESOURCE_TRANSACTION;

1736:
1737: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_ACTIVITY;
1738: X_TASK_ENTITY_KEY := l_batchstep_activity_id;
1739: IF (P_TASK = GMO_CONSTANTS_GRP.TASK_RESOURCE_TRANSACTION) THEN
1740: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_RESOURCE_TRANSACTION;
1741: ELSE
1742: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_RESOURCE;
1743: END IF;
1744: X_TASK_KEY := l_batchstep_resource_id;

Line 1742: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_RESOURCE;

1738: X_TASK_ENTITY_KEY := l_batchstep_activity_id;
1739: IF (P_TASK = GMO_CONSTANTS_GRP.TASK_RESOURCE_TRANSACTION) THEN
1740: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_RESOURCE_TRANSACTION;
1741: ELSE
1742: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_RESOURCE;
1743: END IF;
1744: X_TASK_KEY := l_batchstep_resource_id;
1745:
1746: IF (P_TASK = 'VIEW_RESOURCE') THEN

Line 1747: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;

1743: END IF;
1744: X_TASK_KEY := l_batchstep_resource_id;
1745:
1746: IF (P_TASK = 'VIEW_RESOURCE') THEN
1747: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1748: ELSE
1749:
1750: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);
1751:

Line 1752: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN

1748: ELSE
1749:
1750: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);
1751:
1752: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN
1753: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1754: ELSE
1755: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1756: END IF;

Line 1753: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;

1749:
1750: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);
1751:
1752: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN
1753: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1754: ELSE
1755: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1756: END IF;
1757:

Line 1755: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;

1751:
1752: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN
1753: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1754: ELSE
1755: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1756: END IF;
1757:
1758: END IF;
1759:

Line 1760: ELSIF (P_TASK = GMO_CONSTANTS_GRP.TASK_PROCESS_PARAMETER) THEN

1756: END IF;
1757:
1758: END IF;
1759:
1760: ELSIF (P_TASK = GMO_CONSTANTS_GRP.TASK_PROCESS_PARAMETER) THEN
1761:
1762: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN
1763: l_batchstep_id := to_number (p_entity_key);
1764:

Line 1762: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN

1758: END IF;
1759:
1760: ELSIF (P_TASK = GMO_CONSTANTS_GRP.TASK_PROCESS_PARAMETER) THEN
1761:
1762: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN
1763: l_batchstep_id := to_number (p_entity_key);
1764:
1765: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN
1766: l_batchstep_activity_id := to_number (p_entity_key);

Line 1765: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN

1761:
1762: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN
1763: l_batchstep_id := to_number (p_entity_key);
1764:
1765: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN
1766: l_batchstep_activity_id := to_number (p_entity_key);
1767:
1768: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN
1769: l_batchstep_resource_id := to_number(p_entity_key);

Line 1768: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN

1764:
1765: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN
1766: l_batchstep_activity_id := to_number (p_entity_key);
1767:
1768: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN
1769: l_batchstep_resource_id := to_number(p_entity_key);
1770:
1771: ELSE
1772: RAISE GMO_INVALID_TASK_ERR;

Line 1780: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_RESOURCE;

1776: open get_param_detail_from_id;
1777: fetch get_param_detail_from_id into l_batch_id, l_batchstep_id, l_batchstep_activity_id, l_batchstep_resource_id, l_process_param_id;
1778: close get_param_detail_from_id;
1779:
1780: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_RESOURCE;
1781: X_TASK_ENTITY_KEY := l_batchstep_resource_id;
1782: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_PROCESS_PARAMETER;
1783: X_TASK_KEY := l_process_param_id;
1784:

Line 1782: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_PROCESS_PARAMETER;

1778: close get_param_detail_from_id;
1779:
1780: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_RESOURCE;
1781: X_TASK_ENTITY_KEY := l_batchstep_resource_id;
1782: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_PROCESS_PARAMETER;
1783: X_TASK_KEY := l_process_param_id;
1784:
1785: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);
1786:

Line 1787: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN

1783: X_TASK_KEY := l_process_param_id;
1784:
1785: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);
1786:
1787: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN
1788: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1789: ELSE
1790: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1791: END IF;

Line 1788: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;

1784:
1785: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);
1786:
1787: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN
1788: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1789: ELSE
1790: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1791: END IF;
1792:

Line 1790: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;

1786:
1787: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN
1788: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1789: ELSE
1790: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1791: END IF;
1792:
1793: ELSIF (P_TASK = 'MATERIAL' OR P_TASK = 'RESERVATIONS' OR P_TASK = 'VIEW_MATERIAL' OR P_TASK = 'UPDATE_MATERIAL' OR P_TASK='MATERIAL_TRANSACTIONS' OR P_TASK = 'QUALITY') THEN
1794:

Line 1796: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_BATCH) THEN

1792:
1793: ELSIF (P_TASK = 'MATERIAL' OR P_TASK = 'RESERVATIONS' OR P_TASK = 'VIEW_MATERIAL' OR P_TASK = 'UPDATE_MATERIAL' OR P_TASK='MATERIAL_TRANSACTIONS' OR P_TASK = 'QUALITY') THEN
1794:
1795:
1796: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_BATCH) THEN
1797:
1798: l_batch_id := to_number (p_entity_key);
1799:
1800: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN

Line 1800: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN

1796: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_BATCH) THEN
1797:
1798: l_batch_id := to_number (p_entity_key);
1799:
1800: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN
1801: l_batchstep_id := to_number (p_entity_key);
1802: l_material_detail_id := to_number(p_task_attribute);
1803:
1804: open get_step_detail;

Line 1808: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN

1804: open get_step_detail;
1805: fetch get_step_detail into l_batch_id, l_batchstep_id;
1806: close get_step_detail;
1807:
1808: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN
1809:
1810: l_batchstep_activity_id := to_number(p_entity_key);
1811: l_material_detail_id := to_number(p_task_attribute);
1812:

Line 1817: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN

1813: open get_activity_detail_from_id;
1814: fetch get_activity_detail_from_id into l_batch_id, l_batchstep_id, l_batchstep_activity_id;
1815: close get_activity_detail_from_id;
1816:
1817: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN
1818:
1819: l_batchstep_resource_id := to_number(p_entity_key);
1820: l_material_detail_id := to_number(p_task_attribute);
1821:

Line 1826: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_MATERIAL) THEN

1822: open get_resource_detail_from_id;
1823: fetch get_resource_detail_from_id into l_batch_id, l_batchstep_id, l_batchstep_activity_id, l_batchstep_resource_id;
1824: close get_resource_detail_from_id;
1825:
1826: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_MATERIAL) THEN
1827:
1828: l_material_detail_id := to_number(p_entity_key);
1829:
1830: open get_step_id_for_material;

Line 1842: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_BATCH OR P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_MATERIAL OR P_TASK = 'QUALITY') THEN

1838: open get_material_detail_from_id;
1839: fetch get_material_detail_from_id into l_batch_id, l_material_detail_id, l_inventory_item_id, l_line_no, l_line_type;
1840: close get_material_detail_from_id;
1841:
1842: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_BATCH OR P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_MATERIAL OR P_TASK = 'QUALITY') THEN
1843: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_BATCH;
1844: X_TASK_ENTITY_KEY := l_batch_id;
1845: ELSE
1846: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_OPERATION;

Line 1843: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_BATCH;

1839: fetch get_material_detail_from_id into l_batch_id, l_material_detail_id, l_inventory_item_id, l_line_no, l_line_type;
1840: close get_material_detail_from_id;
1841:
1842: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_BATCH OR P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_MATERIAL OR P_TASK = 'QUALITY') THEN
1843: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_BATCH;
1844: X_TASK_ENTITY_KEY := l_batch_id;
1845: ELSE
1846: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_OPERATION;
1847: X_TASK_ENTITY_KEY := l_batchstep_id;

Line 1846: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_OPERATION;

1842: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_BATCH OR P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_MATERIAL OR P_TASK = 'QUALITY') THEN
1843: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_BATCH;
1844: X_TASK_ENTITY_KEY := l_batch_id;
1845: ELSE
1846: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_OPERATION;
1847: X_TASK_ENTITY_KEY := l_batchstep_id;
1848: END IF;
1849:
1850: IF (P_TASK= GMO_CONSTANTS_GRP.TASK_MATERIAL_TRANSACTIONS) THEN

Line 1850: IF (P_TASK= GMO_CONSTANTS_GRP.TASK_MATERIAL_TRANSACTIONS) THEN

1846: X_TASK_ENTITY_NAME := GMO_CONSTANTS_GRP.ENTITY_OPERATION;
1847: X_TASK_ENTITY_KEY := l_batchstep_id;
1848: END IF;
1849:
1850: IF (P_TASK= GMO_CONSTANTS_GRP.TASK_MATERIAL_TRANSACTIONS) THEN
1851: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_MATERIAL_TRANSACTIONS;
1852: l_invoke_mode := 'T';
1853: X_TASK_KEY := l_material_detail_id;
1854:

Line 1851: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_MATERIAL_TRANSACTIONS;

1847: X_TASK_ENTITY_KEY := l_batchstep_id;
1848: END IF;
1849:
1850: IF (P_TASK= GMO_CONSTANTS_GRP.TASK_MATERIAL_TRANSACTIONS) THEN
1851: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_MATERIAL_TRANSACTIONS;
1852: l_invoke_mode := 'T';
1853: X_TASK_KEY := l_material_detail_id;
1854:
1855: ELSIF (P_TASK = 'QUALITY') THEN

Line 1856: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_QUALITY;

1852: l_invoke_mode := 'T';
1853: X_TASK_KEY := l_material_detail_id;
1854:
1855: ELSIF (P_TASK = 'QUALITY') THEN
1856: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_QUALITY;
1857: X_TASK_KEY := l_inventory_item_id;
1858:
1859: ELSE
1860: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_MATERIAL;

Line 1860: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_MATERIAL;

1856: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_QUALITY;
1857: X_TASK_KEY := l_inventory_item_id;
1858:
1859: ELSE
1860: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_MATERIAL;
1861: X_TASK_KEY := l_material_detail_id;
1862: END IF;
1863:
1864: --Bug 5023801: start

Line 1866: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;

1862: END IF;
1863:
1864: --Bug 5023801: start
1865: IF (P_TASK = 'VIEW_MATERIAL') THEN
1866: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1867: --Bug 5023801: end
1868: ELSIF (X_TASK_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_BATCH or l_batchstep_id is null ) THEN
1869: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1870: ELSE

Line 1868: ELSIF (X_TASK_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_BATCH or l_batchstep_id is null ) THEN

1864: --Bug 5023801: start
1865: IF (P_TASK = 'VIEW_MATERIAL') THEN
1866: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1867: --Bug 5023801: end
1868: ELSIF (X_TASK_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_BATCH or l_batchstep_id is null ) THEN
1869: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1870: ELSE
1871:
1872: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);

Line 1869: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;

1865: IF (P_TASK = 'VIEW_MATERIAL') THEN
1866: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1867: --Bug 5023801: end
1868: ELSIF (X_TASK_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_BATCH or l_batchstep_id is null ) THEN
1869: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1870: ELSE
1871:
1872: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);
1873:

Line 1874: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN

1870: ELSE
1871:
1872: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);
1873:
1874: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN
1875: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1876: ELSE
1877: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1878: END IF;

Line 1875: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;

1871:
1872: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);
1873:
1874: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN
1875: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1876: ELSE
1877: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1878: END IF;
1879:

Line 1877: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;

1873:
1874: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN
1875: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1876: ELSE
1877: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1878: END IF;
1879:
1880: END IF;
1881:

Line 1981: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;

1977: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
1978: end if;
1979: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
1980: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1981: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1982: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
1983: FND_MSG_PUB.ADD;
1984: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1985: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2094: IF (P_ENTITY_NAME <> GMO_CONSTANTS_GRP.ENTITY_BATCH AND P_ENTITY_NAME <> GMO_CONSTANTS_GRP.ENTITY_OPERATION OR p_entity_key is null) THEN

2090: IF (NOT IS_BATCH_ENHANCED_PI (P_ENTITY_NAME => P_ENTITY_NAME, P_ENTITY_KEY => P_ENTITY_KEY) ) THEN
2091: RAISE GMO_NOT_ENHANCED_PI_ERR;
2092: END IF;
2093:
2094: IF (P_ENTITY_NAME <> GMO_CONSTANTS_GRP.ENTITY_BATCH AND P_ENTITY_NAME <> GMO_CONSTANTS_GRP.ENTITY_OPERATION OR p_entity_key is null) THEN
2095: RAISE GMO_INVALID_ENTITY_ERR;
2096: END IF;
2097:
2098: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2108: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_BATCH) THEN

2104: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2105: end if;
2106:
2107:
2108: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_BATCH) THEN
2109:
2110: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_TERMINATE OR P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN
2111: open c_get_steps;
2112: loop

Line 2110: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_TERMINATE OR P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN

2106:
2107:
2108: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_BATCH) THEN
2109:
2110: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_TERMINATE OR P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN
2111: open c_get_steps;
2112: loop
2113: fetch c_get_steps into l_batchstep_id;
2114: exit when c_get_steps%NOTFOUND;

Line 2121: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,

2117: P_API_VERSION => '1.0',
2118: X_RETURN_STATUS => l_return_status,
2119: X_MSG_COUNT => l_msg_count,
2120: X_MSG_DATA => l_msg_data,
2121: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
2122: P_ENTITY_KEY => l_batchstep_id,
2123: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2124: );
2125:

Line 2123: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE

2119: X_MSG_COUNT => l_msg_count,
2120: X_MSG_DATA => l_msg_data,
2121: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
2122: P_ENTITY_KEY => l_batchstep_id,
2123: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2124: );
2125:
2126: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2127: RAISE instruction_nullify_err;

Line 2130: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN

2126: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2127: RAISE instruction_nullify_err;
2128: end if;
2129:
2130: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN
2131:
2132:
2133: gmo_instruction_grp.create_instance_from_instance (
2134: P_API_VERSION => '1.0',

Line 2138: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,

2134: P_API_VERSION => '1.0',
2135: X_RETURN_STATUS => l_return_status,
2136: X_MSG_COUNT => l_msg_count,
2137: X_MSG_DATA => l_msg_data,
2138: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
2139: P_SOURCE_ENTITY_KEY => l_batchstep_id,
2140: P_TARGET_ENTITY_KEY => l_batchstep_id,
2141: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2142: X_INSTRUCTION_SET_ID => l_instruction_set_id

Line 2141: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

2137: X_MSG_DATA => l_msg_data,
2138: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
2139: P_SOURCE_ENTITY_KEY => l_batchstep_id,
2140: P_TARGET_ENTITY_KEY => l_batchstep_id,
2141: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2142: X_INSTRUCTION_SET_ID => l_instruction_set_id
2143: );
2144: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2145: RAISE instruction_create_err;

Line 2161: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,

2157: P_API_VERSION => '1.0',
2158: X_RETURN_STATUS => l_return_status,
2159: X_MSG_COUNT => l_msg_count,
2160: X_MSG_DATA => l_msg_data,
2161: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
2162: P_ENTITY_KEY => l_batchstep_activity_id,
2163: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2164: );
2165:

Line 2163: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE

2159: X_MSG_COUNT => l_msg_count,
2160: X_MSG_DATA => l_msg_data,
2161: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
2162: P_ENTITY_KEY => l_batchstep_activity_id,
2163: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2164: );
2165:
2166: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2167: RAISE instruction_nullify_err;

Line 2170: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN

2166: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2167: RAISE instruction_nullify_err;
2168: end if;
2169:
2170: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN
2171: gmo_instruction_grp.create_instance_from_instance (
2172: P_API_VERSION => '1.0',
2173: X_RETURN_STATUS => l_return_status,
2174: X_MSG_COUNT => l_msg_count,

Line 2176: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,

2172: P_API_VERSION => '1.0',
2173: X_RETURN_STATUS => l_return_status,
2174: X_MSG_COUNT => l_msg_count,
2175: X_MSG_DATA => l_msg_data,
2176: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
2177: P_SOURCE_ENTITY_KEY => l_batchstep_activity_id,
2178: P_TARGET_ENTITY_KEY => l_batchstep_activity_id,
2179: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2180: X_INSTRUCTION_SET_ID => l_instruction_set_id

Line 2179: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

2175: X_MSG_DATA => l_msg_data,
2176: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
2177: P_SOURCE_ENTITY_KEY => l_batchstep_activity_id,
2178: P_TARGET_ENTITY_KEY => l_batchstep_activity_id,
2179: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2180: X_INSTRUCTION_SET_ID => l_instruction_set_id
2181: );
2182: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2183: RAISE instruction_create_err;

Line 2200: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,

2196: P_API_VERSION => '1.0',
2197: X_RETURN_STATUS => l_return_status,
2198: X_MSG_COUNT => l_msg_count,
2199: X_MSG_DATA => l_msg_data,
2200: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
2201: P_ENTITY_KEY => l_batchstep_resource_id,
2202: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2203: );
2204:

Line 2202: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE

2198: X_MSG_COUNT => l_msg_count,
2199: X_MSG_DATA => l_msg_data,
2200: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
2201: P_ENTITY_KEY => l_batchstep_resource_id,
2202: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2203: );
2204:
2205: if X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2206: RAISE instruction_nullify_err;

Line 2209: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN

2205: if X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2206: RAISE instruction_nullify_err;
2207: end if;
2208:
2209: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN
2210: gmo_instruction_grp.create_instance_from_instance (
2211: P_API_VERSION => '1.0',
2212: X_RETURN_STATUS => l_return_status,
2213: X_MSG_COUNT => l_msg_count,

Line 2215: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,

2211: P_API_VERSION => '1.0',
2212: X_RETURN_STATUS => l_return_status,
2213: X_MSG_COUNT => l_msg_count,
2214: X_MSG_DATA => l_msg_data,
2215: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
2216: P_SOURCE_ENTITY_KEY => l_batchstep_resource_id,
2217: P_TARGET_ENTITY_KEY => l_batchstep_resource_id,
2218: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2219: X_INSTRUCTION_SET_ID => l_instruction_set_id

Line 2218: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

2214: X_MSG_DATA => l_msg_data,
2215: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
2216: P_SOURCE_ENTITY_KEY => l_batchstep_resource_id,
2217: P_TARGET_ENTITY_KEY => l_batchstep_resource_id,
2218: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2219: X_INSTRUCTION_SET_ID => l_instruction_set_id
2220: );
2221: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2222: RAISE instruction_create_err;

Line 2239: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,

2235: P_API_VERSION => '1.0',
2236: X_RETURN_STATUS => l_return_status,
2237: X_MSG_COUNT => l_msg_count,
2238: X_MSG_DATA => l_msg_data,
2239: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
2240: P_ENTITY_KEY => l_material_detail_id,
2241: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2242: );
2243:

Line 2241: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE

2237: X_MSG_COUNT => l_msg_count,
2238: X_MSG_DATA => l_msg_data,
2239: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
2240: P_ENTITY_KEY => l_material_detail_id,
2241: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2242: );
2243:
2244: if X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2245: RAISE instruction_nullify_err;

Line 2248: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN

2244: if X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2245: RAISE instruction_nullify_err;
2246: end if;
2247:
2248: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN
2249: gmo_instruction_grp.create_instance_from_instance (
2250: P_API_VERSION => '1.0',
2251: X_RETURN_STATUS => l_return_status,
2252: X_MSG_COUNT => l_msg_count,

Line 2254: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,

2250: P_API_VERSION => '1.0',
2251: X_RETURN_STATUS => l_return_status,
2252: X_MSG_COUNT => l_msg_count,
2253: X_MSG_DATA => l_msg_data,
2254: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
2255: P_SOURCE_ENTITY_KEY => l_material_detail_id,
2256: P_TARGET_ENTITY_KEY => l_material_detail_id,
2257: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2258: X_INSTRUCTION_SET_ID => l_instruction_set_id

Line 2257: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

2253: X_MSG_DATA => l_msg_data,
2254: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
2255: P_SOURCE_ENTITY_KEY => l_material_detail_id,
2256: P_TARGET_ENTITY_KEY => l_material_detail_id,
2257: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2258: X_INSTRUCTION_SET_ID => l_instruction_set_id
2259: );
2260: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2261: RAISE instruction_create_err;

Line 2267: ELSIF (P_TASK = GMO_CONSTANTS_GRP.ACTION_DELETE_MATERIAL) THEN

2263: end if;
2264: end loop;
2265: close c_get_materials;
2266:
2267: ELSIF (P_TASK = GMO_CONSTANTS_GRP.ACTION_DELETE_MATERIAL) THEN
2268:
2269: l_material_detail_id := P_TASK_ATTRIBUTE;
2270: gmo_instruction_grp.NULLIFY_INSTR_FOR_ENTITY (
2271: P_API_VERSION => '1.0',

Line 2275: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,

2271: P_API_VERSION => '1.0',
2272: X_RETURN_STATUS => l_return_status,
2273: X_MSG_COUNT => l_msg_count,
2274: X_MSG_DATA => l_msg_data,
2275: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
2276: P_ENTITY_KEY => l_material_detail_id,
2277: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2278: );
2279:

Line 2277: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE

2273: X_MSG_COUNT => l_msg_count,
2274: X_MSG_DATA => l_msg_data,
2275: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
2276: P_ENTITY_KEY => l_material_detail_id,
2277: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2278: );
2279:
2280: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2281: RAISE instruction_nullify_err;

Line 2284: END IF; -- end IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_TERMINATE OR P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN

2280: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2281: RAISE instruction_nullify_err;
2282: end if;
2283:
2284: END IF; -- end IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_TERMINATE OR P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN
2285:
2286: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN
2287:
2288: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_DELETE_OPERATION OR P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN

Line 2286: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN

2282: end if;
2283:
2284: END IF; -- end IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_TERMINATE OR P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN
2285:
2286: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN
2287:
2288: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_DELETE_OPERATION OR P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN
2289:
2290: l_batchstep_id := p_entity_key;

Line 2288: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_DELETE_OPERATION OR P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN

2284: END IF; -- end IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_TERMINATE OR P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN
2285:
2286: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN
2287:
2288: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_DELETE_OPERATION OR P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN
2289:
2290: l_batchstep_id := p_entity_key;
2291: gmo_instruction_grp.NULLIFY_INSTR_FOR_ENTITY (
2292: P_API_VERSION => '1.0',

Line 2296: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,

2292: P_API_VERSION => '1.0',
2293: X_RETURN_STATUS => l_return_status,
2294: X_MSG_COUNT => l_msg_count,
2295: X_MSG_DATA => l_msg_data,
2296: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
2297: P_ENTITY_KEY => l_batchstep_id,
2298: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2299: );
2300:

Line 2298: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE

2294: X_MSG_COUNT => l_msg_count,
2295: X_MSG_DATA => l_msg_data,
2296: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
2297: P_ENTITY_KEY => l_batchstep_id,
2298: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2299: );
2300:
2301: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2302: RAISE instruction_nullify_err;

Line 2305: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN

2301: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2302: RAISE instruction_nullify_err;
2303: end if;
2304:
2305: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN
2306:
2307:
2308: gmo_instruction_grp.create_instance_from_instance (
2309: P_API_VERSION => '1.0',

Line 2313: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,

2309: P_API_VERSION => '1.0',
2310: X_RETURN_STATUS => l_return_status,
2311: X_MSG_COUNT => l_msg_count,
2312: X_MSG_DATA => l_msg_data,
2313: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
2314: P_SOURCE_ENTITY_KEY => l_batchstep_id,
2315: P_TARGET_ENTITY_KEY => l_batchstep_id,
2316: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2317: X_INSTRUCTION_SET_ID => l_instruction_set_id

Line 2316: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

2312: X_MSG_DATA => l_msg_data,
2313: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
2314: P_SOURCE_ENTITY_KEY => l_batchstep_id,
2315: P_TARGET_ENTITY_KEY => l_batchstep_id,
2316: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2317: X_INSTRUCTION_SET_ID => l_instruction_set_id
2318: );
2319: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2320: RAISE instruction_create_err;

Line 2335: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,

2331: P_API_VERSION => '1.0',
2332: X_RETURN_STATUS => l_return_status,
2333: X_MSG_COUNT => l_msg_count,
2334: X_MSG_DATA => l_msg_data,
2335: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
2336: P_ENTITY_KEY => l_material_detail_id,
2337: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2338: );
2339:

Line 2337: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE

2333: X_MSG_COUNT => l_msg_count,
2334: X_MSG_DATA => l_msg_data,
2335: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
2336: P_ENTITY_KEY => l_material_detail_id,
2337: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2338: );
2339:
2340: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2341: RAISE instruction_nullify_err;

Line 2344: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN

2340: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2341: RAISE instruction_nullify_err;
2342: end if;
2343:
2344: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN
2345: gmo_instruction_grp.create_instance_from_instance (
2346: P_API_VERSION => '1.0',
2347: X_RETURN_STATUS => l_return_status,
2348: X_MSG_COUNT => l_msg_count,

Line 2350: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,

2346: P_API_VERSION => '1.0',
2347: X_RETURN_STATUS => l_return_status,
2348: X_MSG_COUNT => l_msg_count,
2349: X_MSG_DATA => l_msg_data,
2350: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
2351: P_SOURCE_ENTITY_KEY => l_material_detail_id,
2352: P_TARGET_ENTITY_KEY => l_material_detail_id,
2353: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2354: X_INSTRUCTION_SET_ID => l_instruction_set_id

Line 2353: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

2349: X_MSG_DATA => l_msg_data,
2350: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
2351: P_SOURCE_ENTITY_KEY => l_material_detail_id,
2352: P_TARGET_ENTITY_KEY => l_material_detail_id,
2353: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2354: X_INSTRUCTION_SET_ID => l_instruction_set_id
2355: );
2356: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2357: RAISE instruction_create_err;

Line 2375: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,

2371: P_API_VERSION => '1.0',
2372: X_RETURN_STATUS => l_return_status,
2373: X_MSG_COUNT => l_msg_count,
2374: X_MSG_DATA => l_msg_data,
2375: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
2376: P_ENTITY_KEY => l_batchstep_activity_id,
2377: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2378: );
2379:

Line 2377: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE

2373: X_MSG_COUNT => l_msg_count,
2374: X_MSG_DATA => l_msg_data,
2375: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
2376: P_ENTITY_KEY => l_batchstep_activity_id,
2377: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2378: );
2379:
2380: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2381: RAISE instruction_nullify_err;

Line 2384: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN

2380: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2381: RAISE instruction_nullify_err;
2382: end if;
2383:
2384: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN
2385: gmo_instruction_grp.create_instance_from_instance (
2386: P_API_VERSION => '1.0',
2387: X_RETURN_STATUS => l_return_status,
2388: X_MSG_COUNT => l_msg_count,

Line 2390: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,

2386: P_API_VERSION => '1.0',
2387: X_RETURN_STATUS => l_return_status,
2388: X_MSG_COUNT => l_msg_count,
2389: X_MSG_DATA => l_msg_data,
2390: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
2391: P_SOURCE_ENTITY_KEY => l_batchstep_activity_id,
2392: P_TARGET_ENTITY_KEY => l_batchstep_activity_id,
2393: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2394: X_INSTRUCTION_SET_ID => l_instruction_set_id

Line 2393: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

2389: X_MSG_DATA => l_msg_data,
2390: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
2391: P_SOURCE_ENTITY_KEY => l_batchstep_activity_id,
2392: P_TARGET_ENTITY_KEY => l_batchstep_activity_id,
2393: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2394: X_INSTRUCTION_SET_ID => l_instruction_set_id
2395: );
2396: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2397: RAISE instruction_create_err;

Line 2414: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,

2410: P_API_VERSION => '1.0',
2411: X_RETURN_STATUS => l_return_status,
2412: X_MSG_COUNT => l_msg_count,
2413: X_MSG_DATA => l_msg_data,
2414: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
2415: P_ENTITY_KEY => l_batchstep_resource_id,
2416: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2417: );
2418:

Line 2416: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE

2412: X_MSG_COUNT => l_msg_count,
2413: X_MSG_DATA => l_msg_data,
2414: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
2415: P_ENTITY_KEY => l_batchstep_resource_id,
2416: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2417: );
2418:
2419: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2420: RAISE instruction_nullify_err;

Line 2423: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN

2419: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2420: RAISE instruction_nullify_err;
2421: end if;
2422:
2423: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN
2424: gmo_instruction_grp.create_instance_from_instance (
2425: P_API_VERSION => '1.0',
2426: X_RETURN_STATUS => l_return_status,
2427: X_MSG_COUNT => l_msg_count,

Line 2429: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,

2425: P_API_VERSION => '1.0',
2426: X_RETURN_STATUS => l_return_status,
2427: X_MSG_COUNT => l_msg_count,
2428: X_MSG_DATA => l_msg_data,
2429: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
2430: P_SOURCE_ENTITY_KEY => l_batchstep_resource_id,
2431: P_TARGET_ENTITY_KEY => l_batchstep_resource_id,
2432: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2433: X_INSTRUCTION_SET_ID => l_instruction_set_id

Line 2432: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

2428: X_MSG_DATA => l_msg_data,
2429: P_SOURCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
2430: P_SOURCE_ENTITY_KEY => l_batchstep_resource_id,
2431: P_TARGET_ENTITY_KEY => l_batchstep_resource_id,
2432: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2433: X_INSTRUCTION_SET_ID => l_instruction_set_id
2434: );
2435: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2436: RAISE instruction_create_err;

Line 2443: ELSIF (P_TASK = GMO_CONSTANTS_GRP.ACTION_DELETE_ACTIVITY) THEN

2439:
2440: end loop;
2441: close c_get_step_resources;
2442:
2443: ELSIF (P_TASK = GMO_CONSTANTS_GRP.ACTION_DELETE_ACTIVITY) THEN
2444:
2445: l_batchstep_activity_id := P_TASK_ATTRIBUTE;
2446: gmo_instruction_grp.NULLIFY_INSTR_FOR_ENTITY (
2447: P_API_VERSION => '1.0',

Line 2451: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,

2447: P_API_VERSION => '1.0',
2448: X_RETURN_STATUS => l_return_status,
2449: X_MSG_COUNT => l_msg_count,
2450: X_MSG_DATA => l_msg_data,
2451: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
2452: P_ENTITY_KEY => l_batchstep_activity_id,
2453: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2454: );
2455:

Line 2453: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE

2449: X_MSG_COUNT => l_msg_count,
2450: X_MSG_DATA => l_msg_data,
2451: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
2452: P_ENTITY_KEY => l_batchstep_activity_id,
2453: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2454: );
2455:
2456: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2457: RAISE instruction_nullify_err;

Line 2470: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,

2466: P_API_VERSION => '1.0',
2467: X_RETURN_STATUS => l_return_status,
2468: X_MSG_COUNT => l_msg_count,
2469: X_MSG_DATA => l_msg_data,
2470: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
2471: P_ENTITY_KEY => l_batchstep_resource_id,
2472: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2473: );
2474:

Line 2472: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE

2468: X_MSG_COUNT => l_msg_count,
2469: X_MSG_DATA => l_msg_data,
2470: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
2471: P_ENTITY_KEY => l_batchstep_resource_id,
2472: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2473: );
2474:
2475: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2476: RAISE instruction_nullify_err;

Line 2482: ELSIF (P_TASK = GMO_CONSTANTS_GRP.ACTION_DELETE_RESOURCE) THEN

2478:
2479: end loop;
2480: close c_get_activity_resources;
2481:
2482: ELSIF (P_TASK = GMO_CONSTANTS_GRP.ACTION_DELETE_RESOURCE) THEN
2483:
2484: l_batchstep_resource_id := P_TASK_ATTRIBUTE;
2485: gmo_instruction_grp.NULLIFY_INSTR_FOR_ENTITY (
2486: P_API_VERSION => '1.0',

Line 2490: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,

2486: P_API_VERSION => '1.0',
2487: X_RETURN_STATUS => l_return_status,
2488: X_MSG_COUNT => l_msg_count,
2489: X_MSG_DATA => l_msg_data,
2490: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
2491: P_ENTITY_KEY => l_batchstep_resource_id,
2492: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2493: );
2494:

Line 2492: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE

2488: X_MSG_COUNT => l_msg_count,
2489: X_MSG_DATA => l_msg_data,
2490: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
2491: P_ENTITY_KEY => l_batchstep_resource_id,
2492: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2493: );
2494:
2495: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2496: RAISE instruction_nullify_err;

Line 2499: ELSIF (P_TASK = GMO_CONSTANTS_GRP.ACTION_DELETE_MATERIAL) THEN

2495: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2496: RAISE instruction_nullify_err;
2497: end if;
2498:
2499: ELSIF (P_TASK = GMO_CONSTANTS_GRP.ACTION_DELETE_MATERIAL) THEN
2500:
2501: l_material_detail_id := P_TASK_ATTRIBUTE;
2502: gmo_instruction_grp.NULLIFY_INSTR_FOR_ENTITY (
2503: P_API_VERSION => '1.0',

Line 2507: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,

2503: P_API_VERSION => '1.0',
2504: X_RETURN_STATUS => l_return_status,
2505: X_MSG_COUNT => l_msg_count,
2506: X_MSG_DATA => l_msg_data,
2507: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
2508: P_ENTITY_KEY => l_material_detail_id,
2509: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2510: );
2511:

Line 2509: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE

2505: X_MSG_COUNT => l_msg_count,
2506: X_MSG_DATA => l_msg_data,
2507: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
2508: P_ENTITY_KEY => l_material_detail_id,
2509: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2510: );
2511:
2512: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2513: RAISE instruction_nullify_err;

Line 2619: IF (P_FROM_MODULE = GMO_CONSTANTS_GRP.FROM_MODULE_PI) THEN

2615: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2616: end if;
2617:
2618:
2619: IF (P_FROM_MODULE = GMO_CONSTANTS_GRP.FROM_MODULE_PI) THEN
2620:
2621: gmo_instruction_grp.SEND_TASK_ACKN (
2622: P_API_VERSION => '1.0',
2623: X_RETURN_STATUS => l_return_status,

Line 2632: P_DISABLE_TASK => GMO_CONSTANTS_GRP.DISABLE_TASK_NO

2628: P_ENTITY_KEY => P_ENTITY_KEY,
2629: P_TASK_ERECORD_ID => P_TASK_ERECORD,
2630: P_TASK_IDENTIFIER => P_TASK_IDENTIFIER,
2631: P_TASK_VALUE => P_TASK_VALUE,
2632: P_DISABLE_TASK => GMO_CONSTANTS_GRP.DISABLE_TASK_NO
2633: );
2634:
2635:
2636: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

Line 2719: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN

2715: IF (NOT IS_BATCH_ENHANCED_PI (P_ENTITY_NAME => P_ENTITY_NAME, P_ENTITY_KEY => P_ENTITY_KEY) ) THEN
2716: RAISE GMO_NOT_ENHANCED_PI_ERR;
2717: END IF;
2718:
2719: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN
2720: l_batchstep_id := P_ENTITY_KEY;
2721: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN
2722: open get_step_id_for_activity;
2723: fetch get_step_id_for_activity into l_batchstep_id;

Line 2721: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN

2717: END IF;
2718:
2719: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_OPERATION) THEN
2720: l_batchstep_id := P_ENTITY_KEY;
2721: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN
2722: open get_step_id_for_activity;
2723: fetch get_step_id_for_activity into l_batchstep_id;
2724: close get_step_id_for_activity;
2725: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN

Line 2725: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN

2721: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_ACTIVITY) THEN
2722: open get_step_id_for_activity;
2723: fetch get_step_id_for_activity into l_batchstep_id;
2724: close get_step_id_for_activity;
2725: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN
2726: open get_step_id_for_resource;
2727: fetch get_step_id_for_resource into l_batchstep_id;
2728: close get_step_id_for_resource;
2729: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_MATERIAL) THEN

Line 2729: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_MATERIAL) THEN

2725: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_RESOURCE) THEN
2726: open get_step_id_for_resource;
2727: fetch get_step_id_for_resource into l_batchstep_id;
2728: close get_step_id_for_resource;
2729: ELSIF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_MATERIAL) THEN
2730: open get_step_id_for_material;
2731: fetch get_step_id_for_material into l_batchstep_id;
2732: close get_step_id_for_material;
2733: ELSE

Line 2746: X_LOCK_STATUS := GMO_CONSTANTS_GRP.NO;

2742: fetch is_step_locked into l_count;
2743: close is_step_locked;
2744:
2745: IF (l_count = 0) THEN
2746: X_LOCK_STATUS := GMO_CONSTANTS_GRP.NO;
2747: ELSE
2748: X_LOCK_STATUS := GMO_CONSTANTS_GRP.YES;
2749: END IF;
2750:

Line 2748: X_LOCK_STATUS := GMO_CONSTANTS_GRP.YES;

2744:
2745: IF (l_count = 0) THEN
2746: X_LOCK_STATUS := GMO_CONSTANTS_GRP.NO;
2747: ELSE
2748: X_LOCK_STATUS := GMO_CONSTANTS_GRP.YES;
2749: END IF;
2750:
2751: open is_step_locked_by;
2752: fetch is_step_locked_by into l_count;

Line 2756: X_LOCKED_BY_STATUS := GMO_CONSTANTS_GRP.NO;

2752: fetch is_step_locked_by into l_count;
2753: close is_step_locked_by;
2754:
2755: IF (l_count = 0) THEN
2756: X_LOCKED_BY_STATUS := GMO_CONSTANTS_GRP.NO;
2757: ELSE
2758: X_LOCKED_BY_STATUS := GMO_CONSTANTS_GRP.YES;
2759: END IF;
2760:

Line 2758: X_LOCKED_BY_STATUS := GMO_CONSTANTS_GRP.YES;

2754:
2755: IF (l_count = 0) THEN
2756: X_LOCKED_BY_STATUS := GMO_CONSTANTS_GRP.NO;
2757: ELSE
2758: X_LOCKED_BY_STATUS := GMO_CONSTANTS_GRP.YES;
2759: END IF;
2760:
2761: open get_step_detail;
2762: fetch get_step_detail into l_step_status;

Line 2765: IF (l_step_status = GMO_CONSTANTS_GRP.STEP_WIP_STATUS and X_LOCKED_BY_STATUS <> GMO_CONSTANTS_GRP.YES and X_LOCK_STATUS <> GMO_CONSTANTS_GRP.YES) THEN

2761: open get_step_detail;
2762: fetch get_step_detail into l_step_status;
2763: close get_step_detail;
2764:
2765: IF (l_step_status = GMO_CONSTANTS_GRP.STEP_WIP_STATUS and X_LOCKED_BY_STATUS <> GMO_CONSTANTS_GRP.YES and X_LOCK_STATUS <> GMO_CONSTANTS_GRP.YES) THEN
2766: X_LOCK_ALLOWED := GMO_CONSTANTS_GRP.YES;
2767: ELSE
2768: X_LOCK_ALLOWED := GMO_CONSTANTS_GRP.NO;
2769: END IF;

Line 2766: X_LOCK_ALLOWED := GMO_CONSTANTS_GRP.YES;

2762: fetch get_step_detail into l_step_status;
2763: close get_step_detail;
2764:
2765: IF (l_step_status = GMO_CONSTANTS_GRP.STEP_WIP_STATUS and X_LOCKED_BY_STATUS <> GMO_CONSTANTS_GRP.YES and X_LOCK_STATUS <> GMO_CONSTANTS_GRP.YES) THEN
2766: X_LOCK_ALLOWED := GMO_CONSTANTS_GRP.YES;
2767: ELSE
2768: X_LOCK_ALLOWED := GMO_CONSTANTS_GRP.NO;
2769: END IF;
2770:

Line 2768: X_LOCK_ALLOWED := GMO_CONSTANTS_GRP.NO;

2764:
2765: IF (l_step_status = GMO_CONSTANTS_GRP.STEP_WIP_STATUS and X_LOCKED_BY_STATUS <> GMO_CONSTANTS_GRP.YES and X_LOCK_STATUS <> GMO_CONSTANTS_GRP.YES) THEN
2766: X_LOCK_ALLOWED := GMO_CONSTANTS_GRP.YES;
2767: ELSE
2768: X_LOCK_ALLOWED := GMO_CONSTANTS_GRP.NO;
2769: END IF;
2770:
2771: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2772: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_LOCK_MSG');

Line 2910: t_entity_name(l_counter) := GMO_CONSTANTS_GRP.ENTITY_OPERATION;

2906: t_entity_level.extend;
2907: l_counter := l_counter + 1;
2908:
2909: t_name(l_counter) := l_oprn_no;
2910: t_entity_name(l_counter) := GMO_CONSTANTS_GRP.ENTITY_OPERATION;
2911: t_entity_key(l_counter) := l_batchstep_id;
2912: t_entity_level(l_counter) := '1';
2913:
2914:

Line 2928: t_entity_name(l_counter) := GMO_CONSTANTS_GRP.ENTITY_MATERIAL;

2924: t_entity_level.extend;
2925: l_counter := l_counter + 1;
2926:
2927: t_name(l_counter) := l_material_desc;
2928: t_entity_name(l_counter) := GMO_CONSTANTS_GRP.ENTITY_MATERIAL;
2929: t_entity_key(l_counter) := l_material_detail_id;
2930: t_entity_level(l_counter) := '2';
2931:
2932:

Line 2948: t_entity_name(l_counter) := GMO_CONSTANTS_GRP.ENTITY_ACTIVITY;

2944: t_entity_level.extend;
2945: l_counter := l_counter + 1;
2946:
2947: t_name(l_counter) := l_activity;
2948: t_entity_name(l_counter) := GMO_CONSTANTS_GRP.ENTITY_ACTIVITY;
2949: t_entity_key(l_counter) := l_batchstep_activity_id;
2950: t_entity_level(l_counter) := '2';
2951:
2952:

Line 2965: t_entity_name(l_counter) := GMO_CONSTANTS_GRP.ENTITY_RESOURCE;

2961: t_entity_level.extend;
2962: l_counter := l_counter + 1;
2963:
2964: t_name(l_counter) := l_resources;
2965: t_entity_name(l_counter) := GMO_CONSTANTS_GRP.ENTITY_RESOURCE;
2966: t_entity_key(l_counter) := l_batchstep_resource_id;
2967: t_entity_level(l_counter) := '3';
2968:
2969:

Line 3100: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,

3096: P_API_VERSION => '1.0',
3097: X_RETURN_STATUS => l_return_status,
3098: X_MSG_COUNT => l_msg_count,
3099: X_MSG_DATA => l_msg_data,
3100: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
3101: P_DEFINITION_ENTITY_KEY => l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_id,
3102: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
3103: P_INSTANCE_ENTITY_KEY => l_batchstep_id,
3104: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

Line 3101: P_DEFINITION_ENTITY_KEY => l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_id,

3097: X_RETURN_STATUS => l_return_status,
3098: X_MSG_COUNT => l_msg_count,
3099: X_MSG_DATA => l_msg_data,
3100: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
3101: P_DEFINITION_ENTITY_KEY => l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_id,
3102: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
3103: P_INSTANCE_ENTITY_KEY => l_batchstep_id,
3104: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
3105: X_INSTRUCTION_SET_ID => l_instruction_set_id

Line 3102: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,

3098: X_MSG_COUNT => l_msg_count,
3099: X_MSG_DATA => l_msg_data,
3100: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
3101: P_DEFINITION_ENTITY_KEY => l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_id,
3102: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
3103: P_INSTANCE_ENTITY_KEY => l_batchstep_id,
3104: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
3105: X_INSTRUCTION_SET_ID => l_instruction_set_id
3106: );

Line 3104: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

3100: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
3101: P_DEFINITION_ENTITY_KEY => l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_id,
3102: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
3103: P_INSTANCE_ENTITY_KEY => l_batchstep_id,
3104: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
3105: X_INSTRUCTION_SET_ID => l_instruction_set_id
3106: );
3107:
3108: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

Line 3113: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,

3109: RAISE instruction_create_err;
3110: end if;
3111: update_task_attribute
3112: (
3113: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
3114: P_ENTITY_KEY => l_batchstep_id,
3115: P_INSTRUCTION_SET_ID => l_instruction_set_id,
3116: X_ATTRIBUTE_STATUS => l_attribute_status,
3117: X_INVALID_INSTR => l_invalid_instr

Line 3152: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,

3148: P_API_VERSION => '1.0',
3149: X_RETURN_STATUS => l_return_status,
3150: X_MSG_COUNT => l_msg_count,
3151: X_MSG_DATA => l_msg_data,
3152: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
3153: P_DEFINITION_ENTITY_KEY => l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_line_id,
3154: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
3155: P_INSTANCE_ENTITY_KEY => l_batchstep_activity_id,
3156: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

Line 3153: P_DEFINITION_ENTITY_KEY => l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_line_id,

3149: X_RETURN_STATUS => l_return_status,
3150: X_MSG_COUNT => l_msg_count,
3151: X_MSG_DATA => l_msg_data,
3152: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
3153: P_DEFINITION_ENTITY_KEY => l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_line_id,
3154: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
3155: P_INSTANCE_ENTITY_KEY => l_batchstep_activity_id,
3156: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
3157: X_INSTRUCTION_SET_ID => l_instruction_set_id

Line 3154: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,

3150: X_MSG_COUNT => l_msg_count,
3151: X_MSG_DATA => l_msg_data,
3152: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
3153: P_DEFINITION_ENTITY_KEY => l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_line_id,
3154: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
3155: P_INSTANCE_ENTITY_KEY => l_batchstep_activity_id,
3156: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
3157: X_INSTRUCTION_SET_ID => l_instruction_set_id
3158: );

Line 3156: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

3152: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
3153: P_DEFINITION_ENTITY_KEY => l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_line_id,
3154: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
3155: P_INSTANCE_ENTITY_KEY => l_batchstep_activity_id,
3156: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
3157: X_INSTRUCTION_SET_ID => l_instruction_set_id
3158: );
3159:
3160: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

Line 3166: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,

3162: end if;
3163:
3164: update_task_attribute
3165: (
3166: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
3167: P_ENTITY_KEY => l_batchstep_activity_id,
3168: P_INSTRUCTION_SET_ID => l_instruction_set_id,
3169: X_ATTRIBUTE_STATUS => l_attribute_status,
3170: X_INVALID_INSTR => l_invalid_instr

Line 3205: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,

3201: P_API_VERSION => '1.0',
3202: X_RETURN_STATUS => l_return_status,
3203: X_MSG_COUNT => l_msg_count,
3204: X_MSG_DATA => l_msg_data,
3205: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
3206: P_DEFINITION_ENTITY_KEY => l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_line_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_resources,
3207: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
3208: P_INSTANCE_ENTITY_KEY => l_batchstep_resource_id,
3209: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

Line 3206: P_DEFINITION_ENTITY_KEY => l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_line_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_resources,

3202: X_RETURN_STATUS => l_return_status,
3203: X_MSG_COUNT => l_msg_count,
3204: X_MSG_DATA => l_msg_data,
3205: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
3206: P_DEFINITION_ENTITY_KEY => l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_line_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_resources,
3207: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
3208: P_INSTANCE_ENTITY_KEY => l_batchstep_resource_id,
3209: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
3210: X_INSTRUCTION_SET_ID => l_instruction_set_id

Line 3207: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,

3203: X_MSG_COUNT => l_msg_count,
3204: X_MSG_DATA => l_msg_data,
3205: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
3206: P_DEFINITION_ENTITY_KEY => l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_line_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_resources,
3207: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
3208: P_INSTANCE_ENTITY_KEY => l_batchstep_resource_id,
3209: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
3210: X_INSTRUCTION_SET_ID => l_instruction_set_id
3211: );

Line 3209: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

3205: P_DEFINITION_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
3206: P_DEFINITION_ENTITY_KEY => l_routingstep_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_oprn_line_id || GMO_CONSTANTS_GRP.ENTITY_KEY_SEPARATOR || l_resources,
3207: P_INSTANCE_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
3208: P_INSTANCE_ENTITY_KEY => l_batchstep_resource_id,
3209: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
3210: X_INSTRUCTION_SET_ID => l_instruction_set_id
3211: );
3212:
3213: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

Line 3219: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,

3215: end if;
3216:
3217: update_task_attribute
3218: (
3219: P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
3220: P_ENTITY_KEY => l_batchstep_resource_id,
3221: P_INSTRUCTION_SET_ID => l_instruction_set_id,
3222: X_ATTRIBUTE_STATUS => l_attribute_status,
3223: X_INVALID_INSTR => l_invalid_instr