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_PENSION_TEMPLATE dependencies on STANDARD

Line 44: -- element's Standard status proc rule.

40: begin
41: hr_utility.set_location('Entering: '||l_proc_name, 10);
42: -- ------------------------------------------------------------
43: -- Query formula info (ie. the formula attached to this
44: -- element's Standard status proc rule.
45: -- ------------------------------------------------------------
46: for fra_rec in csr_fra (c_element_type_id => p_element_type_id)
47: loop
48: hr_utility.set_location('..FF Name :'||fra_rec.formula_name,15);

Line 263: ,p_standard_link in Varchar2

259: ,p_scheme_prefix in Varchar2
260: ,p_reporting_name in Varchar2
261: ,p_scheme_description in Varchar2
262: ,p_termination_rule in Varchar2
263: ,p_standard_link in Varchar2
264: ,p_effective_start_date in Date
265: ,p_effective_end_date in Date
266: ,p_security_group_id in Number
267: ,p_business_group_id in Number

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

759: -- ---------------------------------------------------------------------
760: -- |-------------------< Update Shadow Structure >----------------------|
761: -- ---------------------------------------------------------------------
762: -- Get Element Type id and update user-specified Classification,
763: -- Category, Processing Type and Standard Link on Base Element
764: -- as well as other element created for the Scheme
765: -- ---------------------------------------------------------------------
766: -- 1. Special Inputs
767: for csr_rec in csr_shd_ele (p_scheme_prefix||' Special Inputs')

Line 787: -- 3. SI Gross Standard Adjustment

783: l_shadow_element(l_count).reporting_name := nvl(p_reporting_name,p_scheme_prefix);
784: l_shadow_element(l_count).description := 'Element for '||p_scheme_prefix
785: ||' Pension Deduction';
786: end loop;
787: -- 3. SI Gross Standard Adjustment
788: for csr_rec in csr_shd_ele (p_scheme_prefix||' SI Gross Standard Adjustment')
789: loop
790: l_count := l_count +1;
791: l_shadow_element(l_count).element_type_id := csr_rec.element_type_id;

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

784: l_shadow_element(l_count).description := 'Element for '||p_scheme_prefix
785: ||' Pension Deduction';
786: end loop;
787: -- 3. SI Gross Standard Adjustment
788: for csr_rec in csr_shd_ele (p_scheme_prefix||' SI Gross Standard Adjustment')
789: loop
790: l_count := l_count +1;
791: l_shadow_element(l_count).element_type_id := csr_rec.element_type_id;
792: l_shadow_element(l_count).object_version_number := csr_rec.object_version_number;

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

792: l_shadow_element(l_count).object_version_number := csr_rec.object_version_number;
793: l_shadow_element(l_count).reporting_name := nvl(p_reporting_name,p_scheme_prefix)
794: ||' SI Gross Std. Adj.';
795: l_shadow_element(l_count).description := 'Element for '||p_scheme_prefix
796: ||' SI Gross Standard Adjustment';
797: end loop;
798: -- 4. Standard Tax Adjustment
799: for csr_rec in csr_shd_ele (p_scheme_prefix||' Standard Tax Adjustment')
800: loop

Line 798: -- 4. Standard Tax Adjustment

794: ||' SI Gross Std. Adj.';
795: l_shadow_element(l_count).description := 'Element for '||p_scheme_prefix
796: ||' SI Gross Standard Adjustment';
797: end loop;
798: -- 4. Standard Tax Adjustment
799: for csr_rec in csr_shd_ele (p_scheme_prefix||' Standard Tax Adjustment')
800: loop
801: l_count := l_count + 1;
802: l_shadow_element(l_count).element_type_id := csr_rec.element_type_id;

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

795: l_shadow_element(l_count).description := 'Element for '||p_scheme_prefix
796: ||' SI Gross Standard Adjustment';
797: end loop;
798: -- 4. Standard Tax Adjustment
799: for csr_rec in csr_shd_ele (p_scheme_prefix||' Standard Tax Adjustment')
800: loop
801: l_count := l_count + 1;
802: l_shadow_element(l_count).element_type_id := csr_rec.element_type_id;
803: l_shadow_element(l_count).object_version_number := csr_rec.object_version_number;

Line 807: ||' Standard Tax Adjustment';

803: l_shadow_element(l_count).object_version_number := csr_rec.object_version_number;
804: l_shadow_element(l_count).reporting_name := nvl(p_reporting_name,p_scheme_prefix)
805: ||' Std. Tax Adj.';
806: l_shadow_element(l_count).description := 'Element for '||p_scheme_prefix
807: ||' Standard Tax Adjustment';
808: end loop;
809: -- 5. SI Income Standard Adjustment
810: for csr_rec in csr_shd_ele (p_scheme_prefix||' SI Income Standard Adjustment')
811: loop

Line 809: -- 5. SI Income Standard Adjustment

805: ||' Std. Tax Adj.';
806: l_shadow_element(l_count).description := 'Element for '||p_scheme_prefix
807: ||' Standard Tax Adjustment';
808: end loop;
809: -- 5. SI Income Standard Adjustment
810: for csr_rec in csr_shd_ele (p_scheme_prefix||' SI Income Standard Adjustment')
811: loop
812: l_count := l_count + 1;
813: l_shadow_element(l_count).element_type_id := csr_rec.element_type_id;

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

806: l_shadow_element(l_count).description := 'Element for '||p_scheme_prefix
807: ||' Standard Tax Adjustment';
808: end loop;
809: -- 5. SI Income Standard Adjustment
810: for csr_rec in csr_shd_ele (p_scheme_prefix||' SI Income Standard Adjustment')
811: loop
812: l_count := l_count + 1;
813: l_shadow_element(l_count).element_type_id := csr_rec.element_type_id;
814: l_shadow_element(l_count).object_version_number := csr_rec.object_version_number;

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

814: l_shadow_element(l_count).object_version_number := csr_rec.object_version_number;
815: l_shadow_element(l_count).reporting_name := nvl(p_reporting_name,p_scheme_prefix)
816: ||' SI Income Std. Adj.';
817: l_shadow_element(l_count).description := 'Element for '||p_scheme_prefix
818: ||' SI Income Standard Adjustment';
819: end loop;
820: -- 6. SI Gross Special Adjustment
821: for csr_rec in csr_shd_ele (p_scheme_prefix||' SI Gross Special Adjustment')
822: loop

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

916:
917: hr_utility.set_location('..Updating the scheme shadow elements', 30);
918: for i in 1..l_count
919: loop
920: -- Set the standard link flag only for EE and ER elements
921: -- if the standard link is Y
922: IF UPPER(p_standard_link) = 'Y' THEN
923: IF l_shadow_element(i).description LIKE '%Pension Deduction' OR
924: l_shadow_element(i).description LIKE '%Employer Pension Contribution' THEN

Line 921: -- if the standard link is Y

917: hr_utility.set_location('..Updating the scheme shadow elements', 30);
918: for i in 1..l_count
919: loop
920: -- Set the standard link flag only for EE and ER elements
921: -- if the standard link is Y
922: IF UPPER(p_standard_link) = 'Y' THEN
923: IF l_shadow_element(i).description LIKE '%Pension Deduction' OR
924: l_shadow_element(i).description LIKE '%Employer Pension Contribution' THEN
925: l_std_link_flag := 'Y';

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

918: for i in 1..l_count
919: loop
920: -- Set the standard link flag only for EE and ER elements
921: -- if the standard link is Y
922: IF UPPER(p_standard_link) = 'Y' THEN
923: IF l_shadow_element(i).description LIKE '%Pension Deduction' OR
924: l_shadow_element(i).description LIKE '%Employer Pension Contribution' THEN
925: l_std_link_flag := 'Y';
926: ELSE

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

934: ,p_element_type_id => l_shadow_element(i).element_type_id
935: ,p_description => l_shadow_element(i).description
936: ,p_reporting_name => l_shadow_element(i).reporting_name
937: ,p_post_termination_rule => p_termination_rule
938: ,p_standard_link_flag => nvl(l_std_link_flag, hr_api.g_varchar2)
939: ,p_object_version_number => l_shadow_element(i).object_version_number
940: );
941:
942: -- Reset the value for standard link flag.

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

