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