1110: FOR UPDATE NOWAIT;
1111:
1112: -- Row locked. Compare IN attributes to DB attributes.
1113:
1114: IF WIP_GLOBALS.Equal(p_Res_rec.acct_period_id,
1115: l_Res_rec.acct_period_id)
1116: AND WIP_GLOBALS.Equal(p_Res_rec.activity_id,
1117: l_Res_rec.activity_id)
1118: AND WIP_GLOBALS.Equal(p_Res_rec.activity_name,
1112: -- Row locked. Compare IN attributes to DB attributes.
1113:
1114: IF WIP_GLOBALS.Equal(p_Res_rec.acct_period_id,
1115: l_Res_rec.acct_period_id)
1116: AND WIP_GLOBALS.Equal(p_Res_rec.activity_id,
1117: l_Res_rec.activity_id)
1118: AND WIP_GLOBALS.Equal(p_Res_rec.activity_name,
1119: l_Res_rec.activity_name)
1120: AND WIP_GLOBALS.Equal(p_Res_rec.actual_resource_rate,
1114: IF WIP_GLOBALS.Equal(p_Res_rec.acct_period_id,
1115: l_Res_rec.acct_period_id)
1116: AND WIP_GLOBALS.Equal(p_Res_rec.activity_id,
1117: l_Res_rec.activity_id)
1118: AND WIP_GLOBALS.Equal(p_Res_rec.activity_name,
1119: l_Res_rec.activity_name)
1120: AND WIP_GLOBALS.Equal(p_Res_rec.actual_resource_rate,
1121: l_Res_rec.actual_resource_rate)
1122: AND WIP_GLOBALS.Equal(p_Res_rec.attribute1,
1116: AND WIP_GLOBALS.Equal(p_Res_rec.activity_id,
1117: l_Res_rec.activity_id)
1118: AND WIP_GLOBALS.Equal(p_Res_rec.activity_name,
1119: l_Res_rec.activity_name)
1120: AND WIP_GLOBALS.Equal(p_Res_rec.actual_resource_rate,
1121: l_Res_rec.actual_resource_rate)
1122: AND WIP_GLOBALS.Equal(p_Res_rec.attribute1,
1123: l_Res_rec.attribute1)
1124: AND WIP_GLOBALS.Equal(p_Res_rec.attribute10,
1118: AND WIP_GLOBALS.Equal(p_Res_rec.activity_name,
1119: l_Res_rec.activity_name)
1120: AND WIP_GLOBALS.Equal(p_Res_rec.actual_resource_rate,
1121: l_Res_rec.actual_resource_rate)
1122: AND WIP_GLOBALS.Equal(p_Res_rec.attribute1,
1123: l_Res_rec.attribute1)
1124: AND WIP_GLOBALS.Equal(p_Res_rec.attribute10,
1125: l_Res_rec.attribute10)
1126: AND WIP_GLOBALS.Equal(p_Res_rec.attribute11,
1120: AND WIP_GLOBALS.Equal(p_Res_rec.actual_resource_rate,
1121: l_Res_rec.actual_resource_rate)
1122: AND WIP_GLOBALS.Equal(p_Res_rec.attribute1,
1123: l_Res_rec.attribute1)
1124: AND WIP_GLOBALS.Equal(p_Res_rec.attribute10,
1125: l_Res_rec.attribute10)
1126: AND WIP_GLOBALS.Equal(p_Res_rec.attribute11,
1127: l_Res_rec.attribute11)
1128: AND WIP_GLOBALS.Equal(p_Res_rec.attribute12,
1122: AND WIP_GLOBALS.Equal(p_Res_rec.attribute1,
1123: l_Res_rec.attribute1)
1124: AND WIP_GLOBALS.Equal(p_Res_rec.attribute10,
1125: l_Res_rec.attribute10)
1126: AND WIP_GLOBALS.Equal(p_Res_rec.attribute11,
1127: l_Res_rec.attribute11)
1128: AND WIP_GLOBALS.Equal(p_Res_rec.attribute12,
1129: l_Res_rec.attribute12)
1130: AND WIP_GLOBALS.Equal(p_Res_rec.attribute13,
1124: AND WIP_GLOBALS.Equal(p_Res_rec.attribute10,
1125: l_Res_rec.attribute10)
1126: AND WIP_GLOBALS.Equal(p_Res_rec.attribute11,
1127: l_Res_rec.attribute11)
1128: AND WIP_GLOBALS.Equal(p_Res_rec.attribute12,
1129: l_Res_rec.attribute12)
1130: AND WIP_GLOBALS.Equal(p_Res_rec.attribute13,
1131: l_Res_rec.attribute13)
1132: AND WIP_GLOBALS.Equal(p_Res_rec.attribute14,
1126: AND WIP_GLOBALS.Equal(p_Res_rec.attribute11,
1127: l_Res_rec.attribute11)
1128: AND WIP_GLOBALS.Equal(p_Res_rec.attribute12,
1129: l_Res_rec.attribute12)
1130: AND WIP_GLOBALS.Equal(p_Res_rec.attribute13,
1131: l_Res_rec.attribute13)
1132: AND WIP_GLOBALS.Equal(p_Res_rec.attribute14,
1133: l_Res_rec.attribute14)
1134: AND WIP_GLOBALS.Equal(p_Res_rec.attribute15,
1128: AND WIP_GLOBALS.Equal(p_Res_rec.attribute12,
1129: l_Res_rec.attribute12)
1130: AND WIP_GLOBALS.Equal(p_Res_rec.attribute13,
1131: l_Res_rec.attribute13)
1132: AND WIP_GLOBALS.Equal(p_Res_rec.attribute14,
1133: l_Res_rec.attribute14)
1134: AND WIP_GLOBALS.Equal(p_Res_rec.attribute15,
1135: l_Res_rec.attribute15)
1136: AND WIP_GLOBALS.Equal(p_Res_rec.attribute2,
1130: AND WIP_GLOBALS.Equal(p_Res_rec.attribute13,
1131: l_Res_rec.attribute13)
1132: AND WIP_GLOBALS.Equal(p_Res_rec.attribute14,
1133: l_Res_rec.attribute14)
1134: AND WIP_GLOBALS.Equal(p_Res_rec.attribute15,
1135: l_Res_rec.attribute15)
1136: AND WIP_GLOBALS.Equal(p_Res_rec.attribute2,
1137: l_Res_rec.attribute2)
1138: AND WIP_GLOBALS.Equal(p_Res_rec.attribute3,
1132: AND WIP_GLOBALS.Equal(p_Res_rec.attribute14,
1133: l_Res_rec.attribute14)
1134: AND WIP_GLOBALS.Equal(p_Res_rec.attribute15,
1135: l_Res_rec.attribute15)
1136: AND WIP_GLOBALS.Equal(p_Res_rec.attribute2,
1137: l_Res_rec.attribute2)
1138: AND WIP_GLOBALS.Equal(p_Res_rec.attribute3,
1139: l_Res_rec.attribute3)
1140: AND WIP_GLOBALS.Equal(p_Res_rec.attribute4,
1134: AND WIP_GLOBALS.Equal(p_Res_rec.attribute15,
1135: l_Res_rec.attribute15)
1136: AND WIP_GLOBALS.Equal(p_Res_rec.attribute2,
1137: l_Res_rec.attribute2)
1138: AND WIP_GLOBALS.Equal(p_Res_rec.attribute3,
1139: l_Res_rec.attribute3)
1140: AND WIP_GLOBALS.Equal(p_Res_rec.attribute4,
1141: l_Res_rec.attribute4)
1142: AND WIP_GLOBALS.Equal(p_Res_rec.attribute5,
1136: AND WIP_GLOBALS.Equal(p_Res_rec.attribute2,
1137: l_Res_rec.attribute2)
1138: AND WIP_GLOBALS.Equal(p_Res_rec.attribute3,
1139: l_Res_rec.attribute3)
1140: AND WIP_GLOBALS.Equal(p_Res_rec.attribute4,
1141: l_Res_rec.attribute4)
1142: AND WIP_GLOBALS.Equal(p_Res_rec.attribute5,
1143: l_Res_rec.attribute5)
1144: AND WIP_GLOBALS.Equal(p_Res_rec.attribute6,
1138: AND WIP_GLOBALS.Equal(p_Res_rec.attribute3,
1139: l_Res_rec.attribute3)
1140: AND WIP_GLOBALS.Equal(p_Res_rec.attribute4,
1141: l_Res_rec.attribute4)
1142: AND WIP_GLOBALS.Equal(p_Res_rec.attribute5,
1143: l_Res_rec.attribute5)
1144: AND WIP_GLOBALS.Equal(p_Res_rec.attribute6,
1145: l_Res_rec.attribute6)
1146: AND WIP_GLOBALS.Equal(p_Res_rec.attribute7,
1140: AND WIP_GLOBALS.Equal(p_Res_rec.attribute4,
1141: l_Res_rec.attribute4)
1142: AND WIP_GLOBALS.Equal(p_Res_rec.attribute5,
1143: l_Res_rec.attribute5)
1144: AND WIP_GLOBALS.Equal(p_Res_rec.attribute6,
1145: l_Res_rec.attribute6)
1146: AND WIP_GLOBALS.Equal(p_Res_rec.attribute7,
1147: l_Res_rec.attribute7)
1148: AND WIP_GLOBALS.Equal(p_Res_rec.attribute8,
1142: AND WIP_GLOBALS.Equal(p_Res_rec.attribute5,
1143: l_Res_rec.attribute5)
1144: AND WIP_GLOBALS.Equal(p_Res_rec.attribute6,
1145: l_Res_rec.attribute6)
1146: AND WIP_GLOBALS.Equal(p_Res_rec.attribute7,
1147: l_Res_rec.attribute7)
1148: AND WIP_GLOBALS.Equal(p_Res_rec.attribute8,
1149: l_Res_rec.attribute8)
1150: AND WIP_GLOBALS.Equal(p_Res_rec.attribute9,
1144: AND WIP_GLOBALS.Equal(p_Res_rec.attribute6,
1145: l_Res_rec.attribute6)
1146: AND WIP_GLOBALS.Equal(p_Res_rec.attribute7,
1147: l_Res_rec.attribute7)
1148: AND WIP_GLOBALS.Equal(p_Res_rec.attribute8,
1149: l_Res_rec.attribute8)
1150: AND WIP_GLOBALS.Equal(p_Res_rec.attribute9,
1151: l_Res_rec.attribute9)
1152: AND WIP_GLOBALS.Equal(p_Res_rec.attribute_category,
1146: AND WIP_GLOBALS.Equal(p_Res_rec.attribute7,
1147: l_Res_rec.attribute7)
1148: AND WIP_GLOBALS.Equal(p_Res_rec.attribute8,
1149: l_Res_rec.attribute8)
1150: AND WIP_GLOBALS.Equal(p_Res_rec.attribute9,
1151: l_Res_rec.attribute9)
1152: AND WIP_GLOBALS.Equal(p_Res_rec.attribute_category,
1153: l_Res_rec.attribute_category)
1154: AND WIP_GLOBALS.Equal(p_Res_rec.autocharge_type,
1148: AND WIP_GLOBALS.Equal(p_Res_rec.attribute8,
1149: l_Res_rec.attribute8)
1150: AND WIP_GLOBALS.Equal(p_Res_rec.attribute9,
1151: l_Res_rec.attribute9)
1152: AND WIP_GLOBALS.Equal(p_Res_rec.attribute_category,
1153: l_Res_rec.attribute_category)
1154: AND WIP_GLOBALS.Equal(p_Res_rec.autocharge_type,
1155: l_Res_rec.autocharge_type)
1156: AND WIP_GLOBALS.Equal(p_Res_rec.basis_type,
1150: AND WIP_GLOBALS.Equal(p_Res_rec.attribute9,
1151: l_Res_rec.attribute9)
1152: AND WIP_GLOBALS.Equal(p_Res_rec.attribute_category,
1153: l_Res_rec.attribute_category)
1154: AND WIP_GLOBALS.Equal(p_Res_rec.autocharge_type,
1155: l_Res_rec.autocharge_type)
1156: AND WIP_GLOBALS.Equal(p_Res_rec.basis_type,
1157: l_Res_rec.basis_type)
1158: AND WIP_GLOBALS.Equal(p_Res_rec.completion_transaction_id,
1152: AND WIP_GLOBALS.Equal(p_Res_rec.attribute_category,
1153: l_Res_rec.attribute_category)
1154: AND WIP_GLOBALS.Equal(p_Res_rec.autocharge_type,
1155: l_Res_rec.autocharge_type)
1156: AND WIP_GLOBALS.Equal(p_Res_rec.basis_type,
1157: l_Res_rec.basis_type)
1158: AND WIP_GLOBALS.Equal(p_Res_rec.completion_transaction_id,
1159: l_Res_rec.completion_transaction_id)
1160: AND WIP_GLOBALS.Equal(p_Res_rec.created_by,
1154: AND WIP_GLOBALS.Equal(p_Res_rec.autocharge_type,
1155: l_Res_rec.autocharge_type)
1156: AND WIP_GLOBALS.Equal(p_Res_rec.basis_type,
1157: l_Res_rec.basis_type)
1158: AND WIP_GLOBALS.Equal(p_Res_rec.completion_transaction_id,
1159: l_Res_rec.completion_transaction_id)
1160: AND WIP_GLOBALS.Equal(p_Res_rec.created_by,
1161: l_Res_rec.created_by)
1162: AND WIP_GLOBALS.Equal(p_Res_rec.created_by_name,
1156: AND WIP_GLOBALS.Equal(p_Res_rec.basis_type,
1157: l_Res_rec.basis_type)
1158: AND WIP_GLOBALS.Equal(p_Res_rec.completion_transaction_id,
1159: l_Res_rec.completion_transaction_id)
1160: AND WIP_GLOBALS.Equal(p_Res_rec.created_by,
1161: l_Res_rec.created_by)
1162: AND WIP_GLOBALS.Equal(p_Res_rec.created_by_name,
1163: l_Res_rec.created_by_name)
1164: AND WIP_GLOBALS.Equal(p_Res_rec.creation_date,
1158: AND WIP_GLOBALS.Equal(p_Res_rec.completion_transaction_id,
1159: l_Res_rec.completion_transaction_id)
1160: AND WIP_GLOBALS.Equal(p_Res_rec.created_by,
1161: l_Res_rec.created_by)
1162: AND WIP_GLOBALS.Equal(p_Res_rec.created_by_name,
1163: l_Res_rec.created_by_name)
1164: AND WIP_GLOBALS.Equal(p_Res_rec.creation_date,
1165: l_Res_rec.creation_date)
1166: AND WIP_GLOBALS.Equal(p_Res_rec.currency_actual_rsc_rate,
1160: AND WIP_GLOBALS.Equal(p_Res_rec.created_by,
1161: l_Res_rec.created_by)
1162: AND WIP_GLOBALS.Equal(p_Res_rec.created_by_name,
1163: l_Res_rec.created_by_name)
1164: AND WIP_GLOBALS.Equal(p_Res_rec.creation_date,
1165: l_Res_rec.creation_date)
1166: AND WIP_GLOBALS.Equal(p_Res_rec.currency_actual_rsc_rate,
1167: l_Res_rec.currency_actual_rsc_rate)
1168: AND WIP_GLOBALS.Equal(p_Res_rec.currency_code,
1162: AND WIP_GLOBALS.Equal(p_Res_rec.created_by_name,
1163: l_Res_rec.created_by_name)
1164: AND WIP_GLOBALS.Equal(p_Res_rec.creation_date,
1165: l_Res_rec.creation_date)
1166: AND WIP_GLOBALS.Equal(p_Res_rec.currency_actual_rsc_rate,
1167: l_Res_rec.currency_actual_rsc_rate)
1168: AND WIP_GLOBALS.Equal(p_Res_rec.currency_code,
1169: l_Res_rec.currency_code)
1170: AND WIP_GLOBALS.Equal(p_Res_rec.currency_conversion_date,
1164: AND WIP_GLOBALS.Equal(p_Res_rec.creation_date,
1165: l_Res_rec.creation_date)
1166: AND WIP_GLOBALS.Equal(p_Res_rec.currency_actual_rsc_rate,
1167: l_Res_rec.currency_actual_rsc_rate)
1168: AND WIP_GLOBALS.Equal(p_Res_rec.currency_code,
1169: l_Res_rec.currency_code)
1170: AND WIP_GLOBALS.Equal(p_Res_rec.currency_conversion_date,
1171: l_Res_rec.currency_conversion_date)
1172: AND WIP_GLOBALS.Equal(p_Res_rec.currency_conversion_rate,
1166: AND WIP_GLOBALS.Equal(p_Res_rec.currency_actual_rsc_rate,
1167: l_Res_rec.currency_actual_rsc_rate)
1168: AND WIP_GLOBALS.Equal(p_Res_rec.currency_code,
1169: l_Res_rec.currency_code)
1170: AND WIP_GLOBALS.Equal(p_Res_rec.currency_conversion_date,
1171: l_Res_rec.currency_conversion_date)
1172: AND WIP_GLOBALS.Equal(p_Res_rec.currency_conversion_rate,
1173: l_Res_rec.currency_conversion_rate)
1174: AND WIP_GLOBALS.Equal(p_Res_rec.currency_conversion_type,
1168: AND WIP_GLOBALS.Equal(p_Res_rec.currency_code,
1169: l_Res_rec.currency_code)
1170: AND WIP_GLOBALS.Equal(p_Res_rec.currency_conversion_date,
1171: l_Res_rec.currency_conversion_date)
1172: AND WIP_GLOBALS.Equal(p_Res_rec.currency_conversion_rate,
1173: l_Res_rec.currency_conversion_rate)
1174: AND WIP_GLOBALS.Equal(p_Res_rec.currency_conversion_type,
1175: l_Res_rec.currency_conversion_type)
1176: AND WIP_GLOBALS.Equal(p_Res_rec.department_code,
1170: AND WIP_GLOBALS.Equal(p_Res_rec.currency_conversion_date,
1171: l_Res_rec.currency_conversion_date)
1172: AND WIP_GLOBALS.Equal(p_Res_rec.currency_conversion_rate,
1173: l_Res_rec.currency_conversion_rate)
1174: AND WIP_GLOBALS.Equal(p_Res_rec.currency_conversion_type,
1175: l_Res_rec.currency_conversion_type)
1176: AND WIP_GLOBALS.Equal(p_Res_rec.department_code,
1177: l_Res_rec.department_code)
1178: AND WIP_GLOBALS.Equal(p_Res_rec.department_id,
1172: AND WIP_GLOBALS.Equal(p_Res_rec.currency_conversion_rate,
1173: l_Res_rec.currency_conversion_rate)
1174: AND WIP_GLOBALS.Equal(p_Res_rec.currency_conversion_type,
1175: l_Res_rec.currency_conversion_type)
1176: AND WIP_GLOBALS.Equal(p_Res_rec.department_code,
1177: l_Res_rec.department_code)
1178: AND WIP_GLOBALS.Equal(p_Res_rec.department_id,
1179: l_Res_rec.department_id)
1180: AND WIP_GLOBALS.Equal(p_Res_rec.employee_id,
1174: AND WIP_GLOBALS.Equal(p_Res_rec.currency_conversion_type,
1175: l_Res_rec.currency_conversion_type)
1176: AND WIP_GLOBALS.Equal(p_Res_rec.department_code,
1177: l_Res_rec.department_code)
1178: AND WIP_GLOBALS.Equal(p_Res_rec.department_id,
1179: l_Res_rec.department_id)
1180: AND WIP_GLOBALS.Equal(p_Res_rec.employee_id,
1181: l_Res_rec.employee_id)
1182: AND WIP_GLOBALS.Equal(p_Res_rec.employee_num,
1176: AND WIP_GLOBALS.Equal(p_Res_rec.department_code,
1177: l_Res_rec.department_code)
1178: AND WIP_GLOBALS.Equal(p_Res_rec.department_id,
1179: l_Res_rec.department_id)
1180: AND WIP_GLOBALS.Equal(p_Res_rec.employee_id,
1181: l_Res_rec.employee_id)
1182: AND WIP_GLOBALS.Equal(p_Res_rec.employee_num,
1183: l_Res_rec.employee_num)
1184: AND WIP_GLOBALS.Equal(p_Res_rec.entity_type,
1178: AND WIP_GLOBALS.Equal(p_Res_rec.department_id,
1179: l_Res_rec.department_id)
1180: AND WIP_GLOBALS.Equal(p_Res_rec.employee_id,
1181: l_Res_rec.employee_id)
1182: AND WIP_GLOBALS.Equal(p_Res_rec.employee_num,
1183: l_Res_rec.employee_num)
1184: AND WIP_GLOBALS.Equal(p_Res_rec.entity_type,
1185: l_Res_rec.entity_type)
1186: AND WIP_GLOBALS.Equal(p_Res_rec.group_id,
1180: AND WIP_GLOBALS.Equal(p_Res_rec.employee_id,
1181: l_Res_rec.employee_id)
1182: AND WIP_GLOBALS.Equal(p_Res_rec.employee_num,
1183: l_Res_rec.employee_num)
1184: AND WIP_GLOBALS.Equal(p_Res_rec.entity_type,
1185: l_Res_rec.entity_type)
1186: AND WIP_GLOBALS.Equal(p_Res_rec.group_id,
1187: l_Res_rec.group_id)
1188: AND WIP_GLOBALS.Equal(p_Res_rec.last_updated_by,
1182: AND WIP_GLOBALS.Equal(p_Res_rec.employee_num,
1183: l_Res_rec.employee_num)
1184: AND WIP_GLOBALS.Equal(p_Res_rec.entity_type,
1185: l_Res_rec.entity_type)
1186: AND WIP_GLOBALS.Equal(p_Res_rec.group_id,
1187: l_Res_rec.group_id)
1188: AND WIP_GLOBALS.Equal(p_Res_rec.last_updated_by,
1189: l_Res_rec.last_updated_by)
1190: AND WIP_GLOBALS.Equal(p_Res_rec.last_updated_by_name,
1184: AND WIP_GLOBALS.Equal(p_Res_rec.entity_type,
1185: l_Res_rec.entity_type)
1186: AND WIP_GLOBALS.Equal(p_Res_rec.group_id,
1187: l_Res_rec.group_id)
1188: AND WIP_GLOBALS.Equal(p_Res_rec.last_updated_by,
1189: l_Res_rec.last_updated_by)
1190: AND WIP_GLOBALS.Equal(p_Res_rec.last_updated_by_name,
1191: l_Res_rec.last_updated_by_name)
1192: AND WIP_GLOBALS.Equal(p_Res_rec.last_update_date,
1186: AND WIP_GLOBALS.Equal(p_Res_rec.group_id,
1187: l_Res_rec.group_id)
1188: AND WIP_GLOBALS.Equal(p_Res_rec.last_updated_by,
1189: l_Res_rec.last_updated_by)
1190: AND WIP_GLOBALS.Equal(p_Res_rec.last_updated_by_name,
1191: l_Res_rec.last_updated_by_name)
1192: AND WIP_GLOBALS.Equal(p_Res_rec.last_update_date,
1193: l_Res_rec.last_update_date)
1194: AND WIP_GLOBALS.Equal(p_Res_rec.last_update_login,
1188: AND WIP_GLOBALS.Equal(p_Res_rec.last_updated_by,
1189: l_Res_rec.last_updated_by)
1190: AND WIP_GLOBALS.Equal(p_Res_rec.last_updated_by_name,
1191: l_Res_rec.last_updated_by_name)
1192: AND WIP_GLOBALS.Equal(p_Res_rec.last_update_date,
1193: l_Res_rec.last_update_date)
1194: AND WIP_GLOBALS.Equal(p_Res_rec.last_update_login,
1195: l_Res_rec.last_update_login)
1196: AND WIP_GLOBALS.Equal(p_Res_rec.line_code,
1190: AND WIP_GLOBALS.Equal(p_Res_rec.last_updated_by_name,
1191: l_Res_rec.last_updated_by_name)
1192: AND WIP_GLOBALS.Equal(p_Res_rec.last_update_date,
1193: l_Res_rec.last_update_date)
1194: AND WIP_GLOBALS.Equal(p_Res_rec.last_update_login,
1195: l_Res_rec.last_update_login)
1196: AND WIP_GLOBALS.Equal(p_Res_rec.line_code,
1197: l_Res_rec.line_code)
1198: AND WIP_GLOBALS.Equal(p_Res_rec.line_id,
1192: AND WIP_GLOBALS.Equal(p_Res_rec.last_update_date,
1193: l_Res_rec.last_update_date)
1194: AND WIP_GLOBALS.Equal(p_Res_rec.last_update_login,
1195: l_Res_rec.last_update_login)
1196: AND WIP_GLOBALS.Equal(p_Res_rec.line_code,
1197: l_Res_rec.line_code)
1198: AND WIP_GLOBALS.Equal(p_Res_rec.line_id,
1199: l_Res_rec.line_id)
1200: AND WIP_GLOBALS.Equal(p_Res_rec.move_transaction_id,
1194: AND WIP_GLOBALS.Equal(p_Res_rec.last_update_login,
1195: l_Res_rec.last_update_login)
1196: AND WIP_GLOBALS.Equal(p_Res_rec.line_code,
1197: l_Res_rec.line_code)
1198: AND WIP_GLOBALS.Equal(p_Res_rec.line_id,
1199: l_Res_rec.line_id)
1200: AND WIP_GLOBALS.Equal(p_Res_rec.move_transaction_id,
1201: l_Res_rec.move_transaction_id)
1202: AND WIP_GLOBALS.Equal(p_Res_rec.operation_seq_num,
1196: AND WIP_GLOBALS.Equal(p_Res_rec.line_code,
1197: l_Res_rec.line_code)
1198: AND WIP_GLOBALS.Equal(p_Res_rec.line_id,
1199: l_Res_rec.line_id)
1200: AND WIP_GLOBALS.Equal(p_Res_rec.move_transaction_id,
1201: l_Res_rec.move_transaction_id)
1202: AND WIP_GLOBALS.Equal(p_Res_rec.operation_seq_num,
1203: l_Res_rec.operation_seq_num)
1204: AND WIP_GLOBALS.Equal(p_Res_rec.organization_code,
1198: AND WIP_GLOBALS.Equal(p_Res_rec.line_id,
1199: l_Res_rec.line_id)
1200: AND WIP_GLOBALS.Equal(p_Res_rec.move_transaction_id,
1201: l_Res_rec.move_transaction_id)
1202: AND WIP_GLOBALS.Equal(p_Res_rec.operation_seq_num,
1203: l_Res_rec.operation_seq_num)
1204: AND WIP_GLOBALS.Equal(p_Res_rec.organization_code,
1205: l_Res_rec.organization_code)
1206: AND WIP_GLOBALS.Equal(p_Res_rec.organization_id,
1200: AND WIP_GLOBALS.Equal(p_Res_rec.move_transaction_id,
1201: l_Res_rec.move_transaction_id)
1202: AND WIP_GLOBALS.Equal(p_Res_rec.operation_seq_num,
1203: l_Res_rec.operation_seq_num)
1204: AND WIP_GLOBALS.Equal(p_Res_rec.organization_code,
1205: l_Res_rec.organization_code)
1206: AND WIP_GLOBALS.Equal(p_Res_rec.organization_id,
1207: l_Res_rec.organization_id)
1208: AND WIP_GLOBALS.Equal(p_Res_rec.po_header_id,
1202: AND WIP_GLOBALS.Equal(p_Res_rec.operation_seq_num,
1203: l_Res_rec.operation_seq_num)
1204: AND WIP_GLOBALS.Equal(p_Res_rec.organization_code,
1205: l_Res_rec.organization_code)
1206: AND WIP_GLOBALS.Equal(p_Res_rec.organization_id,
1207: l_Res_rec.organization_id)
1208: AND WIP_GLOBALS.Equal(p_Res_rec.po_header_id,
1209: l_Res_rec.po_header_id)
1210: AND WIP_GLOBALS.Equal(p_Res_rec.po_line_id,
1204: AND WIP_GLOBALS.Equal(p_Res_rec.organization_code,
1205: l_Res_rec.organization_code)
1206: AND WIP_GLOBALS.Equal(p_Res_rec.organization_id,
1207: l_Res_rec.organization_id)
1208: AND WIP_GLOBALS.Equal(p_Res_rec.po_header_id,
1209: l_Res_rec.po_header_id)
1210: AND WIP_GLOBALS.Equal(p_Res_rec.po_line_id,
1211: l_Res_rec.po_line_id)
1212: AND WIP_GLOBALS.Equal(p_Res_rec.primary_item_id,
1206: AND WIP_GLOBALS.Equal(p_Res_rec.organization_id,
1207: l_Res_rec.organization_id)
1208: AND WIP_GLOBALS.Equal(p_Res_rec.po_header_id,
1209: l_Res_rec.po_header_id)
1210: AND WIP_GLOBALS.Equal(p_Res_rec.po_line_id,
1211: l_Res_rec.po_line_id)
1212: AND WIP_GLOBALS.Equal(p_Res_rec.primary_item_id,
1213: l_Res_rec.primary_item_id)
1214: AND WIP_GLOBALS.Equal(p_Res_rec.primary_quantity,
1208: AND WIP_GLOBALS.Equal(p_Res_rec.po_header_id,
1209: l_Res_rec.po_header_id)
1210: AND WIP_GLOBALS.Equal(p_Res_rec.po_line_id,
1211: l_Res_rec.po_line_id)
1212: AND WIP_GLOBALS.Equal(p_Res_rec.primary_item_id,
1213: l_Res_rec.primary_item_id)
1214: AND WIP_GLOBALS.Equal(p_Res_rec.primary_quantity,
1215: l_Res_rec.primary_quantity)
1216: AND WIP_GLOBALS.Equal(p_Res_rec.primary_uom,
1210: AND WIP_GLOBALS.Equal(p_Res_rec.po_line_id,
1211: l_Res_rec.po_line_id)
1212: AND WIP_GLOBALS.Equal(p_Res_rec.primary_item_id,
1213: l_Res_rec.primary_item_id)
1214: AND WIP_GLOBALS.Equal(p_Res_rec.primary_quantity,
1215: l_Res_rec.primary_quantity)
1216: AND WIP_GLOBALS.Equal(p_Res_rec.primary_uom,
1217: l_Res_rec.primary_uom)
1218: AND WIP_GLOBALS.Equal(p_Res_rec.primary_uom_class,
1212: AND WIP_GLOBALS.Equal(p_Res_rec.primary_item_id,
1213: l_Res_rec.primary_item_id)
1214: AND WIP_GLOBALS.Equal(p_Res_rec.primary_quantity,
1215: l_Res_rec.primary_quantity)
1216: AND WIP_GLOBALS.Equal(p_Res_rec.primary_uom,
1217: l_Res_rec.primary_uom)
1218: AND WIP_GLOBALS.Equal(p_Res_rec.primary_uom_class,
1219: l_Res_rec.primary_uom_class)
1220: AND WIP_GLOBALS.Equal(p_Res_rec.process_phase,
1214: AND WIP_GLOBALS.Equal(p_Res_rec.primary_quantity,
1215: l_Res_rec.primary_quantity)
1216: AND WIP_GLOBALS.Equal(p_Res_rec.primary_uom,
1217: l_Res_rec.primary_uom)
1218: AND WIP_GLOBALS.Equal(p_Res_rec.primary_uom_class,
1219: l_Res_rec.primary_uom_class)
1220: AND WIP_GLOBALS.Equal(p_Res_rec.process_phase,
1221: l_Res_rec.process_phase)
1222: AND WIP_GLOBALS.Equal(p_Res_rec.process_status,
1216: AND WIP_GLOBALS.Equal(p_Res_rec.primary_uom,
1217: l_Res_rec.primary_uom)
1218: AND WIP_GLOBALS.Equal(p_Res_rec.primary_uom_class,
1219: l_Res_rec.primary_uom_class)
1220: AND WIP_GLOBALS.Equal(p_Res_rec.process_phase,
1221: l_Res_rec.process_phase)
1222: AND WIP_GLOBALS.Equal(p_Res_rec.process_status,
1223: l_Res_rec.process_status)
1224: AND WIP_GLOBALS.Equal(p_Res_rec.program_application_id,
1218: AND WIP_GLOBALS.Equal(p_Res_rec.primary_uom_class,
1219: l_Res_rec.primary_uom_class)
1220: AND WIP_GLOBALS.Equal(p_Res_rec.process_phase,
1221: l_Res_rec.process_phase)
1222: AND WIP_GLOBALS.Equal(p_Res_rec.process_status,
1223: l_Res_rec.process_status)
1224: AND WIP_GLOBALS.Equal(p_Res_rec.program_application_id,
1225: l_Res_rec.program_application_id)
1226: AND WIP_GLOBALS.Equal(p_Res_rec.program_id,
1220: AND WIP_GLOBALS.Equal(p_Res_rec.process_phase,
1221: l_Res_rec.process_phase)
1222: AND WIP_GLOBALS.Equal(p_Res_rec.process_status,
1223: l_Res_rec.process_status)
1224: AND WIP_GLOBALS.Equal(p_Res_rec.program_application_id,
1225: l_Res_rec.program_application_id)
1226: AND WIP_GLOBALS.Equal(p_Res_rec.program_id,
1227: l_Res_rec.program_id)
1228: AND WIP_GLOBALS.Equal(p_Res_rec.program_update_date,
1222: AND WIP_GLOBALS.Equal(p_Res_rec.process_status,
1223: l_Res_rec.process_status)
1224: AND WIP_GLOBALS.Equal(p_Res_rec.program_application_id,
1225: l_Res_rec.program_application_id)
1226: AND WIP_GLOBALS.Equal(p_Res_rec.program_id,
1227: l_Res_rec.program_id)
1228: AND WIP_GLOBALS.Equal(p_Res_rec.program_update_date,
1229: l_Res_rec.program_update_date)
1230: AND WIP_GLOBALS.Equal(p_Res_rec.project_id,
1224: AND WIP_GLOBALS.Equal(p_Res_rec.program_application_id,
1225: l_Res_rec.program_application_id)
1226: AND WIP_GLOBALS.Equal(p_Res_rec.program_id,
1227: l_Res_rec.program_id)
1228: AND WIP_GLOBALS.Equal(p_Res_rec.program_update_date,
1229: l_Res_rec.program_update_date)
1230: AND WIP_GLOBALS.Equal(p_Res_rec.project_id,
1231: l_Res_rec.project_id)
1232: AND WIP_GLOBALS.Equal(p_Res_rec.rcv_transaction_id,
1226: AND WIP_GLOBALS.Equal(p_Res_rec.program_id,
1227: l_Res_rec.program_id)
1228: AND WIP_GLOBALS.Equal(p_Res_rec.program_update_date,
1229: l_Res_rec.program_update_date)
1230: AND WIP_GLOBALS.Equal(p_Res_rec.project_id,
1231: l_Res_rec.project_id)
1232: AND WIP_GLOBALS.Equal(p_Res_rec.rcv_transaction_id,
1233: l_Res_rec.rcv_transaction_id)
1234: AND WIP_GLOBALS.Equal(p_Res_rec.reason_id,
1228: AND WIP_GLOBALS.Equal(p_Res_rec.program_update_date,
1229: l_Res_rec.program_update_date)
1230: AND WIP_GLOBALS.Equal(p_Res_rec.project_id,
1231: l_Res_rec.project_id)
1232: AND WIP_GLOBALS.Equal(p_Res_rec.rcv_transaction_id,
1233: l_Res_rec.rcv_transaction_id)
1234: AND WIP_GLOBALS.Equal(p_Res_rec.reason_id,
1235: l_Res_rec.reason_id)
1236: AND WIP_GLOBALS.Equal(p_Res_rec.reason_name,
1230: AND WIP_GLOBALS.Equal(p_Res_rec.project_id,
1231: l_Res_rec.project_id)
1232: AND WIP_GLOBALS.Equal(p_Res_rec.rcv_transaction_id,
1233: l_Res_rec.rcv_transaction_id)
1234: AND WIP_GLOBALS.Equal(p_Res_rec.reason_id,
1235: l_Res_rec.reason_id)
1236: AND WIP_GLOBALS.Equal(p_Res_rec.reason_name,
1237: l_Res_rec.reason_name)
1238: AND WIP_GLOBALS.Equal(p_Res_rec.receiving_account_id,
1232: AND WIP_GLOBALS.Equal(p_Res_rec.rcv_transaction_id,
1233: l_Res_rec.rcv_transaction_id)
1234: AND WIP_GLOBALS.Equal(p_Res_rec.reason_id,
1235: l_Res_rec.reason_id)
1236: AND WIP_GLOBALS.Equal(p_Res_rec.reason_name,
1237: l_Res_rec.reason_name)
1238: AND WIP_GLOBALS.Equal(p_Res_rec.receiving_account_id,
1239: l_Res_rec.receiving_account_id)
1240: AND WIP_GLOBALS.Equal(p_Res_rec.reference,
1234: AND WIP_GLOBALS.Equal(p_Res_rec.reason_id,
1235: l_Res_rec.reason_id)
1236: AND WIP_GLOBALS.Equal(p_Res_rec.reason_name,
1237: l_Res_rec.reason_name)
1238: AND WIP_GLOBALS.Equal(p_Res_rec.receiving_account_id,
1239: l_Res_rec.receiving_account_id)
1240: AND WIP_GLOBALS.Equal(p_Res_rec.reference,
1241: l_Res_rec.reference)
1242: AND WIP_GLOBALS.Equal(p_Res_rec.repetitive_schedule_id,
1236: AND WIP_GLOBALS.Equal(p_Res_rec.reason_name,
1237: l_Res_rec.reason_name)
1238: AND WIP_GLOBALS.Equal(p_Res_rec.receiving_account_id,
1239: l_Res_rec.receiving_account_id)
1240: AND WIP_GLOBALS.Equal(p_Res_rec.reference,
1241: l_Res_rec.reference)
1242: AND WIP_GLOBALS.Equal(p_Res_rec.repetitive_schedule_id,
1243: l_Res_rec.repetitive_schedule_id)
1244: AND WIP_GLOBALS.Equal(p_Res_rec.request_id,
1238: AND WIP_GLOBALS.Equal(p_Res_rec.receiving_account_id,
1239: l_Res_rec.receiving_account_id)
1240: AND WIP_GLOBALS.Equal(p_Res_rec.reference,
1241: l_Res_rec.reference)
1242: AND WIP_GLOBALS.Equal(p_Res_rec.repetitive_schedule_id,
1243: l_Res_rec.repetitive_schedule_id)
1244: AND WIP_GLOBALS.Equal(p_Res_rec.request_id,
1245: l_Res_rec.request_id)
1246: AND WIP_GLOBALS.Equal(p_Res_rec.resource_code,
1240: AND WIP_GLOBALS.Equal(p_Res_rec.reference,
1241: l_Res_rec.reference)
1242: AND WIP_GLOBALS.Equal(p_Res_rec.repetitive_schedule_id,
1243: l_Res_rec.repetitive_schedule_id)
1244: AND WIP_GLOBALS.Equal(p_Res_rec.request_id,
1245: l_Res_rec.request_id)
1246: AND WIP_GLOBALS.Equal(p_Res_rec.resource_code,
1247: l_Res_rec.resource_code)
1248: AND WIP_GLOBALS.Equal(p_Res_rec.resource_id,
1242: AND WIP_GLOBALS.Equal(p_Res_rec.repetitive_schedule_id,
1243: l_Res_rec.repetitive_schedule_id)
1244: AND WIP_GLOBALS.Equal(p_Res_rec.request_id,
1245: l_Res_rec.request_id)
1246: AND WIP_GLOBALS.Equal(p_Res_rec.resource_code,
1247: l_Res_rec.resource_code)
1248: AND WIP_GLOBALS.Equal(p_Res_rec.resource_id,
1249: l_Res_rec.resource_id)
1250: AND WIP_GLOBALS.Equal(p_Res_rec.resource_seq_num,
1244: AND WIP_GLOBALS.Equal(p_Res_rec.request_id,
1245: l_Res_rec.request_id)
1246: AND WIP_GLOBALS.Equal(p_Res_rec.resource_code,
1247: l_Res_rec.resource_code)
1248: AND WIP_GLOBALS.Equal(p_Res_rec.resource_id,
1249: l_Res_rec.resource_id)
1250: AND WIP_GLOBALS.Equal(p_Res_rec.resource_seq_num,
1251: l_Res_rec.resource_seq_num)
1252: AND WIP_GLOBALS.Equal(p_Res_rec.resource_type,
1246: AND WIP_GLOBALS.Equal(p_Res_rec.resource_code,
1247: l_Res_rec.resource_code)
1248: AND WIP_GLOBALS.Equal(p_Res_rec.resource_id,
1249: l_Res_rec.resource_id)
1250: AND WIP_GLOBALS.Equal(p_Res_rec.resource_seq_num,
1251: l_Res_rec.resource_seq_num)
1252: AND WIP_GLOBALS.Equal(p_Res_rec.resource_type,
1253: l_Res_rec.resource_type)
1254: AND WIP_GLOBALS.Equal(p_Res_rec.source_code,
1248: AND WIP_GLOBALS.Equal(p_Res_rec.resource_id,
1249: l_Res_rec.resource_id)
1250: AND WIP_GLOBALS.Equal(p_Res_rec.resource_seq_num,
1251: l_Res_rec.resource_seq_num)
1252: AND WIP_GLOBALS.Equal(p_Res_rec.resource_type,
1253: l_Res_rec.resource_type)
1254: AND WIP_GLOBALS.Equal(p_Res_rec.source_code,
1255: l_Res_rec.source_code)
1256: AND WIP_GLOBALS.Equal(p_Res_rec.source_line_id,
1250: AND WIP_GLOBALS.Equal(p_Res_rec.resource_seq_num,
1251: l_Res_rec.resource_seq_num)
1252: AND WIP_GLOBALS.Equal(p_Res_rec.resource_type,
1253: l_Res_rec.resource_type)
1254: AND WIP_GLOBALS.Equal(p_Res_rec.source_code,
1255: l_Res_rec.source_code)
1256: AND WIP_GLOBALS.Equal(p_Res_rec.source_line_id,
1257: l_Res_rec.source_line_id)
1258: AND WIP_GLOBALS.Equal(p_Res_rec.standard_rate_flag,
1252: AND WIP_GLOBALS.Equal(p_Res_rec.resource_type,
1253: l_Res_rec.resource_type)
1254: AND WIP_GLOBALS.Equal(p_Res_rec.source_code,
1255: l_Res_rec.source_code)
1256: AND WIP_GLOBALS.Equal(p_Res_rec.source_line_id,
1257: l_Res_rec.source_line_id)
1258: AND WIP_GLOBALS.Equal(p_Res_rec.standard_rate_flag,
1259: l_Res_rec.standard_rate_flag)
1260: AND WIP_GLOBALS.Equal(p_Res_rec.task_id,
1254: AND WIP_GLOBALS.Equal(p_Res_rec.source_code,
1255: l_Res_rec.source_code)
1256: AND WIP_GLOBALS.Equal(p_Res_rec.source_line_id,
1257: l_Res_rec.source_line_id)
1258: AND WIP_GLOBALS.Equal(p_Res_rec.standard_rate_flag,
1259: l_Res_rec.standard_rate_flag)
1260: AND WIP_GLOBALS.Equal(p_Res_rec.task_id,
1261: l_Res_rec.task_id)
1262: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_date,
1256: AND WIP_GLOBALS.Equal(p_Res_rec.source_line_id,
1257: l_Res_rec.source_line_id)
1258: AND WIP_GLOBALS.Equal(p_Res_rec.standard_rate_flag,
1259: l_Res_rec.standard_rate_flag)
1260: AND WIP_GLOBALS.Equal(p_Res_rec.task_id,
1261: l_Res_rec.task_id)
1262: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_date,
1263: l_Res_rec.transaction_date)
1264: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_id,
1258: AND WIP_GLOBALS.Equal(p_Res_rec.standard_rate_flag,
1259: l_Res_rec.standard_rate_flag)
1260: AND WIP_GLOBALS.Equal(p_Res_rec.task_id,
1261: l_Res_rec.task_id)
1262: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_date,
1263: l_Res_rec.transaction_date)
1264: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_id,
1265: l_Res_rec.transaction_id)
1266: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_quantity,
1260: AND WIP_GLOBALS.Equal(p_Res_rec.task_id,
1261: l_Res_rec.task_id)
1262: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_date,
1263: l_Res_rec.transaction_date)
1264: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_id,
1265: l_Res_rec.transaction_id)
1266: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_quantity,
1267: l_Res_rec.transaction_quantity)
1268: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_type,
1262: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_date,
1263: l_Res_rec.transaction_date)
1264: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_id,
1265: l_Res_rec.transaction_id)
1266: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_quantity,
1267: l_Res_rec.transaction_quantity)
1268: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_type,
1269: l_Res_rec.transaction_type)
1270: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_uom,
1264: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_id,
1265: l_Res_rec.transaction_id)
1266: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_quantity,
1267: l_Res_rec.transaction_quantity)
1268: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_type,
1269: l_Res_rec.transaction_type)
1270: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_uom,
1271: l_Res_rec.transaction_uom)
1272: AND WIP_GLOBALS.Equal(p_Res_rec.usage_rate_or_amount,
1266: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_quantity,
1267: l_Res_rec.transaction_quantity)
1268: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_type,
1269: l_Res_rec.transaction_type)
1270: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_uom,
1271: l_Res_rec.transaction_uom)
1272: AND WIP_GLOBALS.Equal(p_Res_rec.usage_rate_or_amount,
1273: l_Res_rec.usage_rate_or_amount)
1274: AND WIP_GLOBALS.Equal(p_Res_rec.wip_entity_id,
1268: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_type,
1269: l_Res_rec.transaction_type)
1270: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_uom,
1271: l_Res_rec.transaction_uom)
1272: AND WIP_GLOBALS.Equal(p_Res_rec.usage_rate_or_amount,
1273: l_Res_rec.usage_rate_or_amount)
1274: AND WIP_GLOBALS.Equal(p_Res_rec.wip_entity_id,
1275: l_Res_rec.wip_entity_id)
1276: AND WIP_GLOBALS.Equal(p_Res_rec.wip_entity_name,
1270: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_uom,
1271: l_Res_rec.transaction_uom)
1272: AND WIP_GLOBALS.Equal(p_Res_rec.usage_rate_or_amount,
1273: l_Res_rec.usage_rate_or_amount)
1274: AND WIP_GLOBALS.Equal(p_Res_rec.wip_entity_id,
1275: l_Res_rec.wip_entity_id)
1276: AND WIP_GLOBALS.Equal(p_Res_rec.wip_entity_name,
1277: l_Res_rec.wip_entity_name)
1278: THEN
1272: AND WIP_GLOBALS.Equal(p_Res_rec.usage_rate_or_amount,
1273: l_Res_rec.usage_rate_or_amount)
1274: AND WIP_GLOBALS.Equal(p_Res_rec.wip_entity_id,
1275: l_Res_rec.wip_entity_id)
1276: AND WIP_GLOBALS.Equal(p_Res_rec.wip_entity_name,
1277: l_Res_rec.wip_entity_name)
1278: THEN
1279:
1280: -- Row has not changed. Set out parameter.