DBA Data[Home] [Help]

APPS.PER_PCE_BUS dependencies on PER_PCE_BUS

Line 1: Package Body per_pce_bus as

1: Package Body per_pce_bus as
2: /* $Header: pepcerhi.pkb 120.1 2006/10/18 09:19:34 grreddy noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package VARCHAR2(33) := ' per_pce_bus.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package VARCHAR2(33) := ' per_pce_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 118: IF ( nvl(per_pce_bus.g_cagr_entitlement_id, hr_api.g_number)

114: ,p_argument => 'cagr_entitlement_id'
115: ,p_argument_value => p_cagr_entitlement_id
116: );
117: --
118: IF ( nvl(per_pce_bus.g_cagr_entitlement_id, hr_api.g_number)
119: = p_cagr_entitlement_id) THEN
120: --
121: -- The legislation code has already been found with a previous
122: -- call to this function. Just return the value IN the global

Line 125: l_legislation_code := per_pce_bus.g_legislation_code;

121: -- The legislation code has already been found with a previous
122: -- call to this function. Just return the value IN the global
123: -- variable.
124: --
125: l_legislation_code := per_pce_bus.g_legislation_code;
126: hr_utility.set_location(l_proc, 20);
127: else
128: --
129: -- The ID IS different to the last call to this function

Line 149: per_pce_bus.g_cagr_entitlement_id := p_cagr_entitlement_id;

145: -- Set the global variables so the values are
146: -- available for the next call to this function.
147: --
148: close csr_leg_code;
149: per_pce_bus.g_cagr_entitlement_id := p_cagr_entitlement_id;
150: per_pce_bus.g_legislation_code := l_legislation_code;
151: END IF;
152: hr_utility.set_location(' Leaving:'|| l_proc, 40);
153: RETURN l_legislation_code;

Line 150: per_pce_bus.g_legislation_code := l_legislation_code;

146: -- available for the next call to this function.
147: --
148: close csr_leg_code;
149: per_pce_bus.g_cagr_entitlement_id := p_cagr_entitlement_id;
150: per_pce_bus.g_legislation_code := l_legislation_code;
151: END IF;
152: hr_utility.set_location(' Leaving:'|| l_proc, 40);
153: RETURN l_legislation_code;
154: END return_legislation_code;

Line 1230: /*per_pce_bus.set_security_group_id

1226: --
1227: --
1228: -- Call all supporting business operations
1229: --
1230: /*per_pce_bus.set_security_group_id
1231: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1232: ,p_collective_agreement_id => p_rec.collective_agreement_id
1233: ); */
1234: --

Line 1237: per_pce_bus.chk_start_date

1233: ); */
1234: --
1235: hr_utility.set_location(l_proc,20);
1236: --
1237: per_pce_bus.chk_start_date
1238: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1239: ,p_start_date => p_rec.start_date
1240: ,p_end_date => p_rec.end_date
1241: ,p_collective_Agreement_id => p_rec.collective_agreement_id

Line 1246: per_pce_bus.chk_end_date

1242: );
1243: --
1244: hr_utility.set_location(l_proc,25);
1245: --
1246: per_pce_bus.chk_end_date
1247: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1248: ,p_start_date => p_rec.start_date
1249: ,p_end_date => p_rec.end_date
1250: ,p_effective_date => p_effective_date

Line 1255: per_pce_bus.chk_formula_id

1251: );
1252: --
1253: hr_utility.set_location(l_proc,30);
1254: --
1255: per_pce_bus.chk_formula_id
1256: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1257: ,p_effective_date => p_effective_date
1258: ,p_formula_id => p_rec.formula_id
1259: ,p_business_group_id => l_business_group_id

Line 1265: per_pce_bus.chk_formula_criteria

1261: );
1262: --
1263: hr_utility.set_location(l_proc,40);
1264: --
1265: per_pce_bus.chk_formula_criteria
1266: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1267: ,p_effective_date => p_effective_date
1268: ,p_formula_id => p_rec.formula_id
1269: ,p_formula_criteria => p_rec.formula_criteria

Line 1274: per_pce_bus.chk_formula_criteria_mismatch

