DBA Data[Home] [Help]

APPS.WIP_RES_UTIL dependencies on WIP_GLOBALS

Line 1142: IF WIP_GLOBALS.Equal(p_Res_rec.acct_period_id,

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,

Line 1144: AND WIP_GLOBALS.Equal(p_Res_rec.activity_id,

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,

Line 1146: AND WIP_GLOBALS.Equal(p_Res_rec.activity_name,

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,

Line 1148: AND WIP_GLOBALS.Equal(p_Res_rec.actual_resource_rate,

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,

Line 1150: AND WIP_GLOBALS.Equal(p_Res_rec.attribute1,

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,

Line 1152: AND WIP_GLOBALS.Equal(p_Res_rec.attribute10,

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,

Line 1154: AND WIP_GLOBALS.Equal(p_Res_rec.attribute11,

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,

Line 1156: AND WIP_GLOBALS.Equal(p_Res_rec.attribute12,

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,

Line 1158: AND WIP_GLOBALS.Equal(p_Res_rec.attribute13,

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,

Line 1160: AND WIP_GLOBALS.Equal(p_Res_rec.attribute14,

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,

Line 1162: AND WIP_GLOBALS.Equal(p_Res_rec.attribute15,

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,

Line 1164: AND WIP_GLOBALS.Equal(p_Res_rec.attribute2,

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,

Line 1166: AND WIP_GLOBALS.Equal(p_Res_rec.attribute3,

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,

Line 1168: AND WIP_GLOBALS.Equal(p_Res_rec.attribute4,

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,

Line 1170: AND WIP_GLOBALS.Equal(p_Res_rec.attribute5,

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,

Line 1172: AND WIP_GLOBALS.Equal(p_Res_rec.attribute6,

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,

Line 1174: AND WIP_GLOBALS.Equal(p_Res_rec.attribute7,

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,

Line 1176: AND WIP_GLOBALS.Equal(p_Res_rec.attribute8,

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,

Line 1178: AND WIP_GLOBALS.Equal(p_Res_rec.attribute9,

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,

Line 1180: AND WIP_GLOBALS.Equal(p_Res_rec.attribute_category,

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,

Line 1182: AND WIP_GLOBALS.Equal(p_Res_rec.autocharge_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,

Line 1184: AND WIP_GLOBALS.Equal(p_Res_rec.basis_type,

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,

Line 1186: AND WIP_GLOBALS.Equal(p_Res_rec.completion_transaction_id,

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,

Line 1188: AND WIP_GLOBALS.Equal(p_Res_rec.created_by,

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,

Line 1190: AND WIP_GLOBALS.Equal(p_Res_rec.created_by_name,

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,

Line 1192: AND WIP_GLOBALS.Equal(p_Res_rec.creation_date,

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,

Line 1194: AND WIP_GLOBALS.Equal(p_Res_rec.currency_actual_rsc_rate,

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,

Line 1196: AND WIP_GLOBALS.Equal(p_Res_rec.currency_code,

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,

Line 1198: AND WIP_GLOBALS.Equal(p_Res_rec.currency_conversion_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,
1201: l_Res_rec.currency_conversion_rate)
1202: AND WIP_GLOBALS.Equal(p_Res_rec.currency_conversion_type,

Line 1200: AND WIP_GLOBALS.Equal(p_Res_rec.currency_conversion_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,
1203: l_Res_rec.currency_conversion_type)
1204: AND WIP_GLOBALS.Equal(p_Res_rec.department_code,

Line 1202: AND WIP_GLOBALS.Equal(p_Res_rec.currency_conversion_type,

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,

Line 1204: AND WIP_GLOBALS.Equal(p_Res_rec.department_code,

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,

Line 1206: AND WIP_GLOBALS.Equal(p_Res_rec.department_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,

Line 1208: AND WIP_GLOBALS.Equal(p_Res_rec.employee_id,

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,

Line 1210: AND WIP_GLOBALS.Equal(p_Res_rec.employee_num,

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,

Line 1212: AND WIP_GLOBALS.Equal(p_Res_rec.entity_type,

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,

Line 1214: AND WIP_GLOBALS.Equal(p_Res_rec.group_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,
1217: l_Res_rec.last_updated_by)
1218: AND WIP_GLOBALS.Equal(p_Res_rec.last_updated_by_name,

Line 1216: AND WIP_GLOBALS.Equal(p_Res_rec.last_updated_by,

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,

Line 1218: AND WIP_GLOBALS.Equal(p_Res_rec.last_updated_by_name,

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,

Line 1220: AND WIP_GLOBALS.Equal(p_Res_rec.last_update_date,

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,

Line 1222: AND WIP_GLOBALS.Equal(p_Res_rec.last_update_login,

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,

Line 1224: AND WIP_GLOBALS.Equal(p_Res_rec.line_code,

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,

Line 1226: AND WIP_GLOBALS.Equal(p_Res_rec.line_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,

Line 1228: AND WIP_GLOBALS.Equal(p_Res_rec.move_transaction_id,

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,

Line 1230: AND WIP_GLOBALS.Equal(p_Res_rec.operation_seq_num,

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,

Line 1232: AND WIP_GLOBALS.Equal(p_Res_rec.organization_code,

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,

Line 1234: AND WIP_GLOBALS.Equal(p_Res_rec.organization_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,

Line 1236: AND WIP_GLOBALS.Equal(p_Res_rec.po_header_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,

Line 1238: AND WIP_GLOBALS.Equal(p_Res_rec.po_line_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,

Line 1240: AND WIP_GLOBALS.Equal(p_Res_rec.primary_item_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,
1243: l_Res_rec.primary_quantity)
1244: AND WIP_GLOBALS.Equal(p_Res_rec.primary_uom,

Line 1242: AND WIP_GLOBALS.Equal(p_Res_rec.primary_quantity,

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,

Line 1244: AND WIP_GLOBALS.Equal(p_Res_rec.primary_uom,

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,

Line 1246: AND WIP_GLOBALS.Equal(p_Res_rec.primary_uom_class,

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,

Line 1248: AND WIP_GLOBALS.Equal(p_Res_rec.process_phase,

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,

Line 1250: AND WIP_GLOBALS.Equal(p_Res_rec.process_status,

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,

Line 1252: AND WIP_GLOBALS.Equal(p_Res_rec.program_application_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,

Line 1254: AND WIP_GLOBALS.Equal(p_Res_rec.program_id,

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,

Line 1256: AND WIP_GLOBALS.Equal(p_Res_rec.program_update_date,

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,

Line 1258: AND WIP_GLOBALS.Equal(p_Res_rec.project_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,

Line 1260: AND WIP_GLOBALS.Equal(p_Res_rec.rcv_transaction_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,

Line 1262: AND WIP_GLOBALS.Equal(p_Res_rec.reason_id,

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,

Line 1264: AND WIP_GLOBALS.Equal(p_Res_rec.reason_name,

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,

Line 1266: AND WIP_GLOBALS.Equal(p_Res_rec.receiving_account_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,
1269: l_Res_rec.reference)
1270: AND WIP_GLOBALS.Equal(p_Res_rec.repetitive_schedule_id,

Line 1268: AND WIP_GLOBALS.Equal(p_Res_rec.reference,

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,

Line 1270: AND WIP_GLOBALS.Equal(p_Res_rec.repetitive_schedule_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,

Line 1272: AND WIP_GLOBALS.Equal(p_Res_rec.request_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,
1275: l_Res_rec.resource_code)
1276: AND WIP_GLOBALS.Equal(p_Res_rec.resource_id,

Line 1274: AND WIP_GLOBALS.Equal(p_Res_rec.resource_code,

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,

Line 1276: AND WIP_GLOBALS.Equal(p_Res_rec.resource_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,
1279: l_Res_rec.resource_seq_num)
1280: AND WIP_GLOBALS.Equal(p_Res_rec.resource_type,

Line 1278: AND WIP_GLOBALS.Equal(p_Res_rec.resource_seq_num,

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,

Line 1280: AND WIP_GLOBALS.Equal(p_Res_rec.resource_type,

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,

Line 1282: AND WIP_GLOBALS.Equal(p_Res_rec.source_code,

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,

Line 1284: AND WIP_GLOBALS.Equal(p_Res_rec.source_line_id,

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,

Line 1286: AND WIP_GLOBALS.Equal(p_Res_rec.standard_rate_flag,

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,

Line 1288: AND WIP_GLOBALS.Equal(p_Res_rec.task_id,

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,

Line 1290: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_date,

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,

Line 1292: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_id,

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,

Line 1294: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_quantity,

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,

Line 1296: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_type,

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,

Line 1298: AND WIP_GLOBALS.Equal(p_Res_rec.transaction_uom,

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,

Line 1300: AND WIP_GLOBALS.Equal(p_Res_rec.usage_rate_or_amount,

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,

Line 1302: AND WIP_GLOBALS.Equal(p_Res_rec.wip_entity_id,

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

Line 1304: AND WIP_GLOBALS.Equal(p_Res_rec.wip_entity_name,

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.