DBA Data[Home] [Help]

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;