eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_NL_SAVINGS_TEMPLATE dependencies on STANDARD

Line 310: ,p_standard_link in Varchar2

306: ,p_scheme_description in Varchar2
307: ,p_termination_rule in Varchar2
308: ,p_zvw_std_tax_chk IN VARCHAR2
309: ,p_zvw_spl_tax_chk IN VARCHAR2
310: ,p_standard_link in Varchar2
311: ,p_effective_start_date in Date
312: ,p_effective_end_date in Date
313: ,p_security_group_id in Number
314: ,p_business_group_id in Number

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

802: -- ---------------------------------------------------------------------
803: -- |-------------------< Update Shadow Structure >----------------------|
804: -- ---------------------------------------------------------------------
805: -- Get Element Type id and update user-specified Classification,
806: -- Category, Processing Type and Standard Link on Base Element
807: -- as well as other element created for the Scheme
808: -- ---------------------------------------------------------------------
809: -- 1. Special Inputs
810: for csr_rec in csr_shd_ele (p_scheme_prefix||' Special Inputs')

Line 866: -- 3. SI Gross Standard Adjustment

862: ||' Retro Employee Savings Deduction Previous Year';
863: END LOOP;
864:
865:
866: -- 3. SI Gross Standard Adjustment
867: for csr_rec in csr_shd_ele (p_scheme_prefix||' SI Gross Standard Adjustment')
868: loop
869: l_count := l_count +1;
870: l_shadow_element(l_count).element_type_id := csr_rec.element_type_id;

Line 867: for csr_rec in csr_shd_ele (p_scheme_prefix||' SI Gross Standard Adjustment')

863: END LOOP;
864:
865:
866: -- 3. SI Gross Standard Adjustment
867: for csr_rec in csr_shd_ele (p_scheme_prefix||' SI Gross Standard Adjustment')
868: loop
869: l_count := l_count +1;
870: l_shadow_element(l_count).element_type_id := csr_rec.element_type_id;
871: l_shadow_element(l_count).object_version_number := csr_rec.object_version_number;

Line 875: ||' SI Gross Standard Adjustment';

871: l_shadow_element(l_count).object_version_number := csr_rec.object_version_number;
872: l_shadow_element(l_count).reporting_name := nvl(p_reporting_name,p_scheme_prefix)
873: ||' SI Gross Std. Tax';
874: l_shadow_element(l_count).description := 'Element for '||p_scheme_prefix
875: ||' SI Gross Standard Adjustment';
876: end loop;
877: -- 4. Standard Tax Adjustment
878: for csr_rec in csr_shd_ele (p_scheme_prefix||' Standard Tax Adjustment')
879: loop

Line 877: -- 4. Standard Tax Adjustment

873: ||' SI Gross Std. Tax';
874: l_shadow_element(l_count).description := 'Element for '||p_scheme_prefix
875: ||' SI Gross Standard Adjustment';
876: end loop;
877: -- 4. Standard Tax Adjustment
878: for csr_rec in csr_shd_ele (p_scheme_prefix||' Standard Tax Adjustment')
879: loop
880: l_count := l_count + 1;
881: l_shadow_element(l_count).element_type_id := csr_rec.element_type_id;

Line 878: for csr_rec in csr_shd_ele (p_scheme_prefix||' Standard Tax Adjustment')

874: l_shadow_element(l_count).description := 'Element for '||p_scheme_prefix
875: ||' SI Gross Standard Adjustment';
876: end loop;
877: -- 4. Standard Tax Adjustment
878: for csr_rec in csr_shd_ele (p_scheme_prefix||' Standard Tax Adjustment')
879: loop
880: l_count := l_count + 1;
881: l_shadow_element(l_count).element_type_id := csr_rec.element_type_id;
882: l_shadow_element(l_count).object_version_number := csr_rec.object_version_number;

Line 886: ||' Standard Tax Adjustment';

