1276:
1277: l_proc varchar2(72) := g_package||'check_course_lp_dates';
1278: --
1279: l_start_date_changed boolean
1280: := ota_general.value_changed( ota_tav_shd.g_old_rec.start_date
1281: , p_start_date );
1282: --
1283: l_end_date_changed boolean
1284: := ota_general.value_changed( ota_tav_shd.g_old_rec.end_date
1280: := ota_general.value_changed( ota_tav_shd.g_old_rec.start_date
1281: , p_start_date );
1282: --
1283: l_end_date_changed boolean
1284: := ota_general.value_changed( ota_tav_shd.g_old_rec.end_date
1285: , p_end_date );
1286:
1287: Begin
1288:
1328:
1329: l_proc varchar2(72) := g_package||'check_course_crt_dates';
1330: --
1331: l_start_date_changed boolean
1332: := ota_general.value_changed( ota_tav_shd.g_old_rec.start_date
1333: , p_start_date );
1334: --
1335: l_end_date_changed boolean
1336: := ota_general.value_changed( ota_tav_shd.g_old_rec.end_date
1332: := ota_general.value_changed( ota_tav_shd.g_old_rec.start_date
1333: , p_start_date );
1334: --
1335: l_end_date_changed boolean
1336: := ota_general.value_changed( ota_tav_shd.g_old_rec.end_date
1337: , p_end_date );
1338:
1339: Begin
1340:
1539: := ota_tav_shd.api_updating(p_rec.activity_version_id
1540: ,p_rec.object_version_number);
1541: --
1542: l_minimum_attendees_changed boolean
1543: := ota_general.value_changed( ota_tav_shd.g_old_rec.minimum_attendees
1544: , p_rec.minimum_attendees );
1545: --
1546: l_maximum_attendees_changed boolean
1547: := ota_general.value_changed( ota_tav_shd.g_old_rec.maximum_attendees
1543: := ota_general.value_changed( ota_tav_shd.g_old_rec.minimum_attendees
1544: , p_rec.minimum_attendees );
1545: --
1546: l_maximum_attendees_changed boolean
1547: := ota_general.value_changed( ota_tav_shd.g_old_rec.maximum_attendees
1548: , p_rec.maximum_attendees );
1549: --
1550: l_activity_version_id_changed boolean
1551: := ota_general.value_changed( ota_tav_shd.g_old_rec.activity_version_id
1547: := ota_general.value_changed( ota_tav_shd.g_old_rec.maximum_attendees
1548: , p_rec.maximum_attendees );
1549: --
1550: l_activity_version_id_changed boolean
1551: := ota_general.value_changed( ota_tav_shd.g_old_rec.activity_version_id
1552: , p_rec.activity_version_id );
1553: --
1554: l_activity_id_changed boolean
1555: := ota_general.value_changed( ota_tav_shd.g_old_rec.activity_id
1551: := ota_general.value_changed( ota_tav_shd.g_old_rec.activity_version_id
1552: , p_rec.activity_version_id );
1553: --
1554: l_activity_id_changed boolean
1555: := ota_general.value_changed( ota_tav_shd.g_old_rec.activity_id
1556: , p_rec.activity_id );
1557: --
1558: l_version_name_changed boolean
1559: := ota_general.value_changed( ota_tav_shd.g_old_rec.version_name
1555: := ota_general.value_changed( ota_tav_shd.g_old_rec.activity_id
1556: , p_rec.activity_id );
1557: --
1558: l_version_name_changed boolean
1559: := ota_general.value_changed( ota_tav_shd.g_old_rec.version_name
1560: , p_rec.version_name );
1561: --
1562: l_super_by_act_vers_id_changed boolean
1563: := ota_general.value_changed( ota_tav_shd.g_old_rec.superseded_by_act_version_id
1559: := ota_general.value_changed( ota_tav_shd.g_old_rec.version_name
1560: , p_rec.version_name );
1561: --
1562: l_super_by_act_vers_id_changed boolean
1563: := ota_general.value_changed( ota_tav_shd.g_old_rec.superseded_by_act_version_id
1564: , p_rec.superseded_by_act_version_id );
1565: --
1566: l_start_date_changed boolean
1567: := ota_general.value_changed( ota_tav_shd.g_old_rec.start_date
1563: := ota_general.value_changed( ota_tav_shd.g_old_rec.superseded_by_act_version_id
1564: , p_rec.superseded_by_act_version_id );
1565: --
1566: l_start_date_changed boolean
1567: := ota_general.value_changed( ota_tav_shd.g_old_rec.start_date
1568: , p_rec.start_date );
1569: --
1570: l_end_date_changed boolean
1571: := ota_general.value_changed( ota_tav_shd.g_old_rec.end_date
1567: := ota_general.value_changed( ota_tav_shd.g_old_rec.start_date
1568: , p_rec.start_date );
1569: --
1570: l_end_date_changed boolean
1571: := ota_general.value_changed( ota_tav_shd.g_old_rec.end_date
1572: , p_rec.end_date );
1573: --
1574: l_user_status_changed boolean
1575: := ota_general.value_changed( ota_tav_shd.g_old_rec.user_status
1571: := ota_general.value_changed( ota_tav_shd.g_old_rec.end_date
1572: , p_rec.end_date );
1573: --
1574: l_user_status_changed boolean
1575: := ota_general.value_changed( ota_tav_shd.g_old_rec.user_status
1576: , p_rec.user_status );
1577: --
1578: l_success_criteria_changed boolean
1579: := ota_general.value_changed( ota_tav_shd.g_old_rec.success_criteria
1575: := ota_general.value_changed( ota_tav_shd.g_old_rec.user_status
1576: , p_rec.user_status );
1577: --
1578: l_success_criteria_changed boolean
1579: := ota_general.value_changed( ota_tav_shd.g_old_rec.success_criteria
1580: , p_rec.success_criteria );
1581: --
1582: l_duration_units_changed boolean
1583: := ota_general.value_changed( ota_tav_shd.g_old_rec.duration_units
1579: := ota_general.value_changed( ota_tav_shd.g_old_rec.success_criteria
1580: , p_rec.success_criteria );
1581: --
1582: l_duration_units_changed boolean
1583: := ota_general.value_changed( ota_tav_shd.g_old_rec.duration_units
1584: , p_rec.duration_units );
1585: --
1586: l_duration_changed boolean
1587: := ota_general.value_changed( ota_tav_shd.g_old_rec.duration
1583: := ota_general.value_changed( ota_tav_shd.g_old_rec.duration_units
1584: , p_rec.duration_units );
1585: --
1586: l_duration_changed boolean
1587: := ota_general.value_changed( ota_tav_shd.g_old_rec.duration
1588: , p_rec.duration );
1589: --
1590: l_language_id_changed boolean
1591: := ota_general.value_changed( ota_tav_shd.g_old_rec.language_id
1587: := ota_general.value_changed( ota_tav_shd.g_old_rec.duration
1588: , p_rec.duration );
1589: --
1590: l_language_id_changed boolean
1591: := ota_general.value_changed( ota_tav_shd.g_old_rec.language_id
1592: , p_rec.language_id );
1593: --
1594: l_person_id_changed boolean
1595: := ota_general.value_changed( ota_tav_shd.g_old_rec.controlling_person_id
1591: := ota_general.value_changed( ota_tav_shd.g_old_rec.language_id
1592: , p_rec.language_id );
1593: --
1594: l_person_id_changed boolean
1595: := ota_general.value_changed( ota_tav_shd.g_old_rec.controlling_person_id
1596: , p_rec.controlling_person_id );
1597: --
1598: l_vendor_id_changed boolean
1599: := ota_general.value_changed( ota_tav_shd.g_old_rec.vendor_id
1595: := ota_general.value_changed( ota_tav_shd.g_old_rec.controlling_person_id
1596: , p_rec.controlling_person_id );
1597: --
1598: l_vendor_id_changed boolean
1599: := ota_general.value_changed( ota_tav_shd.g_old_rec.vendor_id
1600: , p_rec.vendor_id);
1601: --
1602: l_professional_ctype_changed boolean
1603: := ota_general.value_changed( ota_tav_shd.g_old_rec.professional_credit_type
1599: := ota_general.value_changed( ota_tav_shd.g_old_rec.vendor_id
1600: , p_rec.vendor_id);
1601: --
1602: l_professional_ctype_changed boolean
1603: := ota_general.value_changed( ota_tav_shd.g_old_rec.professional_credit_type
1604: , p_rec.professional_credit_type);
1605: --
1606: l_professional_credits_changed boolean
1607: := ota_general.value_changed( ota_tav_shd.g_old_rec.professional_credits
1603: := ota_general.value_changed( ota_tav_shd.g_old_rec.professional_credit_type
1604: , p_rec.professional_credit_type);
1605: --
1606: l_professional_credits_changed boolean
1607: := ota_general.value_changed( ota_tav_shd.g_old_rec.professional_credits
1608: , p_rec.professional_credits);
1609: --
1610: l_budget_currency_code_changed boolean
1611: := ota_general.value_changed( ota_tav_shd.g_old_rec.budget_currency_code
1607: := ota_general.value_changed( ota_tav_shd.g_old_rec.professional_credits
1608: , p_rec.professional_credits);
1609: --
1610: l_budget_currency_code_changed boolean
1611: := ota_general.value_changed( ota_tav_shd.g_old_rec.budget_currency_code
1612: , p_rec.budget_currency_code);
1613: --
1614: l_budget_cost_changed boolean
1615: := ota_general.value_changed( ota_tav_shd.g_old_rec.budget_cost
1611: := ota_general.value_changed( ota_tav_shd.g_old_rec.budget_currency_code
1612: , p_rec.budget_currency_code);
1613: --
1614: l_budget_cost_changed boolean
1615: := ota_general.value_changed( ota_tav_shd.g_old_rec.budget_cost
1616: , p_rec.budget_cost);
1617: --
1618: l_actual_cost_changed boolean
1619: := ota_general.value_changed( ota_tav_shd.g_old_rec.actual_cost
1615: := ota_general.value_changed( ota_tav_shd.g_old_rec.budget_cost
1616: , p_rec.budget_cost);
1617: --
1618: l_actual_cost_changed boolean
1619: := ota_general.value_changed( ota_tav_shd.g_old_rec.actual_cost
1620: , p_rec.actual_cost);
1621: --
1622: l_inventory_item_id_changed boolean
1623: := ota_general.value_changed (ota_tav_shd.g_old_rec.inventory_item_id
1619: := ota_general.value_changed( ota_tav_shd.g_old_rec.actual_cost
1620: , p_rec.actual_cost);
1621: --
1622: l_inventory_item_id_changed boolean
1623: := ota_general.value_changed (ota_tav_shd.g_old_rec.inventory_item_id
1624: , p_rec.inventory_item_id);
1625:
1626: l_rco_id_changed boolean
1627: := ota_general.value_changed (ota_tav_shd.g_old_rec.rco_id
1623: := ota_general.value_changed (ota_tav_shd.g_old_rec.inventory_item_id
1624: , p_rec.inventory_item_id);
1625:
1626: l_rco_id_changed boolean
1627: := ota_general.value_changed (ota_tav_shd.g_old_rec.rco_id
1628: , p_rec.rco_id);
1629:
1630: --
1631: Begin