938: ,p_standard_link_flag => nvl(l_std_link_flag, hr_api.g_varchar2)
939: ,p_object_version_number => l_shadow_element(i).object_version_number
940: );
941:
942: -- Reset the value for standard link flag.
943: l_std_link_flag := 'N';
944:
945: end loop;
946: hr_utility.set_location('..After Updating the scheme shadow elements', 50);

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

1572: -- Create the Balance feeds for the eligible comp balance
1573: -- ---------------------------------------------------------------------
1574: Create_Pen_Sal_Bal_Feeds ;
1575: -- ---------------------------------------------------------------------
1576: -- Compile the base element's standard formula
1577: -- ---------------------------------------------------------------------
1578:
1579:
1580: Compile_Formula

Line 1626: ,p_standard_link in Varchar2

1622: ,p_scheme_prefix in Varchar2
1623: ,p_reporting_name in Varchar2
1624: ,p_scheme_description in Varchar2
1625: ,p_termination_rule in Varchar2
1626: ,p_standard_link in Varchar2
1627: ,p_effective_start_date in Date
1628: ,p_effective_end_date in Date
1629: ,p_security_group_id in Number
1630: ,p_business_group_id in Number

Line 1683: ,p_standard_link => p_standard_link

1679: ,p_scheme_prefix => p_scheme_prefix
1680: ,p_reporting_name => p_reporting_name
1681: ,p_scheme_description => p_scheme_description
1682: ,p_termination_rule => p_termination_rule
1683: ,p_standard_link => p_standard_link
1684: ,p_effective_start_date => p_effective_start_date
1685: ,p_effective_end_date => p_effective_end_date
1686: ,p_security_group_id => p_security_group_id
1687: ,p_business_group_id => p_business_group_id