17: ,p_scheme_prefix IN VARCHAR2
18: ,p_reporting_name IN VARCHAR2
19: ,p_scheme_description IN VARCHAR2
20: ,p_termination_rule IN VARCHAR2
21: ,p_standard_link IN VARCHAR2
22: ,p_effective_start_date IN DATE DEFAULT NULL
23: ,p_effective_end_date IN DATE DEFAULT NULL
24: ,p_security_group_id IN NUMBER DEFAULT NULL
25: ,p_business_group_id IN NUMBER
265: ,'OPNP_W25','OPNPW25'
266: ,'OPNP_W50','OPNPW50'
267: ,'FPU_E','FPU Extra'
268: ,'FPU_R','FPU Raise'
269: ,'FPU_S','FPU Standard'
270: ,'FPU_T','FPU Total'
271: ,'FUR_S','FUR Standard'
272: ,'IPAP','IPAP'
273: ,'IPBW_H','IPBW High'
267: ,'FPU_E','FPU Extra'
268: ,'FPU_R','FPU Raise'
269: ,'FPU_S','FPU Standard'
270: ,'FPU_T','FPU Total'
271: ,'FUR_S','FUR Standard'
272: ,'IPAP','IPAP'
273: ,'IPBW_H','IPBW High'
274: ,'IPBW_L','IPBW Low'
275: ,'VSG','VSG'
993: -- ---------------------------------------------------------------------
994: -- |-------------------< Update Shadow Structure >----------------------|
995: -- ---------------------------------------------------------------------
996: -- Get Element Type id and update user-specified Classification,
997: -- Category, Processing Type and Standard Link on Base Element
998: -- as well as other element created for the Scheme
999: -- ---------------------------------------------------------------------
1000:
1001: -- 1.
1027: l_shadow_element(l_count).description
1028: := 'Element for '||p_scheme_prefix||' ABP Pension Deduction';
1029: END LOOP;
1030:
1031: -- 3.
1032:
1033: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' SI Gross Standard Adjustment')
1034: LOOP
1035: l_count := l_count +1;
1029: END LOOP;
1030:
1031: -- 3.
1032:
1033: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' SI Gross Standard Adjustment')
1034: LOOP
1035: l_count := l_count +1;
1036: l_shadow_element(l_count).element_type_id
1037: := csr_rec.element_type_id;
1039: := csr_rec.object_version_NUMBER;
1040: l_shadow_element(l_count).reporting_name
1041: := NVL(p_reporting_name,p_scheme_prefix)||' SI Gross Std. Adj.';
1042: l_shadow_element(l_count).description
1043: := 'Element for '||p_scheme_prefix||' SI Gross Standard Adjustment';
1044: END LOOP;
1045:
1046: -- 4.
1047:
1042: l_shadow_element(l_count).description
1043: := 'Element for '||p_scheme_prefix||' SI Gross Standard Adjustment';
1044: END LOOP;
1045:
1046: -- 4.
1047:
1048: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' Standard Tax Adjustment')
1049: LOOP
1050: l_count := l_count + 1;
1044: END LOOP;
1045:
1046: -- 4.
1047:
1048: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' Standard Tax Adjustment')
1049: LOOP
1050: l_count := l_count + 1;
1051: l_shadow_element(l_count).element_type_id
1052: := csr_rec.element_type_id;
1054: := csr_rec.object_version_NUMBER;
1055: l_shadow_element(l_count).reporting_name
1056: := NVL(p_reporting_name,p_scheme_prefix)||' Std. Tax Adj.';
1057: l_shadow_element(l_count).description
1058: := 'Element for '||p_scheme_prefix||' Standard Tax Adjustment';
1059: END LOOP;
1060:
1061: -- 5.
1062:
1057: l_shadow_element(l_count).description
1058: := 'Element for '||p_scheme_prefix||' Standard Tax Adjustment';
1059: END LOOP;
1060:
1061: -- 5.
1062:
1063: FOR csr_rec IN csr_shd_ele(p_scheme_prefix||' SI Income Standard Adjustment')
1064: LOOP
1065: l_count := l_count + 1;
1059: END LOOP;
1060:
1061: -- 5.
1062:
1063: FOR csr_rec IN csr_shd_ele(p_scheme_prefix||' SI Income Standard Adjustment')
1064: LOOP
1065: l_count := l_count + 1;
1066: l_shadow_element(l_count).element_type_id
1067: := csr_rec.element_type_id;
1069: := csr_rec.object_version_NUMBER;
1070: l_shadow_element(l_count).reporting_name
1071: := NVL(p_reporting_name,p_scheme_prefix)||' SI Income Std. Adj.';
1072: l_shadow_element(l_count).description
1073: := 'Element for '||p_scheme_prefix||' SI Income Standard Adjustment';
1074: END LOOP;
1075:
1076: -- 6.
1077:
1810: -- Create the Balance feeds for the eligible comp balance
1811: -- ---------------------------------------------------------------------
1812: --Create_Pen_Sal_Bal_Feeds ;
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
1884: ,p_scheme_prefix IN VARCHAR2
1885: ,p_reporting_name IN VARCHAR2
1886: ,p_scheme_description IN VARCHAR2
1887: ,p_termination_rule IN VARCHAR2
1888: ,p_standard_link IN VARCHAR2
1889: ,p_effective_start_date IN DATE DEFAULT NULL
1890: ,p_effective_end_date IN DATE DEFAULT NULL
1891: ,p_security_group_id IN NUMBER DEFAULT NULL
1892: ,p_business_group_id IN NUMBER
1941: ,p_scheme_prefix => p_scheme_prefix
1942: ,p_reporting_name => p_reporting_name
1943: ,p_scheme_description => p_scheme_description
1944: ,p_termination_rule => p_termination_rule
1945: ,p_standard_link => p_standard_link
1946: ,p_effective_start_date => p_effective_start_date
1947: ,p_effective_end_date => p_effective_end_date
1948: ,p_security_group_id => p_security_group_id
1949: ,p_business_group_id => p_business_group_id