DBA Data[Home] [Help]

APPS.PAY_NL_LIFE_SAVINGS_TEMPLATE dependencies on STANDARD

Line 27: ,p_standard_link IN VARCHAR2

23: ,p_er_deduction_method IN VARCHAR2
24: ,p_saving_scheme_type IN VARCHAR2
25: ,p_zvw_std_tax_chk IN VARCHAR2
26: ,p_zvw_spl_tax_chk IN VARCHAR2
27: ,p_standard_link IN VARCHAR2
28: ,p_effective_start_date IN DATE DEFAULT NULL
29: ,p_effective_end_date IN DATE DEFAULT NULL
30: ,p_security_group_id IN NUMBER DEFAULT NULL
31: ,p_business_group_id IN NUMBER

Line 807: -- Category, Processing Type and Standard Link on Base Element

803: -- ---------------------------------------------------------------------
804: -- |-------------------< Update Shadow Structure >----------------------|
805: -- ---------------------------------------------------------------------
806: -- Get Element Type id and update user-specified Classification,
807: -- Category, Processing Type and Standard Link on Base Element
808: -- as well as other element created for the Scheme
809: -- ---------------------------------------------------------------------
810:
811: -- Employee Savings Deduction

Line 958: -- Standard Tax Adjustment

954: l_shadow_element(l_count).description
955: := 'Element for '||p_scheme_prefix||' Tax SI Adjustment';
956: END LOOP;
957:
958: -- Standard Tax Adjustment
959:
960: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' Standard Tax Adjustment')
961: LOOP
962: l_count := l_count + 1;

Line 960: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' Standard Tax Adjustment')

956: END LOOP;
957:
958: -- Standard Tax Adjustment
959:
960: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' Standard Tax Adjustment')
961: LOOP
962: l_count := l_count + 1;
963: l_shadow_element(l_count).element_type_id
964: := csr_rec.element_type_id;

Line 970: := 'Element for '||p_scheme_prefix||' Standard Tax Adjustment';

966: := csr_rec.object_version_NUMBER;
967: l_shadow_element(l_count).reporting_name
968: := NVL(p_reporting_name,p_scheme_prefix)||' Std. Tax Adj.';
969: l_shadow_element(l_count).description
970: := 'Element for '||p_scheme_prefix||' Standard Tax Adjustment';
971: END LOOP;
972:
973: -- Retro Standard Tax Adjustment Current Year
974:

Line 973: -- Retro Standard Tax Adjustment Current Year

969: l_shadow_element(l_count).description
970: := 'Element for '||p_scheme_prefix||' Standard Tax Adjustment';
971: END LOOP;
972:
973: -- Retro Standard Tax Adjustment Current Year
974:
975: FOR csr_rec IN csr_shd_ele (p_scheme_prefix
976: ||' Retro Standard Tax Adjustment Current Year')
977: LOOP

Line 976: ||' Retro Standard Tax Adjustment Current Year')

972:
973: -- Retro Standard Tax Adjustment Current Year
974:
975: FOR csr_rec IN csr_shd_ele (p_scheme_prefix
976: ||' Retro Standard Tax Adjustment Current Year')
977: LOOP
978: l_count := l_count + 1;
979: l_shadow_element(l_count).element_type_id
980: := csr_rec.element_type_id;

Line 988: ||' Retro Standard Tax Adjustment Current Year';

984: := NVL(p_reporting_name,p_scheme_prefix)
985: ||' Retro Std. Tax Adj CY';
986: l_shadow_element(l_count).description
987: := 'Element for '||p_scheme_prefix
988: ||' Retro Standard Tax Adjustment Current Year';
989: END LOOP;
990:
991:
992: -- Retro Standard Tax Adjustment Previous Year

Line 992: -- Retro Standard Tax Adjustment Previous Year

988: ||' Retro Standard Tax Adjustment Current Year';
989: END LOOP;
990:
991:
992: -- Retro Standard Tax Adjustment Previous Year
993:
994: FOR csr_rec IN csr_shd_ele (p_scheme_prefix
995: ||' Retro Standard Tax Adjustment Previous Year')
996: LOOP

