DBA Data[Home] [Help]

APPS.PQP_NL_ABP_TEMPLATE dependencies on STANDARD

Line 21: ,p_standard_link IN VARCHAR2

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

Line 269: ,'FPU_S','FPU Standard'

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'

Line 271: ,'FUR_S','FUR Standard'

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'

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

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. ABP Special Inputs

Line 1031: -- 3. SI Gross Standard Adjustment

1027: l_shadow_element(l_count).description
1028: := 'Element for '||p_scheme_prefix||' ABP Pension Deduction';
1029: END LOOP;
1030:
1031: -- 3. SI Gross Standard Adjustment
1032:
1033: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' SI Gross Standard Adjustment')
1034: LOOP
1035: l_count := l_count +1;

Line 1033: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' SI Gross Standard Adjustment')

1029: END LOOP;
1030:
1031: -- 3. SI Gross Standard Adjustment
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;

Line 1043: := 'Element for '||p_scheme_prefix||' SI Gross Standard Adjustment';

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. Standard Tax Adjustment
1047:

Line 1046: -- 4. Standard Tax Adjustment

1042: l_shadow_element(l_count).description
1043: := 'Element for '||p_scheme_prefix||' SI Gross Standard Adjustment';
1044: END LOOP;
1045:
1046: -- 4. Standard Tax Adjustment
1047:
1048: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' Standard Tax Adjustment')
1049: LOOP
1050: l_count := l_count + 1;

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

1044: END LOOP;
1045:
1046: -- 4. Standard Tax Adjustment
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;

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

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. SI Income Standard Adjustment
1062:

Line 1061: -- 5. SI Income Standard Adjustment

1057: l_shadow_element(l_count).description
1058: := 'Element for '||p_scheme_prefix||' Standard Tax Adjustment';
1059: END LOOP;
1060:
1061: -- 5. SI Income Standard Adjustment
1062:
1063: FOR csr_rec IN csr_shd_ele(p_scheme_prefix||' SI Income Standard Adjustment')
1064: LOOP
1065: l_count := l_count + 1;

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

1059: END LOOP;
1060:
1061: -- 5. SI Income Standard Adjustment
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;

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

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. SI Gross Special Adjustment
1077:

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

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

Line 1888: ,p_standard_link IN VARCHAR2

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

Line 1945: ,p_standard_link => p_standard_link

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