882: l_shadow_element(l_count).object_version_number := csr_rec.object_version_number;
883: l_shadow_element(l_count).reporting_name := nvl(p_reporting_name,p_scheme_prefix)
884: ||' Std. Tax';
885: l_shadow_element(l_count).description := 'Element for '||p_scheme_prefix
886: ||' Standard Tax Adjustment';
887: end loop;
888: -- 5. SI Income Standard Adjustment
889: for csr_rec in csr_shd_ele (p_scheme_prefix||' SI Income Standard Adjustment')
890: loop

Line 888: -- 5. SI Income Standard Adjustment

884: ||' Std. Tax';
885: l_shadow_element(l_count).description := 'Element for '||p_scheme_prefix
886: ||' Standard Tax Adjustment';
887: end loop;
888: -- 5. SI Income Standard Adjustment
889: for csr_rec in csr_shd_ele (p_scheme_prefix||' SI Income Standard Adjustment')
890: loop
891: l_count := l_count + 1;
892: l_shadow_element(l_count).element_type_id := csr_rec.element_type_id;

Line 889: for csr_rec in csr_shd_ele (p_scheme_prefix||' SI Income Standard Adjustment')

885: l_shadow_element(l_count).description := 'Element for '||p_scheme_prefix
886: ||' Standard Tax Adjustment';
887: end loop;
888: -- 5. SI Income Standard Adjustment
889: for csr_rec in csr_shd_ele (p_scheme_prefix||' SI Income Standard Adjustment')
890: loop
891: l_count := l_count + 1;
892: l_shadow_element(l_count).element_type_id := csr_rec.element_type_id;
893: l_shadow_element(l_count).object_version_number := csr_rec.object_version_number;

Line 897: ||' SI Income Standard Adjustment';

893: l_shadow_element(l_count).object_version_number := csr_rec.object_version_number;
894: l_shadow_element(l_count).reporting_name := nvl(p_reporting_name,p_scheme_prefix)
895: ||' SI Income Std. Tax';
896: l_shadow_element(l_count).description := 'Element for '||p_scheme_prefix
897: ||' SI Income Standard Adjustment';
898: end loop;
899: -- 6. SI Gross Special Adjustment
900: for csr_rec in csr_shd_ele (p_scheme_prefix||' SI Gross Special Adjustment')
901: loop

Line 1025: -- Set the standard link flag only for EE and ER elements

1021:
1022: hr_utility.set_location('..Updating the scheme shadow elements', 30);
1023: for i in 1..l_count
1024: loop
1025: -- Set the standard link flag only for EE and ER elements
1026: -- if the standard link is Y
1027: IF UPPER(p_standard_link) = 'Y' THEN
1028: IF l_shadow_element(i).description LIKE '%Savings Deduction' OR
1029: l_shadow_element(i).description LIKE '%Employer Savings Contribution' THEN

Line 1026: -- if the standard link is Y

1022: hr_utility.set_location('..Updating the scheme shadow elements', 30);
1023: for i in 1..l_count
1024: loop
1025: -- Set the standard link flag only for EE and ER elements
1026: -- if the standard link is Y
1027: IF UPPER(p_standard_link) = 'Y' THEN
1028: IF l_shadow_element(i).description LIKE '%Savings Deduction' OR
1029: l_shadow_element(i).description LIKE '%Employer Savings Contribution' THEN
1030: l_std_link_flag := 'Y';

Line 1027: IF UPPER(p_standard_link) = 'Y' THEN

1023: for i in 1..l_count
1024: loop
1025: -- Set the standard link flag only for EE and ER elements
1026: -- if the standard link is Y
1027: IF UPPER(p_standard_link) = 'Y' THEN
1028: IF l_shadow_element(i).description LIKE '%Savings Deduction' OR
1029: l_shadow_element(i).description LIKE '%Employer Savings Contribution' THEN
1030: l_std_link_flag := 'Y';
1031: ELSE

Line 1043: ,p_standard_link_flag => nvl(l_std_link_flag, hr_api.g_varchar2)

