APPS.PQP_NL_ABP_TEMPLATE dependencies on PQP_NL_PENSION_TEMPLATE

Line 870: pqp_nl_pension_template.chk_scheme_prefix(p_scheme_prefix);

866: -- |-------------< Main Function : Create_User_Template Body >----------|
867: -- ---------------------------------------------------------------------
868: hr_utility.set_location('Entering : '||l_proc_name, 10);
869:
870: pqp_nl_pension_template.chk_scheme_prefix(p_scheme_prefix);
871:
872: hr_utility.set_location('Check unique scheme name : '||l_proc_name, 11);
873:
874: OPEN chk_pension_scheme_name_cur;

Line 1286: l_shad_formula_id := pqp_nl_pension_template.Get_Formula_Id

1282: l_scheme_prefix := UPPER(REPLACE(l_scheme_prefix,' ','_'));
1283:
1284: -- Update Shadow formula
1285:
1286: l_shad_formula_id := pqp_nl_pension_template.Get_Formula_Id
1287: (l_scheme_prefix||'_ABP_PENSION_DEDUCTION'
1288: ,p_business_group_id);
1289:
1290:

Line 1361: pqp_nl_pension_template.Get_Formula_Id

1357:
1358: IF p_employer_component = 'Y' THEN
1359:
1360: l_shad_formula_id1 :=
1361: pqp_nl_pension_template.Get_Formula_Id
1362: (l_scheme_prefix||
1363: '_ABP_EMPLOYER_PENSION_CONTRIBUTION'
1364: ,p_business_group_id);
1365:

Line 1435: pqp_nl_pension_template.Update_Ipval_Defval(

1431: hr_utility.set_location('..After Generating Core objects : Part - 2', 50);
1432:
1433: -- Update some of the input values on the main element
1434:
1435: pqp_nl_pension_template.Update_Ipval_Defval(
1436: p_scheme_prefix||' ABP Pension Deduction'
1437: ,'Pension Type Id'
1438: ,TO_CHAR(p_pension_type_id)
1439: ,p_business_group_id);

Line 1443: pqp_nl_pension_template.Update_Ipval_Defval(

1439: ,p_business_group_id);
1440:
1441: -- Update some of the input values on the ER element
1442: IF p_employer_component = 'Y' THEN
1443: pqp_nl_pension_template.Update_Ipval_Defval(
1444: p_scheme_prefix||' ABP Employer Pension Contribution'
1445: ,'Pension Type Id'
1446: ,TO_CHAR(p_pension_type_id)
1447: ,p_business_group_id);

Line 1454: l_base_element_type_id := pqp_nl_pension_template.get_object_id

1450:
1451: -- ------------------------------------------------------------------------
1452: -- Create a row in pay_element_extra_info with all the element information
1453: -- ------------------------------------------------------------------------
1454: l_base_element_type_id := pqp_nl_pension_template.get_object_id
1455: ('ELE',
1456: p_scheme_prefix||' ABP Pension Deduction',
1457: p_business_group_id,
1458: l_template_id);

Line 1462: l_er_base_element_type_id := pqp_nl_pension_template.get_object_id

1458: l_template_id);
1459:
1460: IF p_employer_component = 'Y' THEN
1461:
1462: l_er_base_element_type_id := pqp_nl_pension_template.get_object_id
1463: ('ELE',
1464: p_scheme_prefix||' ABP Employer Pension Contribution',
1465: p_business_group_id,
1466: l_template_id);

Line 1470: l_cy_retro_element_type_id := pqp_nl_pension_template.get_object_id

1466: l_template_id);
1467:
1468: END IF;
1469:
1470: l_cy_retro_element_type_id := pqp_nl_pension_template.get_object_id
1471: ('ELE',
1472: p_scheme_prefix
1473: ||' Retro ABP Pension Deduction Current Year',
1474: p_business_group_id,

Line 1477: l_py_retro_element_type_id := pqp_nl_pension_template.get_object_id

1473: ||' Retro ABP Pension Deduction Current Year',
1474: p_business_group_id,
1475: l_template_id);
1476:
1477: l_py_retro_element_type_id := pqp_nl_pension_template.get_object_id
1478: ('ELE',
1479: p_scheme_prefix
1480: ||' Retro ABP Pension Deduction Previous Year',
1481: p_business_group_id,

Line 1486: l_cy_er_retro_element_type_id := pqp_nl_pension_template.get_object_id

1482: l_template_id);
1483:
1484: IF p_employer_component = 'Y' THEN
1485:
1486: l_cy_er_retro_element_type_id := pqp_nl_pension_template.get_object_id
1487: ('ELE',
1488: p_scheme_prefix
1489: ||' Retro ABP Employer Pension Contribution Current Year',
1490: p_business_group_id,

Line 1493: l_py_er_retro_element_type_id := pqp_nl_pension_template.get_object_id

1489: ||' Retro ABP Employer Pension Contribution Current Year',
1490: p_business_group_id,
1491: l_template_id);
1492:
1493: l_py_er_retro_element_type_id := pqp_nl_pension_template.get_object_id
1494: ('ELE',
1495: p_scheme_prefix
1496: ||' Retro ABP Employer Pension Contribution Previous Year',
1497: p_business_group_id,

Line 1817: pqp_nl_pension_template.Compile_Formula

1813: -- ---------------------------------------------------------------------
1814: -- Compile the base element's standard formula
1815: -- ---------------------------------------------------------------------
1816:
1817: pqp_nl_pension_template.Compile_Formula
1818: (p_element_type_id => l_base_element_type_id
1819: ,p_effective_start_date => p_effective_start_date
1820: ,p_scheme_prefix => l_scheme_prefix
1821: ,p_business_group_id => p_business_group_id

Line 1827: pqp_nl_pension_template.Compile_Formula

1823: );
1824:
1825: IF p_employer_component = 'Y' THEN
1826:
1827: pqp_nl_pension_template.Compile_Formula
1828: (p_element_type_id => l_er_base_element_type_id
1829: ,p_effective_start_date => p_effective_start_date
1830: ,p_scheme_prefix => l_scheme_prefix
1831: ,p_business_group_id => p_business_group_id