eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TAV_API_BUSINESS_RULES dependencies on OTA_ACTIVITY_VERSIONS

Line 118: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.CURRENCY_CODE'

114: --
115: exception
116: when app_exception.application_exception then
117: if hr_multi_message.exception_add
118: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.CURRENCY_CODE'
119: ) then
120: hr_utility.set_location(' Leaving:'|| v_proc,70);
121: raise;
122: end if;

Line 144: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.VENDOR_ID'

140: --
141: exception
142: when app_exception.application_exception then
143: if hr_multi_message.exception_add
144: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.VENDOR_ID'
145: ) then
146: hr_utility.set_location(' Leaving:'|| v_proc,70);
147: raise;
148: end if;

Line 179: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.CURRENCY_CODE'

175: --
176: exception
177: when app_exception.application_exception then
178: if hr_multi_message.exception_add
179: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.CURRENCY_CODE'
180: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.BUDGET_COST'
181: ,p_associated_column3 => 'OTA_ACTIVITY_VERSIONS.ACTUAL_COST'
182: ) then
183: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 180: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.BUDGET_COST'

176: exception
177: when app_exception.application_exception then
178: if hr_multi_message.exception_add
179: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.CURRENCY_CODE'
180: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.BUDGET_COST'
181: ,p_associated_column3 => 'OTA_ACTIVITY_VERSIONS.ACTUAL_COST'
182: ) then
183: hr_utility.set_location(' Leaving:'|| v_proc,70);
184: raise;

Line 181: ,p_associated_column3 => 'OTA_ACTIVITY_VERSIONS.ACTUAL_COST'

177: when app_exception.application_exception then
178: if hr_multi_message.exception_add
179: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.CURRENCY_CODE'
180: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.BUDGET_COST'
181: ,p_associated_column3 => 'OTA_ACTIVITY_VERSIONS.ACTUAL_COST'
182: ) then
183: hr_utility.set_location(' Leaving:'|| v_proc,70);
184: raise;
185: end if;

Line 217: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.PROFESSIONAL_CREDITS'

213: --
214: exception
215: when app_exception.application_exception then
216: if hr_multi_message.exception_add
217: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.PROFESSIONAL_CREDITS'
218: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.PROFESSIONAL_CREDIT_TYPE'
219: ) then
220: hr_utility.set_location(' Leaving:'|| v_proc,70);
221: raise;

Line 218: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.PROFESSIONAL_CREDIT_TYPE'

214: exception
215: when app_exception.application_exception then
216: if hr_multi_message.exception_add
217: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.PROFESSIONAL_CREDITS'
218: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.PROFESSIONAL_CREDIT_TYPE'
219: ) then
220: hr_utility.set_location(' Leaving:'|| v_proc,70);
221: raise;
222: end if;