1039: ,p_element_type_id => l_shadow_element(i).element_type_id
1040: ,p_description => l_shadow_element(i).description
1041: ,p_reporting_name => l_shadow_element(i).reporting_name
1042: ,p_post_termination_rule => p_termination_rule
1043: ,p_standard_link_flag => nvl(l_std_link_flag, hr_api.g_varchar2)
1044: ,p_object_version_number => l_shadow_element(i).object_version_number
1045: );
1046:
1047: -- Reset the value for standard link flag.

Line 1047: -- Reset the value for standard link flag.

1043: ,p_standard_link_flag => nvl(l_std_link_flag, hr_api.g_varchar2)
1044: ,p_object_version_number => l_shadow_element(i).object_version_number
1045: );
1046:
1047: -- Reset the value for standard link flag.
1048: l_std_link_flag := 'N';
1049:
1050: end loop;
1051:

Line 1052: -- Retro Standard Tax Adjustment Current Year

1048: l_std_link_flag := 'N';
1049:
1050: end loop;
1051:
1052: -- Retro Standard Tax Adjustment Current Year
1053:
1054: FOR csr_rec IN csr_shd_ele (p_scheme_prefix
1055: ||' Retro Standard Tax Adjustment Current Year')
1056: LOOP

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

1051:
1052: -- Retro Standard Tax Adjustment Current Year
1053:
1054: FOR csr_rec IN csr_shd_ele (p_scheme_prefix
1055: ||' Retro Standard Tax Adjustment Current Year')
1056: LOOP
1057: l_count := l_count + 1;
1058: l_shadow_element(l_count).element_type_id
1059: := csr_rec.element_type_id;

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

1063: := NVL(p_reporting_name,p_scheme_prefix)
1064: ||' Retro Std. Tax Adj CY';
1065: l_shadow_element(l_count).description
1066: := 'Element for '||p_scheme_prefix
1067: ||' Retro Standard Tax Adjustment Current Year';
1068: END LOOP;
1069:
1070:
1071: -- Retro Standard Tax Adjustment Previous Year

Line 1071: -- Retro Standard Tax Adjustment Previous Year

1067: ||' Retro Standard Tax Adjustment Current Year';
1068: END LOOP;
1069:
1070:
1071: -- Retro Standard Tax Adjustment Previous Year
1072:
1073: FOR csr_rec IN csr_shd_ele (p_scheme_prefix
1074: ||' Retro Standard Tax Adjustment Previous Year')
1075: LOOP

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

1070:
1071: -- Retro Standard Tax Adjustment Previous Year
1072:
1073: FOR csr_rec IN csr_shd_ele (p_scheme_prefix
1074: ||' Retro Standard Tax Adjustment Previous Year')
1075: LOOP
1076: l_count := l_count + 1;
1077: l_shadow_element(l_count).element_type_id
1078: := csr_rec.element_type_id;

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

1082: := NVL(p_reporting_name,p_scheme_prefix)
1083: ||' Retro Std. Tax Adj PY';
1084: l_shadow_element(l_count).description
1085: := 'Element for '||p_scheme_prefix
1086: ||' Retro Standard Tax Adjustment Previous Year';
1087: END LOOP;
1088:
1089: -- Special Tax Adjustment
1090:

Line 1140: -- ZVW Income Standard Tax Adjustment

1136: := 'Element for '||p_scheme_prefix
1137: ||' Retro Special Tax Adjustment Previous Year';
1138: END LOOP;
1139:
1140: -- ZVW Income Standard Tax Adjustment
1141:
1142: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' ZVW Income Standard Tax Adjustment')
1143: LOOP
1144: l_count := l_count + 1;

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

1138: END LOOP;
1139:
1140: -- ZVW Income Standard Tax Adjustment
1141:
1142: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' ZVW Income Standard Tax Adjustment')
1143: LOOP
1144: l_count := l_count + 1;
1145: l_shadow_element(l_count).element_type_id
1146: := csr_rec.element_type_id;

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

1148: := csr_rec.object_version_NUMBER;
1149: l_shadow_element(l_count).reporting_name
1150: := NVL(p_reporting_name,p_scheme_prefix)||' ZVW Income Std. Tax Adj.';
1151: l_shadow_element(l_count).description
1152: := 'Element for '||p_scheme_prefix||' ZVW Income Standard Tax Adjustment';
1153: END LOOP;
1154:
1155: -- Retro ZVW Income Standard Tax Adjustment Current Year
1156:

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

