DBA Data[Home] [Help]

APPS.WIP_RES_UTIL dependencies on WIP_GLOBALS

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

Line 1170: AND WIP_GLOBALS.Equal(p_Res_rec.currency_conversion_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,
1173: l_Res_rec.currency_conversion_rate)
1174: AND WIP_GLOBALS.Equal(p_Res_rec.currency_conversion_type,

Line 1172: AND WIP_GLOBALS.Equal(p_Res_rec.currency_conversion_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,
1175: l_Res_rec.currency_conversion_type)
1176: AND WIP_GLOBALS.Equal(p_Res_rec.department_code,

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

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,

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

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,

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

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

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,

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

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,

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

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,

Line 1186: AND WIP_GLOBALS.Equal(p_Res_rec.group_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,
1189: l_Res_rec.last_updated_by)
1190: AND WIP_GLOBALS.Equal(p_Res_rec.last_updated_by_name,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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

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,

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

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,

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

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,

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

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

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

Line 1212: AND WIP_GLOBALS.Equal(p_Res_rec.primary_item_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,
1215: l_Res_rec.primary_quantity)
1216: AND WIP_GLOBALS.Equal(p_Res_rec.primary_uom,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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

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,

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

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,

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

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

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

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,

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

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,

Line 1238: AND WIP_GLOBALS.Equal(p_Res_rec.receiving_account_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,
1241: l_Res_rec.reference)
1242: AND WIP_GLOBALS.Equal(p_Res_rec.repetitive_schedule_id,

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

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,

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

Line 1244: AND WIP_GLOBALS.Equal(p_Res_rec.request_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,
1247: l_Res_rec.resource_code)
1248: AND WIP_GLOBALS.Equal(p_Res_rec.resource_id,

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

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,

Line 1248: AND WIP_GLOBALS.Equal(p_Res_rec.resource_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,
1251: l_Res_rec.resource_seq_num)
1252: AND WIP_GLOBALS.Equal(p_Res_rec.resource_type,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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

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

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.