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.PQP_NL_PGGM_TEMPLATE dependencies on PQP_NL_PENSION_TEMPLATE

Line 702: pqp_nl_pension_template.chk_scheme_prefix(p_scheme_prefix);

698:
699: --
700: -- Check the format of the prefix name entered.
701: --
702: pqp_nl_pension_template.chk_scheme_prefix(p_scheme_prefix);
703:
704: IF g_debug THEN
705: hr_utility.set_location('Check unique scheme name : '||l_proc_name, 11);
706: END IF;

Line 1179: l_shad_formula_id := pqp_nl_pension_template.Get_Formula_Id

1175:
1176: --
1177: -- Update Shadow formula
1178: --
1179: l_shad_formula_id := pqp_nl_pension_template.Get_Formula_Id
1180: (l_scheme_prefix||'_PGGM_PENSION_DEDUCTION'
1181: ,p_business_group_id);
1182:
1183: IF g_debug THEN

Line 1236: pqp_nl_pension_template.Get_Formula_Id

1232: WHERE formula_id = l_shad_formula_id
1233: AND business_group_id = p_business_group_id;
1234:
1235: l_shad_formula_id1 :=
1236: pqp_nl_pension_template.Get_Formula_Id
1237: (l_scheme_prefix||
1238: '_PGGM_EMPLOYER_PENSION_CONTRIBUTION'
1239: ,p_business_group_id);
1240:

Line 1273: pqp_nl_pension_template.Update_Ipval_Defval(

1269:
1270: --
1271: -- Update some the input values for default values
1272: --
1273: pqp_nl_pension_template.Update_Ipval_Defval(
1274: p_scheme_prefix||' PGGM Pension Deduction'
1275: ,'Pension Type Id'
1276: ,TO_CHAR(p_pension_type_id)
1277: ,p_business_group_id);

Line 1279: pqp_nl_pension_template.Update_Ipval_Defval(

1275: ,'Pension Type Id'
1276: ,TO_CHAR(p_pension_type_id)
1277: ,p_business_group_id);
1278:
1279: pqp_nl_pension_template.Update_Ipval_Defval(
1280: p_scheme_prefix||' PGGM Pension Deduction'
1281: ,'Basis Rounding'
1282: ,p_basis_rounding
1283: ,p_business_group_id);

Line 1285: pqp_nl_pension_template.Update_Ipval_Defval(

1281: ,'Basis Rounding'
1282: ,p_basis_rounding
1283: ,p_business_group_id);
1284:
1285: pqp_nl_pension_template.Update_Ipval_Defval(
1286: p_scheme_prefix||' PGGM Pension Deduction'
1287: ,'Contribution Rounding'
1288: ,p_contrib_rounding
1289: ,p_business_group_id);

Line 1291: pqp_nl_pension_template.Update_Ipval_Defval(

1287: ,'Contribution Rounding'
1288: ,p_contrib_rounding
1289: ,p_business_group_id);
1290:
1291: pqp_nl_pension_template.Update_Ipval_Defval(
1292: p_scheme_prefix||' PGGM Employer Pension Contribution'
1293: ,'Pension Type Id'
1294: ,TO_CHAR(p_pension_type_id)
1295: ,p_business_group_id);

Line 1297: pqp_nl_pension_template.Update_Ipval_Defval(

1293: ,'Pension Type Id'
1294: ,TO_CHAR(p_pension_type_id)
1295: ,p_business_group_id);
1296:
1297: pqp_nl_pension_template.Update_Ipval_Defval(
1298: p_scheme_prefix||' PGGM Employer Pension Contribution'
1299: ,'Basis Rounding'
1300: ,p_basis_rounding
1301: ,p_business_group_id);

Line 1303: pqp_nl_pension_template.Update_Ipval_Defval(

1299: ,'Basis Rounding'
1300: ,p_basis_rounding
1301: ,p_business_group_id);
1302:
1303: pqp_nl_pension_template.Update_Ipval_Defval(
1304: p_scheme_prefix||' PGGM Employer Pension Contribution'
1305: ,'Contribution Rounding'
1306: ,p_contrib_rounding
1307: ,p_business_group_id);

Line 1317: l_base_element_type_id := pqp_nl_pension_template.get_object_id

1313:
1314: -- ------------------------------------------------------------------------
1315: -- Derive Element Type Ids for all elements created.
1316: -- ------------------------------------------------------------------------
1317: l_base_element_type_id := pqp_nl_pension_template.get_object_id
1318: ('ELE',
1319: p_scheme_prefix||' PGGM Pension Deduction',
1320: p_business_group_id,
1321: l_template_id);

Line 1323: l_er_base_element_type_id := pqp_nl_pension_template.get_object_id

1319: p_scheme_prefix||' PGGM Pension Deduction',
1320: p_business_group_id,
1321: l_template_id);
1322:
1323: l_er_base_element_type_id := pqp_nl_pension_template.get_object_id
1324: ('ELE',
1325: p_scheme_prefix||' PGGM Employer Pension Contribution',
1326: p_business_group_id,
1327: l_template_id);