Line 995: ||' Retro Standard Tax Adjustment Previous Year')

991:
992: -- Retro Standard Tax Adjustment Previous Year
993:
994: FOR csr_rec IN csr_shd_ele (p_scheme_prefix
995: ||' Retro Standard Tax Adjustment Previous Year')
996: LOOP
997: l_count := l_count + 1;
998: l_shadow_element(l_count).element_type_id
999: := csr_rec.element_type_id;

Line 1007: ||' Retro Standard Tax Adjustment Previous Year';

1003: := NVL(p_reporting_name,p_scheme_prefix)
1004: ||' Retro Std. Tax Adj PY';
1005: l_shadow_element(l_count).description
1006: := 'Element for '||p_scheme_prefix
1007: ||' Retro Standard Tax Adjustment Previous Year';
1008: END LOOP;
1009:
1010: -- Special Tax Adjustment
1011:

Line 1061: -- ZVW Income Standard Tax Adjustment

1057: := 'Element for '||p_scheme_prefix
1058: ||' Retro Special Tax Adjustment Previous Year';
1059: END LOOP;
1060:
1061: -- ZVW Income Standard Tax Adjustment
1062:
1063: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' ZVW Income Standard Tax Adjustment')
1064: LOOP
1065: l_count := l_count + 1;

Line 1063: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' ZVW Income Standard Tax Adjustment')

1059: END LOOP;
1060:
1061: -- ZVW Income Standard Tax Adjustment
1062:
1063: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' ZVW Income Standard Tax Adjustment')
1064: LOOP
1065: l_count := l_count + 1;
1066: l_shadow_element(l_count).element_type_id
1067: := csr_rec.element_type_id;

Line 1073: := 'Element for '||p_scheme_prefix||' ZVW Income Standard Tax Adjustment';

1069: := csr_rec.object_version_NUMBER;
1070: l_shadow_element(l_count).reporting_name
1071: := NVL(p_reporting_name,p_scheme_prefix)||' ZVW Income Std. Tax Adj.';
1072: l_shadow_element(l_count).description
1073: := 'Element for '||p_scheme_prefix||' ZVW Income Standard Tax Adjustment';
1074: END LOOP;
1075:
1076: -- Retro ZVW Income Standard Tax Adjustment Current Year
1077:

Line 1076: -- Retro ZVW Income Standard Tax Adjustment Current Year

1072: l_shadow_element(l_count).description
1073: := 'Element for '||p_scheme_prefix||' ZVW Income Standard Tax Adjustment';
1074: END LOOP;
1075:
1076: -- Retro ZVW Income Standard Tax Adjustment Current Year
1077:
1078: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' Retro ZVW Income Standard Tax Adjustment Current Year')
1079: LOOP
1080: l_count := l_count + 1;

Line 1078: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' Retro ZVW Income Standard Tax Adjustment Current Year')

1074: END LOOP;
1075:
1076: -- Retro ZVW Income Standard Tax Adjustment Current Year
1077:
1078: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' Retro ZVW Income Standard Tax Adjustment Current Year')
1079: LOOP
1080: l_count := l_count + 1;
1081: l_shadow_element(l_count).element_type_id
1082: := csr_rec.element_type_id;

Line 1088: := 'Element for '||p_scheme_prefix||' Retro ZVW Income Standard Tax Adjustment Current Year';

1084: := csr_rec.object_version_NUMBER;
1085: l_shadow_element(l_count).reporting_name
1086: := NVL(p_reporting_name,p_scheme_prefix)||' Retro ZVW Income Std. Tax Adj. CY';
1087: l_shadow_element(l_count).description
1088: := 'Element for '||p_scheme_prefix||' Retro ZVW Income Standard Tax Adjustment Current Year';
1089: END LOOP;
1090:
1091: -- Retro ZVW Income Standard Tax Adjustment Previous Year
1092:

Line 1091: -- Retro ZVW Income Standard Tax Adjustment Previous Year

1087: l_shadow_element(l_count).description
1088: := 'Element for '||p_scheme_prefix||' Retro ZVW Income Standard Tax Adjustment Current Year';
1089: END LOOP;
1090:
1091: -- Retro ZVW Income Standard Tax Adjustment Previous Year
1092:
1093: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' Retro ZVW Income Standard Tax Adjustment Previous Year')
1094: LOOP
1095: l_count := l_count + 1;

Line 1093: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' Retro ZVW Income Standard Tax Adjustment Previous Year')

1089: END LOOP;
1090:
1091: -- Retro ZVW Income Standard Tax Adjustment Previous Year
1092:
1093: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' Retro ZVW Income Standard Tax Adjustment Previous Year')
1094: LOOP
1095: l_count := l_count + 1;
1096: l_shadow_element(l_count).element_type_id
1097: := csr_rec.element_type_id;

Line 1103: := 'Element for '||p_scheme_prefix||' ZVW Income Standard Tax Adjustment Previous Year';

1099: := csr_rec.object_version_NUMBER;
1100: l_shadow_element(l_count).reporting_name
1101: := NVL(p_reporting_name,p_scheme_prefix)||' Retro ZVW Income Std. Tax Adj. PY';
1102: l_shadow_element(l_count).description
1103: := 'Element for '||p_scheme_prefix||' ZVW Income Standard Tax Adjustment Previous Year';
1104: END LOOP;
1105:
1106: -- ZVW Income Special Tax Adjustment
1107:

Line 1619: -- => p_scheme_prefix||' Standard Tax Adjustment'

1615: -- ,p_end_time_def_name => 'End of Previous Year'
1616: -- ,p_business_group_id => p_business_group_id);
1617:
1618: -- Create_Retro_Usages (p_creator_name
1619: -- => p_scheme_prefix||' Standard Tax Adjustment'
1620: -- ,p_creator_type => 'ET'
1621: -- ,p_retro_component_priority => 10
1622: -- ,p_default_component => 'Y'
1623: -- ,p_reprocess_type => 'R'

Line 1625: -- => p_scheme_prefix||' Retro Standard Tax Adjustment Current Year'

1621: -- ,p_retro_component_priority => 10
1622: -- ,p_default_component => 'Y'
1623: -- ,p_reprocess_type => 'R'
1624: -- ,p_retro_element_name
1625: -- => p_scheme_prefix||' Retro Standard Tax Adjustment Current Year'
1626: -- ,p_start_time_def_name => 'Start of Current Year'
1627: -- ,p_end_time_def_name => 'End of Time'
1628: -- ,p_business_group_id => p_business_group_id);
1629:

Line 1632: -- => p_scheme_prefix||' Standard Tax Adjustment'

1628: -- ,p_business_group_id => p_business_group_id);
1629:
1630: -- Create_Retro_Usages
1631: -- (p_creator_name
1632: -- => p_scheme_prefix||' Standard Tax Adjustment'
1633: -- ,p_creator_type => 'ET'
1634: -- ,p_retro_component_priority => 10
1635: -- ,p_default_component => 'Y'
1636: -- ,p_reprocess_type => 'R'

Line 1638: -- => p_scheme_prefix||' Retro Standard Tax Adjustment Previous Year'

1634: -- ,p_retro_component_priority => 10
1635: -- ,p_default_component => 'Y'
1636: -- ,p_reprocess_type => 'R'
1637: -- ,p_retro_element_name
1638: -- => p_scheme_prefix||' Retro Standard Tax Adjustment Previous Year'
1639: -- ,p_start_time_def_name => 'Start of Time'
1640: -- ,p_end_time_def_name => 'End of Previous Year'
1641: -- ,p_business_group_id => p_business_group_id);
1642:

Line 1669: -- => p_scheme_prefix||' ZVW Income Standard Tax Adjustment'