Line 246: (p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.PROFESSIONAL_CREDIT_TYPE'

242: --
243: exception
244: when app_exception.application_exception then
245: if hr_multi_message.exception_add
246: (p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.PROFESSIONAL_CREDIT_TYPE'
247: ) then
248: hr_utility.set_location(' Leaving:'|| v_proc,70);
249: raise;
250: end if;

Line 320: from ota_activity_versions_vl tav

316: where activity_id = p_activity_id;
317: --
318: cursor sel_unique_key is
319: select 'Y'
320: from ota_activity_versions_vl tav
321: , ota_activity_definitions tad
322: where tav.version_name = p_version_name
323: and tav.activity_id = tad.activity_id
324: and (p_activity_version_id is null or

Line 384: from ota_activity_versions tav

380: v_proc varchar2(72) := g_package||'check_superseding_version';
381: --
382: cursor sel_version is
383: select end_date
384: from ota_activity_versions tav
385: where tav.activity_version_id = p_sup_act_vers_id;
386: --
387: Begin
388: --

Line 447: from ota_activity_versions tav1

443: v_proc varchar2(72) := g_package||'find_overlapping_versions';
444: --
445: cursor find_overlapping_vers is
446: select 1
447: from ota_activity_versions tav1
448: where tav1.activity_id = p_activity_id
449: and exists
450: ( select 1
451: from ota_activity_versions tav2

Line 451: from ota_activity_versions tav2

447: from ota_activity_versions tav1
448: where tav1.activity_id = p_activity_id
449: and exists
450: ( select 1
451: from ota_activity_versions tav2
452: where tav2.activity_id = p_activity_id
453: and tav1.activity_version_id <> tav2.activity_version_id
454: and tav2.start_date between
455: tav1.start_date and nvl(tav1.end_date, hr_general.end_of_time)

Line 555: v_activity_version_id ota_activity_versions.activity_version_id%TYPE ;

551: ,p_version_name in varchar2
552: )
553: Return number is
554: --
555: v_activity_version_id ota_activity_versions.activity_version_id%TYPE ;
556: v_proc varchar2(72) := g_package||'get_activity_version_id';
557: --
558: cursor sel_version_id is
559: select activity_version_id

Line 560: from ota_activity_versions_vl tav

556: v_proc varchar2(72) := g_package||'get_activity_version_id';
557: --
558: cursor sel_version_id is
559: select activity_version_id
560: from ota_activity_versions_vl tav
561: where tav.activity_id = p_activity_id
562: and tav.version_name = p_version_name;
563:
564: --

Line 617: v_version_name ota_activity_versions.version_name%TYPE;

613: (
614: p_activity_version_id in number
615: ) Return varchar2 is
616: --
617: v_version_name ota_activity_versions.version_name%TYPE;
618: v_proc varchar2(72) := g_package||'get_activity_version_name';
619: --
620: cursor sel_vers_name is
621: select version_name

Line 622: from ota_activity_versions_tl tav

618: v_proc varchar2(72) := g_package||'get_activity_version_name';
619: --
620: cursor sel_vers_name is
621: select version_name
622: from ota_activity_versions_tl tav
623: where tav.activity_version_id = p_activity_version_id
624: and tav.language = USERENV('LANG');
625: --
626: Begin

Line 758: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'

754: end if;
755: exception
756: when app_exception.application_exception then
757: if hr_multi_message.exception_add
758: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
759: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
760: ) then
761: hr_utility.set_location(' Leaving:'|| v_proc,70);
762: raise;

Line 759: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'

755: exception
756: when app_exception.application_exception then
757: if hr_multi_message.exception_add
758: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
759: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
760: ) then
761: hr_utility.set_location(' Leaving:'|| v_proc,70);
762: raise;
763: end if;

Line 1020: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'

1016: Begin
1017: hr_utility.set_location(' Entering:' || l_proc,10);
1018: --
1019: IF hr_multi_message.no_exclusive_error
1020: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1021: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1022: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1023: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1024: ) THEN

Line 1021: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'

1017: hr_utility.set_location(' Entering:' || l_proc,10);
1018: --
1019: IF hr_multi_message.no_exclusive_error
1020: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1021: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1022: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1023: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1024: ) THEN
1025: --

Line 1022: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'

1018: --
1019: IF hr_multi_message.no_exclusive_error
1020: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1021: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1022: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1023: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1024: ) THEN
1025: --
1026: OPEN cur_cat_start_end_date;

Line 1023: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'

1019: IF hr_multi_message.no_exclusive_error
1020: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1021: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1022: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1023: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1024: ) THEN
1025: --
1026: OPEN cur_cat_start_end_date;
1027: FETCH cur_cat_start_end_date into l_cat_start_date, l_cat_end_date;

Line 1048: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'

1044: hr_utility.set_location(' Leaving:' || l_proc,10);
1045: Exception
1046: when app_exception.application_exception then
1047: IF hr_multi_message.exception_add
1048: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1049: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1050: ) THEN
1051: hr_utility.set_location(' Leaving:'|| l_proc,20);
1052: raise;

Line 1049: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'

1045: Exception
1046: when app_exception.application_exception then
1047: IF hr_multi_message.exception_add
1048: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1049: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1050: ) THEN
1051: hr_utility.set_location(' Leaving:'|| l_proc,20);
1052: raise;
1053: END IF;

Line 1405: -- ota_activity_versions exists where this activity version has superseded