Line 1329: l_xtr_element_type_id := pqp_nl_pension_template.get_object_id

1325: p_scheme_prefix||' PGGM Employer Pension Contribution',
1326: p_business_group_id,
1327: l_template_id);
1328:
1329: l_xtr_element_type_id := pqp_nl_pension_template.get_object_id
1330: ('ELE',
1331: p_scheme_prefix||' PGGM Extra Pensions',
1332: p_business_group_id,
1333: l_template_id);

Line 1335: l_cy_retro_element_type_id := pqp_nl_pension_template.get_object_id

1331: p_scheme_prefix||' PGGM Extra Pensions',
1332: p_business_group_id,
1333: l_template_id);
1334:
1335: l_cy_retro_element_type_id := pqp_nl_pension_template.get_object_id
1336: ('ELE',
1337: p_scheme_prefix
1338: ||' Retro PGGM Pension Deduction Current Year',
1339: p_business_group_id,

Line 1342: l_py_retro_element_type_id := pqp_nl_pension_template.get_object_id

1338: ||' Retro PGGM Pension Deduction Current Year',
1339: p_business_group_id,
1340: l_template_id);
1341:
1342: l_py_retro_element_type_id := pqp_nl_pension_template.get_object_id
1343: ('ELE',
1344: p_scheme_prefix
1345: ||' Retro PGGM Pension Deduction Previous Year',
1346: p_business_group_id,

Line 1349: l_cy_er_retro_element_type_id := pqp_nl_pension_template.get_object_id

1345: ||' Retro PGGM Pension Deduction Previous Year',
1346: p_business_group_id,
1347: l_template_id);
1348:
1349: l_cy_er_retro_element_type_id := pqp_nl_pension_template.get_object_id
1350: ('ELE',
1351: p_scheme_prefix
1352: ||' Retro PGGM Employer Pension Contribution Current Year',
1353: p_business_group_id,

Line 1356: l_py_er_retro_element_type_id := pqp_nl_pension_template.get_object_id

1352: ||' Retro PGGM Employer Pension Contribution Current Year',
1353: p_business_group_id,
1354: l_template_id);
1355:
1356: l_py_er_retro_element_type_id := pqp_nl_pension_template.get_object_id
1357: ('ELE',
1358: p_scheme_prefix
1359: ||' Retro PGGM Employer Pension Contribution Previous Year',
1360: p_business_group_id,

Line 1377: l_retr_1 := pqp_nl_pension_template.get_object_id

1373: IF g_debug THEN
1374: hr_utility.set_location('Deriving Retro Element Type Ids..', 50);
1375: END IF;
1376:
1377: l_retr_1 := pqp_nl_pension_template.get_object_id
1378: ('ELE',
1379: p_scheme_prefix||
1380: ' Retro PGGM Employer Pension Contribution Current Year'
1381: , p_business_group_id

Line 1389: l_retr_2 := pqp_nl_pension_template.get_object_id

1385: l_retro_count := l_retro_count + 1;
1386: l_retro_element_lst(l_retro_count) := l_retr_1;
1387: END IF;
1388:
1389: l_retr_2 := pqp_nl_pension_template.get_object_id
1390: ('ELE',
1391: p_scheme_prefix||
1392: ' Retro PGGM Employer Pension Contribution Previous Year'
1393: ,p_business_group_id

Line 1401: l_retr_3 := pqp_nl_pension_template.get_object_id

1397: l_retro_count := l_retro_count + 1;
1398: l_retro_element_lst(l_retro_count) := l_retr_2;
1399: END IF;
1400:
1401: l_retr_3 := pqp_nl_pension_template.get_object_id
1402: ('ELE',
1403: p_scheme_prefix||
1404: ' Retro PGGM Pension Deduction Current Year'
1405: ,p_business_group_id

Line 1414: l_retr_4 := pqp_nl_pension_template.get_object_id

1410: l_retro_element_lst(l_retro_count) := l_retr_3;
1411: END IF;
1412:
1413:
1414: l_retr_4 := pqp_nl_pension_template.get_object_id
1415: ('ELE',
1416: p_scheme_prefix||
1417: ' Retro PGGM Pension Deduction Previous Year'
1418: ,p_business_group_id

Line 1426: l_retr_5 := pqp_nl_pension_template.get_object_id

1422: l_retro_count := l_retro_count + 1;
1423: l_retro_element_lst(l_retro_count) := l_retr_4;
1424: END IF;
1425:
1426: l_retr_5 := pqp_nl_pension_template.get_object_id
1427: ('ELE',
1428: p_scheme_prefix||
1429: ' Retro PGGM Pension Adj CY'
1430: ,p_business_group_id

Line 1438: l_retr_6 := pqp_nl_pension_template.get_object_id

1434: l_retro_count := l_retro_count + 1;
1435: l_retro_element_lst(l_retro_count) := l_retr_5;
1436: END IF;
1437:
1438: l_retr_6 := pqp_nl_pension_template.get_object_id
1439: ('ELE',
1440: p_scheme_prefix||
1441: ' Retro PGGM Pension Adj PY'
1442: ,p_business_group_id

Line 1450: l_retr_7 := pqp_nl_pension_template.get_object_id

1446: l_retro_count := l_retro_count + 1;
1447: l_retro_element_lst(l_retro_count) := l_retr_6;
1448: END IF;
1449:
1450: l_retr_7 := pqp_nl_pension_template.get_object_id
1451: ('ELE',
1452: p_scheme_prefix||
1453: ' Retro PGGM Disability Adj'
1454: ,p_business_group_id

Line 1462: l_retr_21 := pqp_nl_pension_template.get_object_id ('ELE',

1458: l_retro_count := l_retro_count + 1;
1459: l_retro_element_lst(l_retro_count) := l_retr_7;
1460: END IF;
1461:
1462: l_retr_21 := pqp_nl_pension_template.get_object_id ('ELE',
1463: p_scheme_prefix||
1464: ' Retro PGGM Extra Pensions'
1465: ,p_business_group_id
1466: ,l_template_id);

Line 1473: l_retr_22 := pqp_nl_pension_template.get_object_id ('ELE',

1469: l_retro_count := l_retro_count + 1;
1470: l_retro_element_lst(l_retro_count) := l_retr_21;
1471: END IF;
1472:
1473: l_retr_22 := pqp_nl_pension_template.get_object_id ('ELE',
1474: p_scheme_prefix||
1475: ' Retro PGGM Disability Pension Contribution'
1476: ,p_business_group_id
1477: ,l_template_id);

Line 1821: pqp_nl_pension_template.Compile_Formula

1817: -- Compile the base element's standard formula
1818: -- ---------------------------------------------------------------------
1819: hr_utility.set_location('Compile EE Formula', 50);
1820:
1821: pqp_nl_pension_template.Compile_Formula
1822: (p_element_type_id => l_base_element_type_id
1823: ,p_effective_start_date => p_effective_start_date
1824: ,p_scheme_prefix => l_scheme_prefix
1825: ,p_business_group_id => p_business_group_id

Line 1834: pqp_nl_pension_template.Compile_Formula

1830: hr_utility.set_location('Done Compile EE Formula', 50);
1831: hr_utility.set_location('Compile ER Formula', 50);
1832: END IF;
1833:
1834: pqp_nl_pension_template.Compile_Formula
1835: (p_element_type_id => l_er_base_element_type_id
1836: ,p_effective_start_date => p_effective_start_date
1837: ,p_scheme_prefix => l_scheme_prefix
1838: ,p_business_group_id => p_business_group_id