1665: -- ,p_end_time_def_name => 'End of Previous Year'
1666: -- ,p_business_group_id => p_business_group_id);
1667:
1668: -- Create_Retro_Usages (p_creator_name
1669: -- => p_scheme_prefix||' ZVW Income Standard Tax Adjustment'
1670: -- ,p_creator_type => 'ET'
1671: -- ,p_retro_component_priority => 10
1672: -- ,p_default_component => 'Y'
1673: -- ,p_reprocess_type => 'R'

Line 1675: -- => p_scheme_prefix||' Retro ZVW Income Standard Tax Adjustment Current Year'

1671: -- ,p_retro_component_priority => 10
1672: -- ,p_default_component => 'Y'
1673: -- ,p_reprocess_type => 'R'
1674: -- ,p_retro_element_name
1675: -- => p_scheme_prefix||' Retro ZVW Income Standard Tax Adjustment Current Year'
1676: -- ,p_start_time_def_name => 'Start of Current Year'
1677: -- ,p_end_time_def_name => 'End of Time'
1678: -- ,p_business_group_id => p_business_group_id);
1679:

Line 1682: -- => p_scheme_prefix||' ZVW Income Standard Tax Adjustment'

1678: -- ,p_business_group_id => p_business_group_id);
1679:
1680: -- Create_Retro_Usages
1681: -- (p_creator_name
1682: -- => p_scheme_prefix||' ZVW Income Standard Tax Adjustment'
1683: -- ,p_creator_type => 'ET'
1684: -- ,p_retro_component_priority => 10
1685: -- ,p_default_component => 'Y'
1686: -- ,p_reprocess_type => 'R'

Line 1688: -- => p_scheme_prefix||' Retro ZVW Income Standard Tax Adjustment Previous Year'

1684: -- ,p_retro_component_priority => 10
1685: -- ,p_default_component => 'Y'
1686: -- ,p_reprocess_type => 'R'
1687: -- ,p_retro_element_name
1688: -- => p_scheme_prefix||' Retro ZVW Income Standard Tax Adjustment Previous Year'
1689: -- ,p_start_time_def_name => 'Start of Time'
1690: -- ,p_end_time_def_name => 'End of Previous Year'
1691: -- ,p_business_group_id => p_business_group_id);
1692:

Line 1743: -- Compile the base element's standard formula

1739: hr_utility.set_location('Done Adding the Event Group', 60);
1740: END IF;
1741:
1742: -- ---------------------------------------------------------------------
1743: -- Compile the base element's standard formula
1744: -- ---------------------------------------------------------------------
1745: hr_utility.set_location('Compile EE Formula', 50);
1746:
1747: pqp_nl_pension_template.Compile_Formula

Line 1794: ,p_standard_link IN VARCHAR2

1790: ,p_er_deduction_method IN VARCHAR2
1791: ,p_saving_scheme_type IN VARCHAR2
1792: ,p_zvw_std_tax_chk IN VARCHAR2
1793: ,p_zvw_spl_tax_chk IN VARCHAR2
1794: ,p_standard_link IN VARCHAR2
1795: ,p_effective_start_date IN DATE DEFAULT NULL
1796: ,p_effective_end_date IN DATE DEFAULT NULL
1797: ,p_security_group_id IN NUMBER DEFAULT NULL
1798: ,p_business_group_id IN NUMBER

Line 1856: ,p_standard_link => p_standard_link

1852: ,p_arrearage_flag => p_arrearage_flag
1853: ,p_zvw_std_tax_chk => p_zvw_std_tax_chk
1854: ,p_zvw_spl_tax_chk => p_zvw_spl_tax_chk
1855: ,p_saving_scheme_type => p_saving_scheme_type
1856: ,p_standard_link => p_standard_link
1857: ,p_effective_start_date => p_effective_start_date
1858: ,p_effective_end_date => p_effective_end_date
1859: ,p_security_group_id => p_security_group_id
1860: ,p_business_group_id => p_business_group_id