1401: -- PUBLIC
1402: -- Description:
1403: -- Delete Validation.
1404: -- This activity version may not be deleted if child rows in
1405: -- ota_activity_versions exists where this activity version has superseded
1406: -- another earlier activity version.
1407: --
1408: Procedure check_if_tav_exists
1409: (

Line 1418: from ota_activity_versions tav

1414: v_proc varchar2(72) := g_package||'check_if_tav_exists';
1415: --
1416: cursor sel_tav_exists is
1417: select 'Y'
1418: from ota_activity_versions tav
1419: where tav.superseded_by_act_version_id = p_activity_version_id;
1420: --
1421: Begin
1422: --

Line 1670: from ota_activity_versions tav

1666: v_default_end_date date;
1667: --
1668: cursor sel_versions is
1669: select 'Y'
1670: from ota_activity_versions tav
1671: where tav.activity_id = p_activity_id
1672: and ((tav.activity_version_id <> p_activity_version_id
1673: and p_activity_version_id is not null )
1674: or p_activity_version_id is null)

Line 1819: from ota_activity_versions tav

1815: select tav.activity_version_id
1816: , tav.start_date
1817: , tav.end_date
1818: , tav.object_version_number
1819: from ota_activity_versions tav
1820: , ota_activity_definitions tad
1821: where tad.activity_id = p_activity_id
1822: and tad.multiple_con_versions_flag = 'N'
1823: and tav.activity_id = tad.activity_id

Line 1826: from ota_activity_versions tav2

1822: and tad.multiple_con_versions_flag = 'N'
1823: and tav.activity_id = tad.activity_id
1824: and tav.start_date =
1825: (select max(tav2.start_date)
1826: from ota_activity_versions tav2
1827: where tav2.activity_version_id <> p_activity_version_id
1828: and tav2.activity_id = p_activity_id);
1829: --
1830: Begin

Line 1893: from ota_activity_versions tav

1889: v_activity_version_id number;
1890: --
1891: cursor get_versions is
1892: select tav.end_date
1893: from ota_activity_versions tav
1894: , ota_activity_definitions tad
1895: where tav.activity_id = tad.activity_id --p_activity_id
1896: and tad.activity_id = p_activity_id -- Bug 2808274
1897: and tad.multiple_con_versions_flag = 'N'

Line 1947: , ota_activity_versions tav

1943: --
1944: cursor sel_latest_version is
1945: select tav.superseded_by_act_version_id
1946: from ota_activity_definitions tad
1947: , ota_activity_versions tav
1948: where tad.activity_id = p_activity_id
1949: and tad.multiple_con_versions_flag = 'N'
1950: and tav.activity_id = tad.activity_id
1951: and nvl(tav.end_date, hr_api.g_eot) =

Line 1953: from ota_activity_versions tav2

1949: and tad.multiple_con_versions_flag = 'N'
1950: and tav.activity_id = tad.activity_id
1951: and nvl(tav.end_date, hr_api.g_eot) =
1952: (select max( nvl(tav2.end_date, hr_api.g_eot))
1953: from ota_activity_versions tav2
1954: where tav2.activity_id = p_activity_id);
1955: --
1956: cursor sel_superseded_act( pc_activity_version_id IN number) is
1957: select 'Y'

Line 1958: from ota_activity_versions tav

1954: where tav2.activity_id = p_activity_id);
1955: --
1956: cursor sel_superseded_act( pc_activity_version_id IN number) is
1957: select 'Y'
1958: from ota_activity_versions tav
1959: where tav.activity_id = p_activity_id
1960: and tav.activity_version_id = pc_activity_version_id ;
1961: --
1962: Begin

Line 2041: from ota_activity_versions

2037:
2038: cursor csr_old_inventory is
2039: select inventory_item_id,
2040: organization_id
2041: from ota_activity_versions
2042: where activity_version_id = p_activity_version_id;
2043: --
2044: Begin
2045: --

Line 2093: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.INVENTORY_ITEM_ID'

2089: --
2090: exception
2091: when app_exception.application_exception then
2092: if hr_multi_message.exception_add
2093: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.INVENTORY_ITEM_ID'
2094: ) then
2095: hr_utility.set_location(' Leaving:'|| l_proc,70);
2096: raise;
2097: end if;

Line 2137: ota_activity_versions

2133: cursor csr_old_inventory is
2134: select inventory_item_id,
2135: organization_id
2136: from
2137: ota_activity_versions
2138: where activity_version_id <> p_activity_version_id;
2139:
2140: cursor cur_offerings is
2141: select 1 from ota_offerings off,ota_category_usages cat

