DBA Data[Home] [Help]

APPS.PAY_ELEMENT_LINK_API dependencies on STANDARD

Line 30: ,p_standard_link_flag in varchar2 default null

26: ,p_balancing_keyflex_id in number default null
27: ,p_element_set_id in number default null
28: ,p_pay_basis_id in number default null
29: ,p_link_to_all_payrolls_flag in varchar2 default 'N'
30: ,p_standard_link_flag in varchar2 default null
31: ,p_transfer_to_gl_flag in varchar2 default 'N'
32: ,p_comments in varchar2 default null
33: ,p_employment_category in varchar2 default null
34: ,p_qualifying_age in number default null

Line 132: l_standard_link_flag pay_element_links_f.standard_link_flag%type

128: --
129: l_proc varchar2(72) := g_package||'create_element_link';
130: l_effective_date date;
131:
132: l_standard_link_flag pay_element_links_f.standard_link_flag%type
133: := p_standard_link_flag;
134: l_cost_allocation_id number := p_cost_allocation_keyflex_id;
135: l_bal_allocation_id number := p_balancing_keyflex_id;
136:

Line 133: := p_standard_link_flag;

129: l_proc varchar2(72) := g_package||'create_element_link';
130: l_effective_date date;
131:
132: l_standard_link_flag pay_element_links_f.standard_link_flag%type
133: := p_standard_link_flag;
134: l_cost_allocation_id number := p_cost_allocation_keyflex_id;
135: l_bal_allocation_id number := p_balancing_keyflex_id;
136:
137: --

Line 178: ,p_standard_link_flag => l_standard_link_flag

174: ,p_balancing_keyflex_id => l_bal_allocation_id
175: ,p_element_set_id => p_element_set_id
176: ,p_pay_basis_id => p_pay_basis_id
177: ,p_link_to_all_payrolls_flag => p_link_to_all_payrolls_flag
178: ,p_standard_link_flag => l_standard_link_flag
179: ,p_transfer_to_gl_flag => p_transfer_to_gl_flag
180: ,p_comments => p_comments
181: ,p_employment_category => p_employment_category
182: ,p_qualifying_age => p_qualifying_age

Line 298: ,p_standard_link_flag => l_standard_link_flag

294: ,p_balancing_keyflex_id => l_bal_allocation_id
295: ,p_element_set_id => p_element_set_id
296: ,p_pay_basis_id => p_pay_basis_id
297: ,p_link_to_all_payrolls_flag => p_link_to_all_payrolls_flag
298: ,p_standard_link_flag => l_standard_link_flag
299: ,p_transfer_to_gl_flag => p_transfer_to_gl_flag
300: ,p_comments => p_comments
301: ,p_employment_category => p_employment_category
302: ,p_qualifying_age => p_qualifying_age

Line 406: -- Creates Standard Entries in case Standard link flag is 'Y'

