APPS.PQP_NL_SAVINGS_TEMPLATE dependencies on PQP_NL_PENSION_TEMPLATE

Line 629: pqp_nl_pension_template.chk_scheme_prefix(p_scheme_prefix);

625: fnd_message.set_name('PQP','PQP_230300_SAV_PREFIX_LEN_ERR');
626: fnd_message.raise_error;
627: END IF;
628:
629: pqp_nl_pension_template.chk_scheme_prefix(p_scheme_prefix);
630:
631: hr_utility.set_location('Check unique scheme name : '||l_proc_name, 11);
632: OPEN chk_savings_scheme_name_cur;
633: FETCH chk_savings_scheme_name_cur INTO l_scheme_dummy;

Line 1250: l_shad_formula_id := pqp_nl_pension_template.Get_Formula_Id

1246: l_scheme_prefix := upper(replace(l_scheme_prefix,' ','_'));
1247:
1248: -- Update Shadow formula
1249:
1250: l_shad_formula_id := pqp_nl_pension_template.Get_Formula_Id
1251: (l_scheme_prefix||'_SAVINGS_DEDUCTION'
1252: ,p_business_group_id);
1253:
1254:

Line 1391: l_shad_formula_id1 := pqp_nl_pension_template.Get_Formula_Id(l_scheme_prefix||'_EMPLOYER_SAVINGS_CONTRIBUTION'

1387: hr_utility.set_location('leaving'||l_prem_replace_string,30);
1388:
1389: IF p_employer_component = 'Y' THEN
1390:
1391: l_shad_formula_id1 := pqp_nl_pension_template.Get_Formula_Id(l_scheme_prefix||'_EMPLOYER_SAVINGS_CONTRIBUTION'
1392: ,p_business_group_id);
1393: hr_utility.set_location('leaving'||l_shad_formula_id1,40);
1394: OPEN csr_pty2 (c_pension_type_id => p_pension_type_id
1395: ,c_effective_date => p_effective_start_date);

Line 1522: pqp_nl_pension_template.Update_Ipval_Defval( p_scheme_prefix||' Savings Deduction'

1518: hr_utility.set_location('..After Generating Core objects : Part - 2', 50);
1519:
1520: -- Update some of the input values on the main element
1521:
1522: pqp_nl_pension_template.Update_Ipval_Defval( p_scheme_prefix||' Savings Deduction'
1523: ,'Pension Type Id'
1524: ,to_char(p_pension_type_id)
1525: ,p_business_group_id);
1526:

Line 1529: pqp_nl_pension_template.Update_Ipval_Defval( p_scheme_prefix||' Employer Savings Contribution'

1525: ,p_business_group_id);
1526:
1527: -- Update some of the input values on the ER element
1528: IF p_employer_component = 'Y' THEN
1529: pqp_nl_pension_template.Update_Ipval_Defval( p_scheme_prefix||' Employer Savings Contribution'
1530: ,'Pension Type Id'
1531: ,to_char(p_pension_type_id)
1532: ,p_business_group_id);
1533: END IF;

Line 1548: pqp_nl_pension_template.Update_Ipval_Defval( p_scheme_prefix||' Savings Deduction'

1544: ELSE
1545: IF p_deduction_method = 'PE'
1546: AND r_pty_rec.pension_basis_calc_method = '13' THEN
1547: IF NVL(r_pty_rec.annual_premium_amount,0) > 0 THEN
1548: pqp_nl_pension_template.Update_Ipval_Defval( p_scheme_prefix||' Savings Deduction'
1549: ,'Percentage'
1550: ,fnd_number.number_to_canonical(r_pty_rec.ee_contribution_percent)
1551: ,p_business_group_id);
1552: pqp_nl_pension_template.Update_Ipval_Defval( p_scheme_prefix||' Savings Deduction'

Line 1552: pqp_nl_pension_template.Update_Ipval_Defval( p_scheme_prefix||' Savings Deduction'

1548: pqp_nl_pension_template.Update_Ipval_Defval( p_scheme_prefix||' Savings Deduction'
1549: ,'Percentage'
1550: ,fnd_number.number_to_canonical(r_pty_rec.ee_contribution_percent)
1551: ,p_business_group_id);
1552: pqp_nl_pension_template.Update_Ipval_Defval( p_scheme_prefix||' Savings Deduction'
1553: ,'Fixed Premium Amount'
1554: ,fnd_number.number_to_canonical(r_pty_rec.annual_premium_amount)
1555: ,p_business_group_id);
1556: END IF;

Line 1559: pqp_nl_pension_template.Update_Ipval_Defval( p_scheme_prefix||' Savings Deduction'

1555: ,p_business_group_id);
1556: END IF;
1557: ELSIF p_deduction_method = 'PE' THEN
1558: IF NVL(r_pty_rec.ee_contribution_percent,0) > 0 THEN
1559: pqp_nl_pension_template.Update_Ipval_Defval( p_scheme_prefix||' Savings Deduction'
1560: ,'Percentage'
1561: ,fnd_number.number_to_canonical(r_pty_rec.ee_contribution_percent)
1562: ,p_business_group_id);
1563: END IF;

Line 1568: pqp_nl_pension_template.Update_Ipval_Defval( p_scheme_prefix||' Employer Savings Contribution'

1564:
1565: IF (NVL(r_pty_rec.er_contribution_percent,0) > 0
1566: AND p_employer_component = 'Y'
1567: AND l_configuration_information7 = 'Y' ) THEN
1568: pqp_nl_pension_template.Update_Ipval_Defval( p_scheme_prefix||' Employer Savings Contribution'
1569: ,'Percentage'
1570: ,fnd_number.number_to_canonical(r_pty_rec.er_contribution_percent)
1571: ,p_business_group_id);
1572: END IF;

Line 1580: l_base_element_type_id := pqp_nl_pension_template.Get_Object_ID ('ELE',

1576:
1577: -- ------------------------------------------------------------------------
1578: -- Create a row in pay_element_extra_info with all the element information
1579: -- ------------------------------------------------------------------------
1580: l_base_element_type_id := pqp_nl_pension_template.Get_Object_ID ('ELE',
1581: p_scheme_prefix||' Savings Deduction',
1582: p_business_group_id,
1583: l_template_id);
1584:

Line 1587: l_er_base_element_type_id := pqp_nl_pension_template.Get_Object_ID ('ELE',

1583: l_template_id);
1584:
1585: IF p_employer_component = 'Y' THEN
1586:
1587: l_er_base_element_type_id := pqp_nl_pension_template.Get_Object_ID ('ELE',
1588: p_scheme_prefix||' Employer Savings Contribution',
1589: p_business_group_id,
1590: l_template_id);
1591:

Line 1890: pqp_nl_pension_template.Compile_Formula

1886: -- Compile the base element's standard formula
1887: -- ---------------------------------------------------------------------
1888:
1889:
1890: pqp_nl_pension_template.Compile_Formula
1891: (p_element_type_id => l_base_element_type_id
1892: ,p_effective_start_date => p_effective_start_date
1893: ,p_scheme_prefix => l_scheme_prefix
1894: ,p_business_group_id => p_business_group_id

Line 1900: pqp_nl_pension_template.Compile_Formula

1896: );
1897:
1898: IF p_employer_component = 'Y' THEN
1899:
1900: pqp_nl_pension_template.Compile_Formula
1901: (p_element_type_id => l_er_base_element_type_id
1902: ,p_effective_start_date => p_effective_start_date
1903: ,p_scheme_prefix => l_scheme_prefix
1904: ,p_business_group_id => p_business_group_id