1151: l_shadow_element(l_count).description
1152: := 'Element for '||p_scheme_prefix||' ZVW Income Standard Tax Adjustment';
1153: END LOOP;
1154:
1155: -- Retro ZVW Income Standard Tax Adjustment Current Year
1156:
1157: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' Retro ZVW Income Standard Tax Adjustment Current Year')
1158: LOOP
1159: l_count := l_count + 1;

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

1153: END LOOP;
1154:
1155: -- Retro ZVW Income Standard Tax Adjustment Current Year
1156:
1157: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' Retro ZVW Income Standard Tax Adjustment Current Year')
1158: LOOP
1159: l_count := l_count + 1;
1160: l_shadow_element(l_count).element_type_id
1161: := csr_rec.element_type_id;

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

1163: := csr_rec.object_version_NUMBER;
1164: l_shadow_element(l_count).reporting_name
1165: := NVL(p_reporting_name,p_scheme_prefix)||' Retro ZVW Income Std. Tax Adj. CY';
1166: l_shadow_element(l_count).description
1167: := 'Element for '||p_scheme_prefix||' Retro ZVW Income Standard Tax Adjustment Current Year';
1168: END LOOP;
1169:
1170: -- Retro ZVW Income Standard Tax Adjustment Previous Year
1171:

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

1166: l_shadow_element(l_count).description
1167: := 'Element for '||p_scheme_prefix||' Retro ZVW Income Standard Tax Adjustment Current Year';
1168: END LOOP;
1169:
1170: -- Retro ZVW Income Standard Tax Adjustment Previous Year
1171:
1172: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' Retro ZVW Income Standard Tax Adjustment Previous Year')
1173: LOOP
1174: l_count := l_count + 1;

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

1168: END LOOP;
1169:
1170: -- Retro ZVW Income Standard Tax Adjustment Previous Year
1171:
1172: FOR csr_rec IN csr_shd_ele (p_scheme_prefix||' Retro ZVW Income Standard Tax Adjustment Previous Year')
1173: LOOP
1174: l_count := l_count + 1;
1175: l_shadow_element(l_count).element_type_id
1176: := csr_rec.element_type_id;

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

1178: := csr_rec.object_version_NUMBER;
1179: l_shadow_element(l_count).reporting_name
1180: := NVL(p_reporting_name,p_scheme_prefix)||' Retro ZVW Income Std. Tax Adj. PY';
1181: l_shadow_element(l_count).description
1182: := 'Element for '||p_scheme_prefix||' ZVW Income Standard Tax Adjustment Previous Year';
1183: END LOOP;
1184:
1185: -- ZVW Income Special Tax Adjustment
1186:

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

1759: -- ,p_end_time_def_name => 'End of Previous Year'
1760: -- ,p_business_group_id => p_business_group_id);
1761:
1762: -- Create_Retro_Usages (p_creator_name
1763: -- => p_scheme_prefix||' Standard Tax Adjustment'
1764: -- ,p_creator_type => 'ET'
1765: -- ,p_retro_component_priority => 10
1766: -- ,p_default_component => 'Y'
1767: -- ,p_reprocess_type => 'R'

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

1765: -- ,p_retro_component_priority => 10
1766: -- ,p_default_component => 'Y'
1767: -- ,p_reprocess_type => 'R'
1768: -- ,p_retro_element_name
1769: -- => p_scheme_prefix||' Retro Standard Tax Adjustment Current Year'
1770: -- ,p_start_time_def_name => 'Start of Current Year'
1771: -- ,p_end_time_def_name => 'End of Time'
1772: -- ,p_business_group_id => p_business_group_id);
1773:

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