402: ,p_effective_end_date => l_effective_end_date
403: );
404: end if;
405:
406: -- Creates Standard Entries in case Standard link flag is 'Y'
407: if l_standard_link_flag = 'Y' then
408: pay_pel_bus.chk_standard_entries
409: (p_business_group_id => p_business_group_id
410: ,p_element_link_id => l_element_link_id

Line 407: if l_standard_link_flag = 'Y' then

403: );
404: end if;
405:
406: -- Creates Standard Entries in case Standard link flag is 'Y'
407: if l_standard_link_flag = 'Y' then
408: pay_pel_bus.chk_standard_entries
409: (p_business_group_id => p_business_group_id
410: ,p_element_link_id => l_element_link_id
411: ,p_element_type_id => p_element_type_id

Line 408: pay_pel_bus.chk_standard_entries

404: end if;
405:
406: -- Creates Standard Entries in case Standard link flag is 'Y'
407: if l_standard_link_flag = 'Y' then
408: pay_pel_bus.chk_standard_entries
409: (p_business_group_id => p_business_group_id
410: ,p_element_link_id => l_element_link_id
411: ,p_element_type_id => p_element_type_id
412: ,p_effective_start_date => l_effective_start_date

Line 448: ,p_standard_link_flag => p_standard_link_flag

444: ,p_balancing_keyflex_id => l_bal_allocation_id
445: ,p_element_set_id => p_element_set_id
446: ,p_pay_basis_id => p_pay_basis_id
447: ,p_link_to_all_payrolls_flag => p_link_to_all_payrolls_flag
448: ,p_standard_link_flag => p_standard_link_flag
449: ,p_transfer_to_gl_flag => p_transfer_to_gl_flag
450: ,p_comments => p_comments
451: ,p_employment_category => p_employment_category
452: ,p_qualifying_age => p_qualifying_age

Line 605: ,p_standard_link_flag in varchar2 default hr_api.g_varchar2

601: ,p_datetrack_mode in varchar2
602: ,p_costable_type in varchar2 default hr_api.g_varchar2
603: ,p_element_set_id in number default hr_api.g_number
604: ,p_multiply_value_flag in varchar2 default hr_api.g_varchar2
605: ,p_standard_link_flag in varchar2 default hr_api.g_varchar2
606: ,p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2
607: ,p_comments in varchar2 default hr_api.g_varchar2
608: ,p_comment_id in varchar2 default hr_api.g_varchar2
609: ,p_employment_category in varchar2 default hr_api.g_varchar2

Line 719: ,standard_link_flag

715: -- cursor to fetch the current values of the element link record
716: cursor csr_bg_et is
717: select business_group_id
718: ,element_type_id
719: ,standard_link_flag
720: ,payroll_id
721: ,link_to_all_payrolls_flag
722: ,job_id
723: ,grade_id

Line 770: ,p_standard_link_flag

766: ,p_datetrack_mode
767: ,p_costable_type
768: ,p_element_set_id
769: ,p_multiply_value_flag
770: ,p_standard_link_flag
771: ,p_transfer_to_gl_flag
772: ,p_comments
773: ,p_comment_id
774: ,p_employment_category

Line 998: ,p_standard_link_flag => p_standard_link_flag

994: ,p_element_type_id => l_element_link_rec.element_type_id
995: ,p_business_group_id => l_element_link_rec.business_group_id
996: ,p_costable_type => p_costable_type
997: ,p_multiply_value_flag => p_multiply_value_flag
998: ,p_standard_link_flag => p_standard_link_flag
999: ,p_transfer_to_gl_flag => p_transfer_to_gl_flag
1000: ,p_cost_allocation_keyflex_id => l_cost_allocation_id
1001: ,p_balancing_keyflex_id => l_bal_allocation_id
1002: ,p_element_set_id => p_element_set_id

Line 1036: -- Create element entries if the standard_link_flag is changed from 'N' to 'Y',

1032: ,p_effective_start_date => p_effective_start_date
1033: ,p_effective_end_date => p_effective_end_date
1034: );
1035: --
1036: -- Create element entries if the standard_link_flag is changed from 'N' to 'Y',
1037: -- with the following conditions -
1038: -- 1. Entries for the link should not exist.
1039: -- 2. All required input values should have a default value.
1040: --

Line 1041: if ((l_element_link_rec.standard_link_flag = 'N' and

1037: -- with the following conditions -
1038: -- 1. Entries for the link should not exist.
1039: -- 2. All required input values should have a default value.
1040: --
1041: if ((l_element_link_rec.standard_link_flag = 'N' and
1042: p_standard_link_flag = 'Y')) and
1043: (NOT pay_element_links_pkg.element_entries_exist(p_element_link_id,
1044: TRUE))
1045: then

Line 1042: p_standard_link_flag = 'Y')) and

1038: -- 1. Entries for the link should not exist.
1039: -- 2. All required input values should have a default value.
1040: --
1041: if ((l_element_link_rec.standard_link_flag = 'N' and
1042: p_standard_link_flag = 'Y')) and
1043: (NOT pay_element_links_pkg.element_entries_exist(p_element_link_id,
1044: TRUE))
1045: then
1046: --

Line 1051: pay_pel_bus.chk_standard_entries

1047: pay_link_input_values_pkg.check_required_defaults
1048: (p_element_link_id,
1049: p_effective_date);
1050: --
1051: pay_pel_bus.chk_standard_entries
1052: (p_business_group_id => l_element_link_rec.business_group_id
1053: ,p_element_link_id => p_element_link_id
1054: ,p_element_type_id => l_element_link_rec.element_type_id
1055: ,p_effective_start_date => p_effective_start_date

Line 1081: ,p_standard_link_flag

1077: ,p_datetrack_mode
1078: ,p_costable_type
1079: ,p_element_set_id
1080: ,p_multiply_value_flag
1081: ,p_standard_link_flag
1082: ,p_transfer_to_gl_flag
1083: ,p_comments
1084: ,p_comment_id
1085: ,p_employment_category