1394: FOR UPDATE NOWAIT;
1395:
1396: -- Row locked. Compare IN attributes to DB attributes.
1397:
1398: IF WIP_GLOBALS.Equal(p_RepSchedule_rec.alternate_bom_designator,
1399: l_RepSchedule_rec.alternate_bom_designator)
1400: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.alternate_rout_designator,
1401: l_RepSchedule_rec.alternate_rout_designator)
1402: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute1,
1396: -- Row locked. Compare IN attributes to DB attributes.
1397:
1398: IF WIP_GLOBALS.Equal(p_RepSchedule_rec.alternate_bom_designator,
1399: l_RepSchedule_rec.alternate_bom_designator)
1400: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.alternate_rout_designator,
1401: l_RepSchedule_rec.alternate_rout_designator)
1402: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute1,
1403: l_RepSchedule_rec.attribute1)
1404: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute10,
1398: IF WIP_GLOBALS.Equal(p_RepSchedule_rec.alternate_bom_designator,
1399: l_RepSchedule_rec.alternate_bom_designator)
1400: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.alternate_rout_designator,
1401: l_RepSchedule_rec.alternate_rout_designator)
1402: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute1,
1403: l_RepSchedule_rec.attribute1)
1404: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute10,
1405: l_RepSchedule_rec.attribute10)
1406: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute11,
1400: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.alternate_rout_designator,
1401: l_RepSchedule_rec.alternate_rout_designator)
1402: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute1,
1403: l_RepSchedule_rec.attribute1)
1404: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute10,
1405: l_RepSchedule_rec.attribute10)
1406: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute11,
1407: l_RepSchedule_rec.attribute11)
1408: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute12,
1402: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute1,
1403: l_RepSchedule_rec.attribute1)
1404: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute10,
1405: l_RepSchedule_rec.attribute10)
1406: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute11,
1407: l_RepSchedule_rec.attribute11)
1408: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute12,
1409: l_RepSchedule_rec.attribute12)
1410: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute13,
1404: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute10,
1405: l_RepSchedule_rec.attribute10)
1406: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute11,
1407: l_RepSchedule_rec.attribute11)
1408: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute12,
1409: l_RepSchedule_rec.attribute12)
1410: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute13,
1411: l_RepSchedule_rec.attribute13)
1412: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute14,
1406: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute11,
1407: l_RepSchedule_rec.attribute11)
1408: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute12,
1409: l_RepSchedule_rec.attribute12)
1410: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute13,
1411: l_RepSchedule_rec.attribute13)
1412: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute14,
1413: l_RepSchedule_rec.attribute14)
1414: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute15,
1408: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute12,
1409: l_RepSchedule_rec.attribute12)
1410: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute13,
1411: l_RepSchedule_rec.attribute13)
1412: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute14,
1413: l_RepSchedule_rec.attribute14)
1414: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute15,
1415: l_RepSchedule_rec.attribute15)
1416: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute2,
1410: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute13,
1411: l_RepSchedule_rec.attribute13)
1412: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute14,
1413: l_RepSchedule_rec.attribute14)
1414: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute15,
1415: l_RepSchedule_rec.attribute15)
1416: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute2,
1417: l_RepSchedule_rec.attribute2)
1418: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute3,
1412: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute14,
1413: l_RepSchedule_rec.attribute14)
1414: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute15,
1415: l_RepSchedule_rec.attribute15)
1416: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute2,
1417: l_RepSchedule_rec.attribute2)
1418: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute3,
1419: l_RepSchedule_rec.attribute3)
1420: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute4,
1414: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute15,
1415: l_RepSchedule_rec.attribute15)
1416: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute2,
1417: l_RepSchedule_rec.attribute2)
1418: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute3,
1419: l_RepSchedule_rec.attribute3)
1420: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute4,
1421: l_RepSchedule_rec.attribute4)
1422: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute5,
1416: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute2,
1417: l_RepSchedule_rec.attribute2)
1418: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute3,
1419: l_RepSchedule_rec.attribute3)
1420: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute4,
1421: l_RepSchedule_rec.attribute4)
1422: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute5,
1423: l_RepSchedule_rec.attribute5)
1424: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute6,
1418: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute3,
1419: l_RepSchedule_rec.attribute3)
1420: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute4,
1421: l_RepSchedule_rec.attribute4)
1422: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute5,
1423: l_RepSchedule_rec.attribute5)
1424: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute6,
1425: l_RepSchedule_rec.attribute6)
1426: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute7,
1420: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute4,
1421: l_RepSchedule_rec.attribute4)
1422: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute5,
1423: l_RepSchedule_rec.attribute5)
1424: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute6,
1425: l_RepSchedule_rec.attribute6)
1426: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute7,
1427: l_RepSchedule_rec.attribute7)
1428: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute8,
1422: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute5,
1423: l_RepSchedule_rec.attribute5)
1424: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute6,
1425: l_RepSchedule_rec.attribute6)
1426: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute7,
1427: l_RepSchedule_rec.attribute7)
1428: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute8,
1429: l_RepSchedule_rec.attribute8)
1430: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute9,
1424: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute6,
1425: l_RepSchedule_rec.attribute6)
1426: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute7,
1427: l_RepSchedule_rec.attribute7)
1428: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute8,
1429: l_RepSchedule_rec.attribute8)
1430: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute9,
1431: l_RepSchedule_rec.attribute9)
1432: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute_category,
1426: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute7,
1427: l_RepSchedule_rec.attribute7)
1428: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute8,
1429: l_RepSchedule_rec.attribute8)
1430: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute9,
1431: l_RepSchedule_rec.attribute9)
1432: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute_category,
1433: l_RepSchedule_rec.attribute_category)
1434: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.bom_revision,
1428: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute8,
1429: l_RepSchedule_rec.attribute8)
1430: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute9,
1431: l_RepSchedule_rec.attribute9)
1432: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute_category,
1433: l_RepSchedule_rec.attribute_category)
1434: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.bom_revision,
1435: l_RepSchedule_rec.bom_revision)
1436: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.bom_revision_date,
1430: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute9,
1431: l_RepSchedule_rec.attribute9)
1432: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute_category,
1433: l_RepSchedule_rec.attribute_category)
1434: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.bom_revision,
1435: l_RepSchedule_rec.bom_revision)
1436: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.bom_revision_date,
1437: l_RepSchedule_rec.bom_revision_date)
1438: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.common_bom_sequence_id,
1432: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.attribute_category,
1433: l_RepSchedule_rec.attribute_category)
1434: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.bom_revision,
1435: l_RepSchedule_rec.bom_revision)
1436: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.bom_revision_date,
1437: l_RepSchedule_rec.bom_revision_date)
1438: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.common_bom_sequence_id,
1439: l_RepSchedule_rec.common_bom_sequence_id)
1440: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.common_rout_sequence_id,
1434: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.bom_revision,
1435: l_RepSchedule_rec.bom_revision)
1436: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.bom_revision_date,
1437: l_RepSchedule_rec.bom_revision_date)
1438: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.common_bom_sequence_id,
1439: l_RepSchedule_rec.common_bom_sequence_id)
1440: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.common_rout_sequence_id,
1441: l_RepSchedule_rec.common_rout_sequence_id)
1442: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.created_by,
1436: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.bom_revision_date,
1437: l_RepSchedule_rec.bom_revision_date)
1438: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.common_bom_sequence_id,
1439: l_RepSchedule_rec.common_bom_sequence_id)
1440: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.common_rout_sequence_id,
1441: l_RepSchedule_rec.common_rout_sequence_id)
1442: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.created_by,
1443: l_RepSchedule_rec.created_by)
1444: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.creation_date,
1438: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.common_bom_sequence_id,
1439: l_RepSchedule_rec.common_bom_sequence_id)
1440: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.common_rout_sequence_id,
1441: l_RepSchedule_rec.common_rout_sequence_id)
1442: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.created_by,
1443: l_RepSchedule_rec.created_by)
1444: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.creation_date,
1445: l_RepSchedule_rec.creation_date)
1446: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.daily_production_rate,
1440: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.common_rout_sequence_id,
1441: l_RepSchedule_rec.common_rout_sequence_id)
1442: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.created_by,
1443: l_RepSchedule_rec.created_by)
1444: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.creation_date,
1445: l_RepSchedule_rec.creation_date)
1446: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.daily_production_rate,
1447: l_RepSchedule_rec.daily_production_rate)
1448: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.date_closed,
1442: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.created_by,
1443: l_RepSchedule_rec.created_by)
1444: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.creation_date,
1445: l_RepSchedule_rec.creation_date)
1446: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.daily_production_rate,
1447: l_RepSchedule_rec.daily_production_rate)
1448: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.date_closed,
1449: l_RepSchedule_rec.date_closed)
1450: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.date_released,
1444: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.creation_date,
1445: l_RepSchedule_rec.creation_date)
1446: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.daily_production_rate,
1447: l_RepSchedule_rec.daily_production_rate)
1448: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.date_closed,
1449: l_RepSchedule_rec.date_closed)
1450: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.date_released,
1451: l_RepSchedule_rec.date_released)
1452: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.demand_class,
1446: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.daily_production_rate,
1447: l_RepSchedule_rec.daily_production_rate)
1448: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.date_closed,
1449: l_RepSchedule_rec.date_closed)
1450: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.date_released,
1451: l_RepSchedule_rec.date_released)
1452: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.demand_class,
1453: l_RepSchedule_rec.demand_class)
1454: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.description,
1448: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.date_closed,
1449: l_RepSchedule_rec.date_closed)
1450: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.date_released,
1451: l_RepSchedule_rec.date_released)
1452: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.demand_class,
1453: l_RepSchedule_rec.demand_class)
1454: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.description,
1455: l_RepSchedule_rec.description)
1456: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.firm_planned_flag,
1450: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.date_released,
1451: l_RepSchedule_rec.date_released)
1452: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.demand_class,
1453: l_RepSchedule_rec.demand_class)
1454: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.description,
1455: l_RepSchedule_rec.description)
1456: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.firm_planned_flag,
1457: l_RepSchedule_rec.firm_planned_flag)
1458: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.first_unit_cpl_date,
1452: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.demand_class,
1453: l_RepSchedule_rec.demand_class)
1454: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.description,
1455: l_RepSchedule_rec.description)
1456: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.firm_planned_flag,
1457: l_RepSchedule_rec.firm_planned_flag)
1458: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.first_unit_cpl_date,
1459: l_RepSchedule_rec.first_unit_cpl_date)
1460: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.first_unit_start_date,
1454: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.description,
1455: l_RepSchedule_rec.description)
1456: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.firm_planned_flag,
1457: l_RepSchedule_rec.firm_planned_flag)
1458: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.first_unit_cpl_date,
1459: l_RepSchedule_rec.first_unit_cpl_date)
1460: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.first_unit_start_date,
1461: l_RepSchedule_rec.first_unit_start_date)
1462: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_unit_cpl_date,
1456: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.firm_planned_flag,
1457: l_RepSchedule_rec.firm_planned_flag)
1458: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.first_unit_cpl_date,
1459: l_RepSchedule_rec.first_unit_cpl_date)
1460: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.first_unit_start_date,
1461: l_RepSchedule_rec.first_unit_start_date)
1462: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_unit_cpl_date,
1463: l_RepSchedule_rec.last_unit_cpl_date)
1464: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_unit_start_date,
1458: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.first_unit_cpl_date,
1459: l_RepSchedule_rec.first_unit_cpl_date)
1460: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.first_unit_start_date,
1461: l_RepSchedule_rec.first_unit_start_date)
1462: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_unit_cpl_date,
1463: l_RepSchedule_rec.last_unit_cpl_date)
1464: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_unit_start_date,
1465: l_RepSchedule_rec.last_unit_start_date)
1466: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_updated_by,
1460: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.first_unit_start_date,
1461: l_RepSchedule_rec.first_unit_start_date)
1462: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_unit_cpl_date,
1463: l_RepSchedule_rec.last_unit_cpl_date)
1464: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_unit_start_date,
1465: l_RepSchedule_rec.last_unit_start_date)
1466: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_updated_by,
1467: l_RepSchedule_rec.last_updated_by)
1468: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_update_date,
1462: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_unit_cpl_date,
1463: l_RepSchedule_rec.last_unit_cpl_date)
1464: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_unit_start_date,
1465: l_RepSchedule_rec.last_unit_start_date)
1466: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_updated_by,
1467: l_RepSchedule_rec.last_updated_by)
1468: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_update_date,
1469: l_RepSchedule_rec.last_update_date)
1470: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_update_login,
1464: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_unit_start_date,
1465: l_RepSchedule_rec.last_unit_start_date)
1466: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_updated_by,
1467: l_RepSchedule_rec.last_updated_by)
1468: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_update_date,
1469: l_RepSchedule_rec.last_update_date)
1470: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_update_login,
1471: l_RepSchedule_rec.last_update_login)
1472: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.line_id,
1466: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_updated_by,
1467: l_RepSchedule_rec.last_updated_by)
1468: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_update_date,
1469: l_RepSchedule_rec.last_update_date)
1470: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_update_login,
1471: l_RepSchedule_rec.last_update_login)
1472: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.line_id,
1473: l_RepSchedule_rec.line_id)
1474: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.material_account,
1468: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_update_date,
1469: l_RepSchedule_rec.last_update_date)
1470: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_update_login,
1471: l_RepSchedule_rec.last_update_login)
1472: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.line_id,
1473: l_RepSchedule_rec.line_id)
1474: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.material_account,
1475: l_RepSchedule_rec.material_account)
1476: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.material_overhead_account,
1470: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_update_login,
1471: l_RepSchedule_rec.last_update_login)
1472: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.line_id,
1473: l_RepSchedule_rec.line_id)
1474: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.material_account,
1475: l_RepSchedule_rec.material_account)
1476: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.material_overhead_account,
1477: l_RepSchedule_rec.material_overhead_account)
1478: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.material_variance_account,
1472: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.line_id,
1473: l_RepSchedule_rec.line_id)
1474: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.material_account,
1475: l_RepSchedule_rec.material_account)
1476: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.material_overhead_account,
1477: l_RepSchedule_rec.material_overhead_account)
1478: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.material_variance_account,
1479: l_RepSchedule_rec.material_variance_account)
1480: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.organization_id,
1474: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.material_account,
1475: l_RepSchedule_rec.material_account)
1476: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.material_overhead_account,
1477: l_RepSchedule_rec.material_overhead_account)
1478: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.material_variance_account,
1479: l_RepSchedule_rec.material_variance_account)
1480: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.organization_id,
1481: l_RepSchedule_rec.organization_id)
1482: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.osp_account,
1476: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.material_overhead_account,
1477: l_RepSchedule_rec.material_overhead_account)
1478: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.material_variance_account,
1479: l_RepSchedule_rec.material_variance_account)
1480: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.organization_id,
1481: l_RepSchedule_rec.organization_id)
1482: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.osp_account,
1483: l_RepSchedule_rec.osp_account)
1484: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.osp_variance_account,
1478: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.material_variance_account,
1479: l_RepSchedule_rec.material_variance_account)
1480: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.organization_id,
1481: l_RepSchedule_rec.organization_id)
1482: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.osp_account,
1483: l_RepSchedule_rec.osp_account)
1484: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.osp_variance_account,
1485: l_RepSchedule_rec.osp_variance_account)
1486: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.overhead_account,
1480: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.organization_id,
1481: l_RepSchedule_rec.organization_id)
1482: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.osp_account,
1483: l_RepSchedule_rec.osp_account)
1484: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.osp_variance_account,
1485: l_RepSchedule_rec.osp_variance_account)
1486: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.overhead_account,
1487: l_RepSchedule_rec.overhead_account)
1488: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.overhead_variance_account,
1482: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.osp_account,
1483: l_RepSchedule_rec.osp_account)
1484: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.osp_variance_account,
1485: l_RepSchedule_rec.osp_variance_account)
1486: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.overhead_account,
1487: l_RepSchedule_rec.overhead_account)
1488: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.overhead_variance_account,
1489: l_RepSchedule_rec.overhead_variance_account)
1490: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.processing_work_days,
1484: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.osp_variance_account,
1485: l_RepSchedule_rec.osp_variance_account)
1486: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.overhead_account,
1487: l_RepSchedule_rec.overhead_account)
1488: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.overhead_variance_account,
1489: l_RepSchedule_rec.overhead_variance_account)
1490: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.processing_work_days,
1491: l_RepSchedule_rec.processing_work_days)
1492: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.program_application_id,
1486: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.overhead_account,
1487: l_RepSchedule_rec.overhead_account)
1488: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.overhead_variance_account,
1489: l_RepSchedule_rec.overhead_variance_account)
1490: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.processing_work_days,
1491: l_RepSchedule_rec.processing_work_days)
1492: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.program_application_id,
1493: l_RepSchedule_rec.program_application_id)
1494: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.program_id,
1488: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.overhead_variance_account,
1489: l_RepSchedule_rec.overhead_variance_account)
1490: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.processing_work_days,
1491: l_RepSchedule_rec.processing_work_days)
1492: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.program_application_id,
1493: l_RepSchedule_rec.program_application_id)
1494: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.program_id,
1495: l_RepSchedule_rec.program_id)
1496: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.program_update_date,
1490: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.processing_work_days,
1491: l_RepSchedule_rec.processing_work_days)
1492: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.program_application_id,
1493: l_RepSchedule_rec.program_application_id)
1494: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.program_id,
1495: l_RepSchedule_rec.program_id)
1496: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.program_update_date,
1497: l_RepSchedule_rec.program_update_date)
1498: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.quantity_completed,
1492: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.program_application_id,
1493: l_RepSchedule_rec.program_application_id)
1494: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.program_id,
1495: l_RepSchedule_rec.program_id)
1496: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.program_update_date,
1497: l_RepSchedule_rec.program_update_date)
1498: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.quantity_completed,
1499: l_RepSchedule_rec.quantity_completed)
1500: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.repetitive_schedule_id,
1494: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.program_id,
1495: l_RepSchedule_rec.program_id)
1496: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.program_update_date,
1497: l_RepSchedule_rec.program_update_date)
1498: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.quantity_completed,
1499: l_RepSchedule_rec.quantity_completed)
1500: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.repetitive_schedule_id,
1501: l_RepSchedule_rec.repetitive_schedule_id)
1502: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.request_id,
1496: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.program_update_date,
1497: l_RepSchedule_rec.program_update_date)
1498: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.quantity_completed,
1499: l_RepSchedule_rec.quantity_completed)
1500: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.repetitive_schedule_id,
1501: l_RepSchedule_rec.repetitive_schedule_id)
1502: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.request_id,
1503: l_RepSchedule_rec.request_id)
1504: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.resource_account,
1498: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.quantity_completed,
1499: l_RepSchedule_rec.quantity_completed)
1500: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.repetitive_schedule_id,
1501: l_RepSchedule_rec.repetitive_schedule_id)
1502: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.request_id,
1503: l_RepSchedule_rec.request_id)
1504: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.resource_account,
1505: l_RepSchedule_rec.resource_account)
1506: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.resource_variance_account,
1500: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.repetitive_schedule_id,
1501: l_RepSchedule_rec.repetitive_schedule_id)
1502: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.request_id,
1503: l_RepSchedule_rec.request_id)
1504: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.resource_account,
1505: l_RepSchedule_rec.resource_account)
1506: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.resource_variance_account,
1507: l_RepSchedule_rec.resource_variance_account)
1508: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.routing_revision,
1502: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.request_id,
1503: l_RepSchedule_rec.request_id)
1504: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.resource_account,
1505: l_RepSchedule_rec.resource_account)
1506: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.resource_variance_account,
1507: l_RepSchedule_rec.resource_variance_account)
1508: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.routing_revision,
1509: l_RepSchedule_rec.routing_revision)
1510: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.routing_revision_date,
1504: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.resource_account,
1505: l_RepSchedule_rec.resource_account)
1506: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.resource_variance_account,
1507: l_RepSchedule_rec.resource_variance_account)
1508: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.routing_revision,
1509: l_RepSchedule_rec.routing_revision)
1510: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.routing_revision_date,
1511: l_RepSchedule_rec.routing_revision_date)
1512: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.status_type,
1506: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.resource_variance_account,
1507: l_RepSchedule_rec.resource_variance_account)
1508: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.routing_revision,
1509: l_RepSchedule_rec.routing_revision)
1510: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.routing_revision_date,
1511: l_RepSchedule_rec.routing_revision_date)
1512: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.status_type,
1513: l_RepSchedule_rec.status_type)
1514: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.wip_entity_id,
1508: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.routing_revision,
1509: l_RepSchedule_rec.routing_revision)
1510: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.routing_revision_date,
1511: l_RepSchedule_rec.routing_revision_date)
1512: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.status_type,
1513: l_RepSchedule_rec.status_type)
1514: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.wip_entity_id,
1515: l_RepSchedule_rec.wip_entity_id)
1516: THEN
1510: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.routing_revision_date,
1511: l_RepSchedule_rec.routing_revision_date)
1512: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.status_type,
1513: l_RepSchedule_rec.status_type)
1514: AND WIP_GLOBALS.Equal(p_RepSchedule_rec.wip_entity_id,
1515: l_RepSchedule_rec.wip_entity_id)
1516: THEN
1517:
1518: -- Row has not changed. Set out parameter.
1588: RETURN BOOLEAN
1589: IS
1590: BEGIN
1591:
1592: IF WIP_GLOBALS.Equal(p_RepSchedule_rec1.alternate_bom_designator,
1593: p_RepSchedule_rec2.alternate_bom_designator)
1594: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.alternate_rout_designator,
1595: p_RepSchedule_rec2.alternate_rout_designator)
1596: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute1,
1590: BEGIN
1591:
1592: IF WIP_GLOBALS.Equal(p_RepSchedule_rec1.alternate_bom_designator,
1593: p_RepSchedule_rec2.alternate_bom_designator)
1594: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.alternate_rout_designator,
1595: p_RepSchedule_rec2.alternate_rout_designator)
1596: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute1,
1597: p_RepSchedule_rec2.attribute1)
1598: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute10,
1592: IF WIP_GLOBALS.Equal(p_RepSchedule_rec1.alternate_bom_designator,
1593: p_RepSchedule_rec2.alternate_bom_designator)
1594: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.alternate_rout_designator,
1595: p_RepSchedule_rec2.alternate_rout_designator)
1596: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute1,
1597: p_RepSchedule_rec2.attribute1)
1598: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute10,
1599: p_RepSchedule_rec2.attribute10)
1600: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute11,
1594: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.alternate_rout_designator,
1595: p_RepSchedule_rec2.alternate_rout_designator)
1596: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute1,
1597: p_RepSchedule_rec2.attribute1)
1598: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute10,
1599: p_RepSchedule_rec2.attribute10)
1600: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute11,
1601: p_RepSchedule_rec2.attribute11)
1602: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute12,
1596: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute1,
1597: p_RepSchedule_rec2.attribute1)
1598: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute10,
1599: p_RepSchedule_rec2.attribute10)
1600: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute11,
1601: p_RepSchedule_rec2.attribute11)
1602: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute12,
1603: p_RepSchedule_rec2.attribute12)
1604: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute13,
1598: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute10,
1599: p_RepSchedule_rec2.attribute10)
1600: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute11,
1601: p_RepSchedule_rec2.attribute11)
1602: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute12,
1603: p_RepSchedule_rec2.attribute12)
1604: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute13,
1605: p_RepSchedule_rec2.attribute13)
1606: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute14,
1600: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute11,
1601: p_RepSchedule_rec2.attribute11)
1602: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute12,
1603: p_RepSchedule_rec2.attribute12)
1604: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute13,
1605: p_RepSchedule_rec2.attribute13)
1606: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute14,
1607: p_RepSchedule_rec2.attribute14)
1608: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute15,
1602: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute12,
1603: p_RepSchedule_rec2.attribute12)
1604: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute13,
1605: p_RepSchedule_rec2.attribute13)
1606: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute14,
1607: p_RepSchedule_rec2.attribute14)
1608: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute15,
1609: p_RepSchedule_rec2.attribute15)
1610: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute2,
1604: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute13,
1605: p_RepSchedule_rec2.attribute13)
1606: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute14,
1607: p_RepSchedule_rec2.attribute14)
1608: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute15,
1609: p_RepSchedule_rec2.attribute15)
1610: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute2,
1611: p_RepSchedule_rec2.attribute2)
1612: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute3,
1606: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute14,
1607: p_RepSchedule_rec2.attribute14)
1608: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute15,
1609: p_RepSchedule_rec2.attribute15)
1610: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute2,
1611: p_RepSchedule_rec2.attribute2)
1612: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute3,
1613: p_RepSchedule_rec2.attribute3)
1614: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute4,
1608: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute15,
1609: p_RepSchedule_rec2.attribute15)
1610: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute2,
1611: p_RepSchedule_rec2.attribute2)
1612: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute3,
1613: p_RepSchedule_rec2.attribute3)
1614: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute4,
1615: p_RepSchedule_rec2.attribute4)
1616: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute5,
1610: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute2,
1611: p_RepSchedule_rec2.attribute2)
1612: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute3,
1613: p_RepSchedule_rec2.attribute3)
1614: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute4,
1615: p_RepSchedule_rec2.attribute4)
1616: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute5,
1617: p_RepSchedule_rec2.attribute5)
1618: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute6,
1612: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute3,
1613: p_RepSchedule_rec2.attribute3)
1614: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute4,
1615: p_RepSchedule_rec2.attribute4)
1616: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute5,
1617: p_RepSchedule_rec2.attribute5)
1618: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute6,
1619: p_RepSchedule_rec2.attribute6)
1620: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute7,
1614: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute4,
1615: p_RepSchedule_rec2.attribute4)
1616: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute5,
1617: p_RepSchedule_rec2.attribute5)
1618: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute6,
1619: p_RepSchedule_rec2.attribute6)
1620: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute7,
1621: p_RepSchedule_rec2.attribute7)
1622: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute8,
1616: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute5,
1617: p_RepSchedule_rec2.attribute5)
1618: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute6,
1619: p_RepSchedule_rec2.attribute6)
1620: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute7,
1621: p_RepSchedule_rec2.attribute7)
1622: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute8,
1623: p_RepSchedule_rec2.attribute8)
1624: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute9,
1618: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute6,
1619: p_RepSchedule_rec2.attribute6)
1620: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute7,
1621: p_RepSchedule_rec2.attribute7)
1622: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute8,
1623: p_RepSchedule_rec2.attribute8)
1624: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute9,
1625: p_RepSchedule_rec2.attribute9)
1626: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute_category,
1620: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute7,
1621: p_RepSchedule_rec2.attribute7)
1622: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute8,
1623: p_RepSchedule_rec2.attribute8)
1624: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute9,
1625: p_RepSchedule_rec2.attribute9)
1626: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute_category,
1627: p_RepSchedule_rec2.attribute_category)
1628: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.bom_revision,
1622: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute8,
1623: p_RepSchedule_rec2.attribute8)
1624: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute9,
1625: p_RepSchedule_rec2.attribute9)
1626: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute_category,
1627: p_RepSchedule_rec2.attribute_category)
1628: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.bom_revision,
1629: p_RepSchedule_rec2.bom_revision)
1630: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.bom_revision_date,
1624: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute9,
1625: p_RepSchedule_rec2.attribute9)
1626: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute_category,
1627: p_RepSchedule_rec2.attribute_category)
1628: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.bom_revision,
1629: p_RepSchedule_rec2.bom_revision)
1630: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.bom_revision_date,
1631: p_RepSchedule_rec2.bom_revision_date)
1632: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.common_bom_sequence_id,
1626: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.attribute_category,
1627: p_RepSchedule_rec2.attribute_category)
1628: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.bom_revision,
1629: p_RepSchedule_rec2.bom_revision)
1630: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.bom_revision_date,
1631: p_RepSchedule_rec2.bom_revision_date)
1632: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.common_bom_sequence_id,
1633: p_RepSchedule_rec2.common_bom_sequence_id)
1634: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.common_rout_sequence_id,
1628: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.bom_revision,
1629: p_RepSchedule_rec2.bom_revision)
1630: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.bom_revision_date,
1631: p_RepSchedule_rec2.bom_revision_date)
1632: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.common_bom_sequence_id,
1633: p_RepSchedule_rec2.common_bom_sequence_id)
1634: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.common_rout_sequence_id,
1635: p_RepSchedule_rec2.common_rout_sequence_id)
1636: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.created_by,
1630: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.bom_revision_date,
1631: p_RepSchedule_rec2.bom_revision_date)
1632: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.common_bom_sequence_id,
1633: p_RepSchedule_rec2.common_bom_sequence_id)
1634: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.common_rout_sequence_id,
1635: p_RepSchedule_rec2.common_rout_sequence_id)
1636: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.created_by,
1637: p_RepSchedule_rec2.created_by)
1638: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.creation_date,
1632: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.common_bom_sequence_id,
1633: p_RepSchedule_rec2.common_bom_sequence_id)
1634: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.common_rout_sequence_id,
1635: p_RepSchedule_rec2.common_rout_sequence_id)
1636: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.created_by,
1637: p_RepSchedule_rec2.created_by)
1638: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.creation_date,
1639: p_RepSchedule_rec2.creation_date)
1640: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.daily_production_rate,
1634: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.common_rout_sequence_id,
1635: p_RepSchedule_rec2.common_rout_sequence_id)
1636: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.created_by,
1637: p_RepSchedule_rec2.created_by)
1638: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.creation_date,
1639: p_RepSchedule_rec2.creation_date)
1640: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.daily_production_rate,
1641: p_RepSchedule_rec2.daily_production_rate)
1642: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.date_closed,
1636: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.created_by,
1637: p_RepSchedule_rec2.created_by)
1638: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.creation_date,
1639: p_RepSchedule_rec2.creation_date)
1640: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.daily_production_rate,
1641: p_RepSchedule_rec2.daily_production_rate)
1642: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.date_closed,
1643: p_RepSchedule_rec2.date_closed)
1644: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.date_released,
1638: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.creation_date,
1639: p_RepSchedule_rec2.creation_date)
1640: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.daily_production_rate,
1641: p_RepSchedule_rec2.daily_production_rate)
1642: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.date_closed,
1643: p_RepSchedule_rec2.date_closed)
1644: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.date_released,
1645: p_RepSchedule_rec2.date_released)
1646: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.demand_class,
1640: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.daily_production_rate,
1641: p_RepSchedule_rec2.daily_production_rate)
1642: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.date_closed,
1643: p_RepSchedule_rec2.date_closed)
1644: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.date_released,
1645: p_RepSchedule_rec2.date_released)
1646: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.demand_class,
1647: p_RepSchedule_rec2.demand_class)
1648: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.description,
1642: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.date_closed,
1643: p_RepSchedule_rec2.date_closed)
1644: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.date_released,
1645: p_RepSchedule_rec2.date_released)
1646: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.demand_class,
1647: p_RepSchedule_rec2.demand_class)
1648: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.description,
1649: p_RepSchedule_rec2.description)
1650: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.firm_planned_flag,
1644: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.date_released,
1645: p_RepSchedule_rec2.date_released)
1646: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.demand_class,
1647: p_RepSchedule_rec2.demand_class)
1648: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.description,
1649: p_RepSchedule_rec2.description)
1650: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.firm_planned_flag,
1651: p_RepSchedule_rec2.firm_planned_flag)
1652: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.first_unit_cpl_date,
1646: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.demand_class,
1647: p_RepSchedule_rec2.demand_class)
1648: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.description,
1649: p_RepSchedule_rec2.description)
1650: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.firm_planned_flag,
1651: p_RepSchedule_rec2.firm_planned_flag)
1652: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.first_unit_cpl_date,
1653: p_RepSchedule_rec2.first_unit_cpl_date)
1654: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.first_unit_start_date,
1648: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.description,
1649: p_RepSchedule_rec2.description)
1650: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.firm_planned_flag,
1651: p_RepSchedule_rec2.firm_planned_flag)
1652: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.first_unit_cpl_date,
1653: p_RepSchedule_rec2.first_unit_cpl_date)
1654: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.first_unit_start_date,
1655: p_RepSchedule_rec2.first_unit_start_date)
1656: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_unit_cpl_date,
1650: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.firm_planned_flag,
1651: p_RepSchedule_rec2.firm_planned_flag)
1652: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.first_unit_cpl_date,
1653: p_RepSchedule_rec2.first_unit_cpl_date)
1654: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.first_unit_start_date,
1655: p_RepSchedule_rec2.first_unit_start_date)
1656: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_unit_cpl_date,
1657: p_RepSchedule_rec2.last_unit_cpl_date)
1658: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_unit_start_date,
1652: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.first_unit_cpl_date,
1653: p_RepSchedule_rec2.first_unit_cpl_date)
1654: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.first_unit_start_date,
1655: p_RepSchedule_rec2.first_unit_start_date)
1656: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_unit_cpl_date,
1657: p_RepSchedule_rec2.last_unit_cpl_date)
1658: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_unit_start_date,
1659: p_RepSchedule_rec2.last_unit_start_date)
1660: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_updated_by,
1654: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.first_unit_start_date,
1655: p_RepSchedule_rec2.first_unit_start_date)
1656: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_unit_cpl_date,
1657: p_RepSchedule_rec2.last_unit_cpl_date)
1658: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_unit_start_date,
1659: p_RepSchedule_rec2.last_unit_start_date)
1660: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_updated_by,
1661: p_RepSchedule_rec2.last_updated_by)
1662: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_update_date,
1656: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_unit_cpl_date,
1657: p_RepSchedule_rec2.last_unit_cpl_date)
1658: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_unit_start_date,
1659: p_RepSchedule_rec2.last_unit_start_date)
1660: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_updated_by,
1661: p_RepSchedule_rec2.last_updated_by)
1662: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_update_date,
1663: p_RepSchedule_rec2.last_update_date)
1664: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_update_login,
1658: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_unit_start_date,
1659: p_RepSchedule_rec2.last_unit_start_date)
1660: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_updated_by,
1661: p_RepSchedule_rec2.last_updated_by)
1662: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_update_date,
1663: p_RepSchedule_rec2.last_update_date)
1664: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_update_login,
1665: p_RepSchedule_rec2.last_update_login)
1666: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.line_id,
1660: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_updated_by,
1661: p_RepSchedule_rec2.last_updated_by)
1662: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_update_date,
1663: p_RepSchedule_rec2.last_update_date)
1664: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_update_login,
1665: p_RepSchedule_rec2.last_update_login)
1666: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.line_id,
1667: p_RepSchedule_rec2.line_id)
1668: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.material_account,
1662: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_update_date,
1663: p_RepSchedule_rec2.last_update_date)
1664: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_update_login,
1665: p_RepSchedule_rec2.last_update_login)
1666: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.line_id,
1667: p_RepSchedule_rec2.line_id)
1668: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.material_account,
1669: p_RepSchedule_rec2.material_account)
1670: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.material_overhead_account,
1664: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_update_login,
1665: p_RepSchedule_rec2.last_update_login)
1666: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.line_id,
1667: p_RepSchedule_rec2.line_id)
1668: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.material_account,
1669: p_RepSchedule_rec2.material_account)
1670: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.material_overhead_account,
1671: p_RepSchedule_rec2.material_overhead_account)
1672: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.material_variance_account,
1666: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.line_id,
1667: p_RepSchedule_rec2.line_id)
1668: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.material_account,
1669: p_RepSchedule_rec2.material_account)
1670: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.material_overhead_account,
1671: p_RepSchedule_rec2.material_overhead_account)
1672: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.material_variance_account,
1673: p_RepSchedule_rec2.material_variance_account)
1674: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.organization_id,
1668: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.material_account,
1669: p_RepSchedule_rec2.material_account)
1670: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.material_overhead_account,
1671: p_RepSchedule_rec2.material_overhead_account)
1672: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.material_variance_account,
1673: p_RepSchedule_rec2.material_variance_account)
1674: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.organization_id,
1675: p_RepSchedule_rec2.organization_id)
1676: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.osp_account,
1670: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.material_overhead_account,
1671: p_RepSchedule_rec2.material_overhead_account)
1672: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.material_variance_account,
1673: p_RepSchedule_rec2.material_variance_account)
1674: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.organization_id,
1675: p_RepSchedule_rec2.organization_id)
1676: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.osp_account,
1677: p_RepSchedule_rec2.osp_account)
1678: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.osp_variance_account,
1672: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.material_variance_account,
1673: p_RepSchedule_rec2.material_variance_account)
1674: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.organization_id,
1675: p_RepSchedule_rec2.organization_id)
1676: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.osp_account,
1677: p_RepSchedule_rec2.osp_account)
1678: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.osp_variance_account,
1679: p_RepSchedule_rec2.osp_variance_account)
1680: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.overhead_account,
1674: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.organization_id,
1675: p_RepSchedule_rec2.organization_id)
1676: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.osp_account,
1677: p_RepSchedule_rec2.osp_account)
1678: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.osp_variance_account,
1679: p_RepSchedule_rec2.osp_variance_account)
1680: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.overhead_account,
1681: p_RepSchedule_rec2.overhead_account)
1682: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.overhead_variance_account,
1676: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.osp_account,
1677: p_RepSchedule_rec2.osp_account)
1678: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.osp_variance_account,
1679: p_RepSchedule_rec2.osp_variance_account)
1680: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.overhead_account,
1681: p_RepSchedule_rec2.overhead_account)
1682: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.overhead_variance_account,
1683: p_RepSchedule_rec2.overhead_variance_account)
1684: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.processing_work_days,
1678: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.osp_variance_account,
1679: p_RepSchedule_rec2.osp_variance_account)
1680: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.overhead_account,
1681: p_RepSchedule_rec2.overhead_account)
1682: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.overhead_variance_account,
1683: p_RepSchedule_rec2.overhead_variance_account)
1684: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.processing_work_days,
1685: p_RepSchedule_rec2.processing_work_days)
1686: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.program_application_id,
1680: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.overhead_account,
1681: p_RepSchedule_rec2.overhead_account)
1682: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.overhead_variance_account,
1683: p_RepSchedule_rec2.overhead_variance_account)
1684: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.processing_work_days,
1685: p_RepSchedule_rec2.processing_work_days)
1686: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.program_application_id,
1687: p_RepSchedule_rec2.program_application_id)
1688: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.program_id,
1682: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.overhead_variance_account,
1683: p_RepSchedule_rec2.overhead_variance_account)
1684: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.processing_work_days,
1685: p_RepSchedule_rec2.processing_work_days)
1686: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.program_application_id,
1687: p_RepSchedule_rec2.program_application_id)
1688: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.program_id,
1689: p_RepSchedule_rec2.program_id)
1690: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.program_update_date,
1684: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.processing_work_days,
1685: p_RepSchedule_rec2.processing_work_days)
1686: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.program_application_id,
1687: p_RepSchedule_rec2.program_application_id)
1688: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.program_id,
1689: p_RepSchedule_rec2.program_id)
1690: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.program_update_date,
1691: p_RepSchedule_rec2.program_update_date)
1692: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.quantity_completed,
1686: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.program_application_id,
1687: p_RepSchedule_rec2.program_application_id)
1688: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.program_id,
1689: p_RepSchedule_rec2.program_id)
1690: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.program_update_date,
1691: p_RepSchedule_rec2.program_update_date)
1692: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.quantity_completed,
1693: p_RepSchedule_rec2.quantity_completed)
1694: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.repetitive_schedule_id,
1688: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.program_id,
1689: p_RepSchedule_rec2.program_id)
1690: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.program_update_date,
1691: p_RepSchedule_rec2.program_update_date)
1692: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.quantity_completed,
1693: p_RepSchedule_rec2.quantity_completed)
1694: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.repetitive_schedule_id,
1695: p_RepSchedule_rec2.repetitive_schedule_id)
1696: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.request_id,
1690: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.program_update_date,
1691: p_RepSchedule_rec2.program_update_date)
1692: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.quantity_completed,
1693: p_RepSchedule_rec2.quantity_completed)
1694: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.repetitive_schedule_id,
1695: p_RepSchedule_rec2.repetitive_schedule_id)
1696: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.request_id,
1697: p_RepSchedule_rec2.request_id)
1698: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.resource_account,
1692: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.quantity_completed,
1693: p_RepSchedule_rec2.quantity_completed)
1694: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.repetitive_schedule_id,
1695: p_RepSchedule_rec2.repetitive_schedule_id)
1696: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.request_id,
1697: p_RepSchedule_rec2.request_id)
1698: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.resource_account,
1699: p_RepSchedule_rec2.resource_account)
1700: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.resource_variance_account,
1694: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.repetitive_schedule_id,
1695: p_RepSchedule_rec2.repetitive_schedule_id)
1696: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.request_id,
1697: p_RepSchedule_rec2.request_id)
1698: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.resource_account,
1699: p_RepSchedule_rec2.resource_account)
1700: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.resource_variance_account,
1701: p_RepSchedule_rec2.resource_variance_account)
1702: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.routing_revision,
1696: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.request_id,
1697: p_RepSchedule_rec2.request_id)
1698: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.resource_account,
1699: p_RepSchedule_rec2.resource_account)
1700: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.resource_variance_account,
1701: p_RepSchedule_rec2.resource_variance_account)
1702: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.routing_revision,
1703: p_RepSchedule_rec2.routing_revision)
1704: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.routing_revision_date,
1698: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.resource_account,
1699: p_RepSchedule_rec2.resource_account)
1700: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.resource_variance_account,
1701: p_RepSchedule_rec2.resource_variance_account)
1702: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.routing_revision,
1703: p_RepSchedule_rec2.routing_revision)
1704: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.routing_revision_date,
1705: p_RepSchedule_rec2.routing_revision_date)
1706: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.status_type,
1700: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.resource_variance_account,
1701: p_RepSchedule_rec2.resource_variance_account)
1702: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.routing_revision,
1703: p_RepSchedule_rec2.routing_revision)
1704: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.routing_revision_date,
1705: p_RepSchedule_rec2.routing_revision_date)
1706: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.status_type,
1707: p_RepSchedule_rec2.status_type)
1708: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.wip_entity_id,
1702: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.routing_revision,
1703: p_RepSchedule_rec2.routing_revision)
1704: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.routing_revision_date,
1705: p_RepSchedule_rec2.routing_revision_date)
1706: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.status_type,
1707: p_RepSchedule_rec2.status_type)
1708: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.wip_entity_id,
1709: p_RepSchedule_rec2.wip_entity_id)
1710: THEN
1704: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.routing_revision_date,
1705: p_RepSchedule_rec2.routing_revision_date)
1706: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.status_type,
1707: p_RepSchedule_rec2.status_type)
1708: AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.wip_entity_id,
1709: p_RepSchedule_rec2.wip_entity_id)
1710: THEN
1711: RETURN TRUE;
1712: ELSE