1270: );
1271: --
1272: hr_utility.set_location(l_proc,50);
1273: --
1274: per_pce_bus.chk_formula_criteria_mismatch
1275: (p_formula_id => p_rec.formula_id
1276: ,p_formula_criteria => p_rec.formula_criteria
1277: );
1278: --

Line 1281: per_pce_bus.chk_status

1277: );
1278: --
1279: hr_utility.set_location(l_proc,60);
1280: --
1281: per_pce_bus.chk_status
1282: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1283: ,p_effective_date => p_effective_date
1284: ,p_status => p_rec.status
1285: );

Line 1289: per_pce_bus.chk_message_level

1285: );
1286: --
1287: hr_utility.set_location(l_proc,70);
1288: --
1289: per_pce_bus.chk_message_level
1290: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1291: ,p_effective_date => p_effective_date
1292: ,p_message_level => p_rec.message_level
1293: );

Line 1297: per_pce_bus.chk_cagr_entitlement_item_id

1293: );
1294: --
1295: hr_utility.set_location(l_proc,80);
1296: --
1297: per_pce_bus.chk_cagr_entitlement_item_id
1298: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1299: ,p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id);
1300: --
1301: hr_utility.set_location(l_proc,90);

Line 1303: per_pce_bus. chk_entitlement_uniqueness

1299: ,p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id);
1300: --
1301: hr_utility.set_location(l_proc,90);
1302: --
1303: per_pce_bus. chk_entitlement_uniqueness
1304: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1305: ,p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
1306: ,p_collective_agreement_id => p_rec.collective_agreement_id
1307: );

Line 1311: per_pce_bus.chk_collective_agreement_id

1307: );
1308: --
1309: hr_utility.set_location(l_proc,100);
1310: --
1311: per_pce_bus.chk_collective_agreement_id
1312: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1313: ,p_business_group_id => l_business_group_id
1314: ,p_collective_agreement_id => p_rec.collective_agreement_id);
1315: --

Line 1338: per_pce_bus.set_security_group_id

1334: hr_utility.set_location('Entering:'||l_proc, 10);
1335: --
1336: -- Call all supporting business operations
1337: --
1338: per_pce_bus.set_security_group_id
1339: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1340: ,p_collective_agreement_id => p_rec.collective_agreement_id
1341: );
1342: --

Line 1359: per_pce_bus.chk_formula_id

1355: );
1356: --
1357: hr_utility.set_location(l_proc,30);
1358: --
1359: per_pce_bus.chk_formula_id
1360: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1361: ,p_effective_date => p_effective_date
1362: ,p_business_group_id => l_business_group_id
1363: ,p_formula_id => p_rec.formula_id

Line 1369: per_pce_bus.chk_formula_criteria

1365: );
1366: --
1367: hr_utility.set_location(l_proc,50);
1368: --
1369: per_pce_bus.chk_formula_criteria
1370: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1371: ,p_effective_date => p_effective_date
1372: ,p_formula_id => p_rec.formula_id
1373: ,p_formula_criteria => p_rec.formula_criteria

Line 1378: per_pce_bus.chk_formula_criteria_mismatch

1374: );
1375: --
1376: hr_utility.set_location(l_proc,60);
1377: --
1378: per_pce_bus.chk_formula_criteria_mismatch
1379: (p_formula_id => p_rec.formula_id
1380: ,p_formula_criteria => p_rec.formula_criteria
1381: );
1382: --

Line 1385: per_pce_bus.chk_status

1381: );
1382: --
1383: hr_utility.set_location(l_proc,70);
1384: --
1385: per_pce_bus.chk_status
1386: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1387: ,p_effective_date => p_effective_date
1388: ,p_status => p_rec.status
1389: );

Line 1393: per_pce_bus.chk_message_level

1389: );
1390: --
1391: hr_utility.set_location(l_proc,80);
1392: --
1393: per_pce_bus.chk_message_level
1394: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
1395: ,p_effective_date => p_effective_date
1396: ,p_message_level => p_rec.message_level
1397: );

Line 1421: END per_pce_bus;

1417: hr_utility.set_location(' Leaving:'||l_proc, 10);
1418: --
1419: END delete_validate;
1420: --
1421: END per_pce_bus;