1772: -- ,p_business_group_id => p_business_group_id);
1773:
1774: -- Create_Retro_Usages
1775: -- (p_creator_name
1776: -- => p_scheme_prefix||' Standard Tax Adjustment'
1777: -- ,p_creator_type => 'ET'
1778: -- ,p_retro_component_priority => 10
1779: -- ,p_default_component => 'Y'
1780: -- ,p_reprocess_type => 'R'

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

1778: -- ,p_retro_component_priority => 10
1779: -- ,p_default_component => 'Y'
1780: -- ,p_reprocess_type => 'R'
1781: -- ,p_retro_element_name
1782: -- => p_scheme_prefix||' Retro Standard Tax Adjustment Previous Year'
1783: -- ,p_start_time_def_name => 'Start of Time'
1784: -- ,p_end_time_def_name => 'End of Previous Year'
1785: -- ,p_business_group_id => p_business_group_id);
1786:

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

1809: -- ,p_end_time_def_name => 'End of Previous Year'
1810: -- ,p_business_group_id => p_business_group_id);
1811:
1812: --Create_Retro_Usages (p_creator_name
1813: -- => p_scheme_prefix||' ZVW Income Standard Tax Adjustment'
1814: -- ,p_creator_type => 'ET'
1815: -- ,p_retro_component_priority => 10
1816: -- ,p_default_component => 'Y'
1817: -- ,p_reprocess_type => 'R'

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

1815: -- ,p_retro_component_priority => 10
1816: -- ,p_default_component => 'Y'
1817: -- ,p_reprocess_type => 'R'
1818: -- ,p_retro_element_name
1819: -- => p_scheme_prefix||' Retro ZVW Income Standard Tax Adjustment Current Year'
1820: -- ,p_start_time_def_name => 'Start of Current Year'
1821: -- ,p_end_time_def_name => 'End of Time'
1822: -- ,p_business_group_id => p_business_group_id);
1823:

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

1822: -- ,p_business_group_id => p_business_group_id);
1823:
1824: -- Create_Retro_Usages
1825: -- (p_creator_name
1826: -- => p_scheme_prefix||' ZVW Income Standard Tax Adjustment'
1827: -- ,p_creator_type => 'ET'
1828: -- ,p_retro_component_priority => 10
1829: -- ,p_default_component => 'Y'
1830: -- ,p_reprocess_type => 'R'

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

1828: -- ,p_retro_component_priority => 10
1829: -- ,p_default_component => 'Y'
1830: -- ,p_reprocess_type => 'R'
1831: -- ,p_retro_element_name
1832: -- => p_scheme_prefix||' Retro ZVW Income Standard Tax Adjustment Previous Year'
1833: -- ,p_start_time_def_name => 'Start of Time'
1834: -- ,p_end_time_def_name => 'End of Previous Year'
1835: -- ,p_business_group_id => p_business_group_id);
1836:

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

1882: IF g_debug THEN
1883: hr_utility.set_location('Done Adding the Event Group', 60);
1884: END IF;
1885:
1886: -- Compile the base element's standard formula
1887: -- ---------------------------------------------------------------------
1888:
1889:
1890: pqp_nl_pension_template.Compile_Formula

Line 1939: ,p_standard_link in Varchar2

1935: ,p_scheme_description in Varchar2
1936: ,p_termination_rule in Varchar2
1937: ,p_zvw_std_tax_chk IN VARCHAR2
1938: ,p_zvw_spl_tax_chk IN VARCHAR2
1939: ,p_standard_link in Varchar2
1940: ,p_effective_start_date in Date
1941: ,p_effective_end_date in Date
1942: ,p_security_group_id in Number
1943: ,p_business_group_id in Number

Line 1999: ,p_standard_link => p_standard_link

1995: ,p_scheme_description => p_scheme_description
1996: ,p_termination_rule => p_termination_rule
1997: ,p_zvw_std_tax_chk => p_zvw_std_tax_chk
1998: ,p_zvw_spl_tax_chk => p_zvw_spl_tax_chk
1999: ,p_standard_link => p_standard_link
2000: ,p_effective_start_date => p_effective_start_date
2001: ,p_effective_end_date => p_effective_end_date
2002: ,p_security_group_id => p_security_group_id
2003: ,p_business_group_id => p_business_group_id