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_CRT_BUS dependencies on OTA_CRT_BUS

Line 1: Package Body ota_crt_bus as

1: Package Body ota_crt_bus as
2: /* $Header: otcrtrhi.pkb 120.14 2006/03/17 14:54 cmora noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' ota_crt_bus.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ota_crt_bus.'; -- Global package name
9: --
10: -- The following two global variables are only to be
11: -- used by the return_legislation_code function.
12: --

Line 122: if ( nvl(ota_crt_bus.g_certification_id, hr_api.g_number)

118: ,p_argument => 'certification_id'
119: ,p_argument_value => p_certification_id
120: );
121: --
122: if ( nvl(ota_crt_bus.g_certification_id, hr_api.g_number)
123: = p_certification_id) then
124: --
125: -- The legislation code has already been found with a previous
126: -- call to this function. Just return the value in the global

Line 129: l_legislation_code := ota_crt_bus.g_legislation_code;

125: -- The legislation code has already been found with a previous
126: -- call to this function. Just return the value in the global
127: -- variable.
128: --
129: l_legislation_code := ota_crt_bus.g_legislation_code;
130: hr_utility.set_location(l_proc, 20);
131: else
132: --
133: -- The ID is different to the last call to this function

Line 153: ota_crt_bus.g_certification_id := p_certification_id;

149: -- Set the global variables so the values are
150: -- available for the next call to this function.
151: --
152: close csr_leg_code;
153: ota_crt_bus.g_certification_id := p_certification_id;
154: ota_crt_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;

Line 154: ota_crt_bus.g_legislation_code := l_legislation_code;

150: -- available for the next call to this function.
151: --
152: close csr_leg_code;
153: ota_crt_bus.g_certification_id := p_certification_id;
154: ota_crt_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;

Line 1223: ota_crt_bus.chk_date_based_cert

1219: -- Validate Dependent Attributes
1220: --
1221: --
1222:
1223: ota_crt_bus.chk_date_based_cert
1224: (p_init_compl_date => p_rec.initial_completion_date
1225: ,p_renewable_flag => p_rec.renewable_flag
1226: ,p_renewal_duration => p_rec.renewal_duration
1227: ,p_validity_start_type => p_rec.validity_start_type

Line 1230: ota_crt_bus.chk_init_compl_date

1226: ,p_renewal_duration => p_rec.renewal_duration
1227: ,p_validity_start_type => p_rec.validity_start_type
1228: );
1229:
1230: ota_crt_bus.chk_init_compl_date
1231: (p_effective_date => p_effective_date
1232: ,p_init_compl_date => p_rec.initial_completion_date
1233: ,p_certification_id => p_rec.certification_id
1234: );

Line 1236: ota_crt_bus.chk_date_range

1232: ,p_init_compl_date => p_rec.initial_completion_date
1233: ,p_certification_id => p_rec.certification_id
1234: );
1235:
1236: ota_crt_bus.chk_date_range
1237: (p_start_date => p_rec.start_date_active
1238: ,p_end_date => p_rec.end_date_active
1239: ,p_init_compl_date => p_rec.initial_completion_date
1240: );

Line 1242: ota_crt_bus.chk_init_completion

1238: ,p_end_date => p_rec.end_date_active
1239: ,p_init_compl_date => p_rec.initial_completion_date
1240: );
1241:
1242: ota_crt_bus.chk_init_completion
1243: (p_effective_date => p_effective_date
1244: ,p_init_compl_date => p_rec.initial_completion_date
1245: ,p_init_compl_duration => p_rec.initial_completion_duration
1246: ,p_start_date_active => p_rec.start_date_active

Line 1250: ota_crt_bus.chk_renew_duration

1246: ,p_start_date_active => p_rec.start_date_active
1247: ,p_end_date_active => p_rec.end_date_active
1248: );
1249:
1250: ota_crt_bus.chk_renew_duration
1251: (p_validity_duration => p_rec.validity_duration
1252: ,p_renewal_duration => p_rec.renewal_duration
1253: );
1254:

Line 1255: ota_crt_bus.chk_renewable_cert

1251: (p_validity_duration => p_rec.validity_duration
1252: ,p_renewal_duration => p_rec.renewal_duration
1253: );
1254:
1255: ota_crt_bus.chk_renewable_cert
1256: (p_renewable_flag => p_rec.renewable_flag
1257: ,p_validity_duration => p_rec.validity_duration
1258: ,p_certification_id => p_rec.certification_id
1259: );

Line 1261: ota_crt_bus.chk_notify_days

1257: ,p_validity_duration => p_rec.validity_duration
1258: ,p_certification_id => p_rec.certification_id
1259: );
1260:
1261: ota_crt_bus.chk_notify_days
1262: (p_effective_date => p_effective_date
1263: ,p_notify_days => p_rec.notify_days_before_expire
1264: ,p_initial_completion_duration => p_rec.initial_completion_duration
1265: ,p_initial_completion_date => p_rec.initial_completion_date

Line 1270: ota_crt_bus.chk_validity_duration

1266: ,p_validity_duration => p_rec.validity_duration
1267: ,p_certification_id => p_rec.certification_id
1268: );
1269:
1270: ota_crt_bus.chk_validity_duration
1271: (p_validity_duration => p_rec.validity_duration
1272: );
1273:
1274: ota_crt_bus.chk_df(p_rec);

Line 1274: ota_crt_bus.chk_df(p_rec);

1270: ota_crt_bus.chk_validity_duration
1271: (p_validity_duration => p_rec.validity_duration
1272: );
1273:
1274: ota_crt_bus.chk_df(p_rec);
1275: --
1276: hr_multi_message.end_validation_set;
1277: --
1278: --

Line 1316: ota_crt_bus.chk_upd_exis_subscr

1312: ,p_rec => p_rec
1313: );
1314: --
1315:
1316: ota_crt_bus.chk_upd_exis_subscr
1317: (p_certification_id => p_rec.certification_id
1318: , p_initial_completion_date => p_rec.initial_completion_date
1319: , p_initial_completion_duration => p_rec.initial_completion_duration
1320: , p_renewable_flag => p_rec.renewable_flag

Line 1323: ota_crt_bus.chk_date_based_cert

1319: , p_initial_completion_duration => p_rec.initial_completion_duration
1320: , p_renewable_flag => p_rec.renewable_flag
1321: , p_notify_days => p_rec.notify_days_before_expire);
1322:
1323: ota_crt_bus.chk_date_based_cert
1324: (p_init_compl_date => p_rec.initial_completion_date
1325: ,p_renewable_flag => p_rec.renewable_flag
1326: ,p_renewal_duration => p_rec.renewal_duration
1327: ,p_validity_start_type => p_rec.validity_start_type

Line 1330: ota_crt_bus.chk_date_range

1326: ,p_renewal_duration => p_rec.renewal_duration
1327: ,p_validity_start_type => p_rec.validity_start_type
1328: );
1329:
1330: ota_crt_bus.chk_date_range
1331: (p_start_date => p_rec.start_date_active
1332: ,p_end_date => p_rec.end_date_active
1333: ,p_init_compl_date => p_rec.initial_completion_date
1334: );

Line 1336: ota_crt_bus.chk_init_completion

1332: ,p_end_date => p_rec.end_date_active
1333: ,p_init_compl_date => p_rec.initial_completion_date
1334: );
1335:
1336: ota_crt_bus.chk_init_completion
1337: (p_effective_date => p_effective_date
1338: ,p_init_compl_date => p_rec.initial_completion_date
1339: ,p_init_compl_duration => p_rec.initial_completion_duration
1340: ,p_start_date_active => p_rec.start_date_active

Line 1344: ota_crt_bus.chk_renew_duration

1340: ,p_start_date_active => p_rec.start_date_active
1341: ,p_end_date_active => p_rec.end_date_active
1342: );
1343:
1344: ota_crt_bus.chk_renew_duration
1345: (p_validity_duration => p_rec.validity_duration
1346: ,p_renewal_duration => p_rec.renewal_duration
1347: );
1348:

Line 1349: ota_crt_bus.chk_renewable_cert

1345: (p_validity_duration => p_rec.validity_duration
1346: ,p_renewal_duration => p_rec.renewal_duration
1347: );
1348:
1349: ota_crt_bus.chk_renewable_cert
1350: (p_renewable_flag => p_rec.renewable_flag
1351: ,p_validity_duration => p_rec.validity_duration
1352: ,p_certification_id => p_rec.certification_id);
1353:

Line 1354: ota_crt_bus.chk_cmb_dates

1350: (p_renewable_flag => p_rec.renewable_flag
1351: ,p_validity_duration => p_rec.validity_duration
1352: ,p_certification_id => p_rec.certification_id);
1353:
1354: ota_crt_bus.chk_cmb_dates
1355: (p_start_date => p_rec.start_date_active
1356: ,p_end_date => p_rec.end_date_active
1357: ,p_cert_id => p_rec.certification_id
1358: );

Line 1360: ota_crt_bus.chk_notify_days

1356: ,p_end_date => p_rec.end_date_active
1357: ,p_cert_id => p_rec.certification_id
1358: );
1359:
1360: ota_crt_bus.chk_notify_days
1361: (p_effective_date => p_effective_date
1362: ,p_notify_days => p_rec.notify_days_before_expire
1363: ,p_initial_completion_duration => p_rec.initial_completion_duration
1364: ,p_initial_completion_date => p_rec.initial_completion_date

Line 1369: ota_crt_bus.chk_validity_duration

1365: ,p_validity_duration => p_rec.validity_duration
1366: ,p_certification_id => p_rec.certification_id
1367: );
1368:
1369: ota_crt_bus.chk_validity_duration
1370: (p_validity_duration => p_rec.validity_duration
1371: );
1372:
1373: ota_crt_bus.chk_enr_dates

Line 1373: ota_crt_bus.chk_enr_dates

1369: ota_crt_bus.chk_validity_duration
1370: (p_validity_duration => p_rec.validity_duration
1371: );
1372:
1373: ota_crt_bus.chk_enr_dates
1374: (
1375: p_certification_id => p_rec.certification_id
1376: ,p_start_date_active => p_rec.start_date_active
1377: ,p_end_date_active => p_rec.end_date_active

Line 1384: ota_crt_bus.chk_df(p_rec);

1380: chk_category_start_end_dates(p_certification_id =>p_rec.certification_id,
1381: p_start_date =>p_rec.start_date_active,
1382: p_end_date =>p_rec.end_date_active );
1383:
1384: ota_crt_bus.chk_df(p_rec);
1385: --
1386: hr_multi_message.end_validation_set;
1387: --
1388: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 1409: end ota_crt_bus;

1405: --
1406: hr_utility.set_location(' Leaving:'||l_proc, 10);
1407: End delete_validate;
1408: --
1409: end ota_crt_bus;