Line 2234: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.INVENTORY_ITEM_ID'

2230: --
2231: exception
2232: when app_exception.application_exception then
2233: if hr_multi_message.exception_add
2234: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.INVENTORY_ITEM_ID'
2235: ) then
2236: hr_utility.set_location(' Leaving:'|| l_proc,70);
2237: raise;
2238: end if;

Line 2266: from ota_activity_versions

2262: l_exists varchar2(1);
2263:
2264: cursor csr_rco is
2265: select null
2266: from ota_activity_versions
2267: where rco_id = p_rco_id;
2268:
2269: Begin
2270:

Line 2284: ota_tav_shd.constraint_error(p_constraint_name =>'OTA_ACTIVITY_VERSIONS_UK5');

2280: hr_utility.set_location('Entering:'||l_proc, 15);
2281: open csr_rco;
2282: fetch csr_rco into l_exists;
2283: if csr_rco%found then
2284: ota_tav_shd.constraint_error(p_constraint_name =>'OTA_ACTIVITY_VERSIONS_UK5');
2285: end if;
2286: close csr_rco;
2287: hr_utility.set_location('Leaving:'||l_proc, 20);
2288: end if;

Line 2293: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.RCO_ID'

2289: end if;
2290: exception
2291: when app_exception.application_exception then
2292: if hr_multi_message.exception_add
2293: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.RCO_ID'
2294: ) then
2295: hr_utility.set_location(' Leaving:'|| l_proc,70);
2296: raise;
2297: end if;

Line 2343: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'

2339: Begin
2340:
2341: hr_utility.set_location('Entering:'||l_proc, 5);
2342: IF hr_multi_message.no_exclusive_error
2343: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2344: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
2345: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2346: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN
2347:

Line 2344: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'

2340:
2341: hr_utility.set_location('Entering:'||l_proc, 5);
2342: IF hr_multi_message.no_exclusive_error
2343: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2344: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
2345: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2346: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN
2347:
2348: IF (NVL(ota_tav_shd.g_old_rec.start_date, hr_api.g_date) <>

Line 2345: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'

2341: hr_utility.set_location('Entering:'||l_proc, 5);
2342: IF hr_multi_message.no_exclusive_error
2343: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2344: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
2345: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2346: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN
2347:
2348: IF (NVL(ota_tav_shd.g_old_rec.start_date, hr_api.g_date) <>
2349: NVL( p_start_date, hr_api.g_date )) THEN

Line 2346: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN

2342: IF hr_multi_message.no_exclusive_error
2343: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2344: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
2345: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2346: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN
2347:
2348: IF (NVL(ota_tav_shd.g_old_rec.start_date, hr_api.g_date) <>
2349: NVL( p_start_date, hr_api.g_date )) THEN
2350: l_upd_start_date := TRUE;

Line 2532: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'

2528: Begin
2529:
2530: hr_utility.set_location('Entering:'||l_proc, 5);
2531: IF hr_multi_message.no_exclusive_error
2532: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2533: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
2534: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2535: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN
2536:

Line 2533: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'

2529:
2530: hr_utility.set_location('Entering:'||l_proc, 5);
2531: IF hr_multi_message.no_exclusive_error
2532: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2533: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
2534: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2535: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN
2536:
2537: IF (NVL(ota_tav_shd.g_old_rec.start_date, hr_api.g_date) <>

Line 2534: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'

2530: hr_utility.set_location('Entering:'||l_proc, 5);
2531: IF hr_multi_message.no_exclusive_error
2532: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2533: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
2534: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2535: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN
2536:
2537: IF (NVL(ota_tav_shd.g_old_rec.start_date, hr_api.g_date) <>
2538: NVL( p_start_date, hr_api.g_date )) THEN

Line 2535: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN

2531: IF hr_multi_message.no_exclusive_error
2532: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2533: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
2534: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2535: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN
2536:
2537: IF (NVL(ota_tav_shd.g_old_rec.start_date, hr_api.g_date) <>
2538: NVL( p_start_date, hr_api.g_date )) THEN
2539: l_upd_start_date := TRUE;