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.PE_FR_ADDITIONAL_ORG_RULES dependencies on HR_ORGANIZATION_INFORMATION

Line 121: from hr_organization_information

117: )
118: IS
119: cursor csr_get_org_id (p_org_information_id number) is
120: select organization_id
121: from hr_organization_information
122: where org_information_id = p_org_information_id;
123:
124: cursor csr_wa_check(
125: p_context varchar2

Line 126: ,p_org_id hr_organization_information.organization_id%TYPE

122: where org_information_id = p_org_information_id;
123:
124: cursor csr_wa_check(
125: p_context varchar2
126: ,p_org_id hr_organization_information.organization_id%TYPE
127: ,p_org_info_id hr_organization_information.org_information_id%TYPE
128: ,p_wa_type hr_organization_information.org_information4%TYPE
129: ,p_wa_order hr_organization_information.org_information5%TYPE) is
130: select null

Line 127: ,p_org_info_id hr_organization_information.org_information_id%TYPE

123:
124: cursor csr_wa_check(
125: p_context varchar2
126: ,p_org_id hr_organization_information.organization_id%TYPE
127: ,p_org_info_id hr_organization_information.org_information_id%TYPE
128: ,p_wa_type hr_organization_information.org_information4%TYPE
129: ,p_wa_order hr_organization_information.org_information5%TYPE) is
130: select null
131: from hr_organization_information

Line 128: ,p_wa_type hr_organization_information.org_information4%TYPE

124: cursor csr_wa_check(
125: p_context varchar2
126: ,p_org_id hr_organization_information.organization_id%TYPE
127: ,p_org_info_id hr_organization_information.org_information_id%TYPE
128: ,p_wa_type hr_organization_information.org_information4%TYPE
129: ,p_wa_order hr_organization_information.org_information5%TYPE) is
130: select null
131: from hr_organization_information
132: where org_information_context = p_context

Line 129: ,p_wa_order hr_organization_information.org_information5%TYPE) is

125: p_context varchar2
126: ,p_org_id hr_organization_information.organization_id%TYPE
127: ,p_org_info_id hr_organization_information.org_information_id%TYPE
128: ,p_wa_type hr_organization_information.org_information4%TYPE
129: ,p_wa_order hr_organization_information.org_information5%TYPE) is
130: select null
131: from hr_organization_information
132: where org_information_context = p_context
133: and organization_id = p_org_id

Line 131: from hr_organization_information

127: ,p_org_info_id hr_organization_information.org_information_id%TYPE
128: ,p_wa_type hr_organization_information.org_information4%TYPE
129: ,p_wa_order hr_organization_information.org_information5%TYPE) is
130: select null
131: from hr_organization_information
132: where org_information_context = p_context
133: and organization_id = p_org_id
134: and org_information_id <> nvl(p_org_info_id, -1)
135: and org_information3 = p_wa_type

Line 140: ,p_org_id hr_organization_information.organization_id%TYPE

136: and org_information5 <> p_wa_order;
137:
138: cursor csr_chk_overlaps(
139: p_context varchar2
140: ,p_org_id hr_organization_information.organization_id%TYPE
141: ,p_org_info_id hr_organization_information.org_information_id%TYPE
142: ,p_org_info1 hr_organization_information.org_information1%TYPE
143: ,p_org_info2 hr_organization_information.org_information2%TYPE
144: ,p_org_info3 hr_organization_information.org_information3%TYPE

Line 141: ,p_org_info_id hr_organization_information.org_information_id%TYPE

137:
138: cursor csr_chk_overlaps(
139: p_context varchar2
140: ,p_org_id hr_organization_information.organization_id%TYPE
141: ,p_org_info_id hr_organization_information.org_information_id%TYPE
142: ,p_org_info1 hr_organization_information.org_information1%TYPE
143: ,p_org_info2 hr_organization_information.org_information2%TYPE
144: ,p_org_info3 hr_organization_information.org_information3%TYPE
145: ,p_sot varchar2

Line 142: ,p_org_info1 hr_organization_information.org_information1%TYPE

138: cursor csr_chk_overlaps(
139: p_context varchar2
140: ,p_org_id hr_organization_information.organization_id%TYPE
141: ,p_org_info_id hr_organization_information.org_information_id%TYPE
142: ,p_org_info1 hr_organization_information.org_information1%TYPE
143: ,p_org_info2 hr_organization_information.org_information2%TYPE
144: ,p_org_info3 hr_organization_information.org_information3%TYPE
145: ,p_sot varchar2
146: ,p_eot varchar2) is

Line 143: ,p_org_info2 hr_organization_information.org_information2%TYPE

139: p_context varchar2
140: ,p_org_id hr_organization_information.organization_id%TYPE
141: ,p_org_info_id hr_organization_information.org_information_id%TYPE
142: ,p_org_info1 hr_organization_information.org_information1%TYPE
143: ,p_org_info2 hr_organization_information.org_information2%TYPE
144: ,p_org_info3 hr_organization_information.org_information3%TYPE
145: ,p_sot varchar2
146: ,p_eot varchar2) is
147: select 'Y'

Line 144: ,p_org_info3 hr_organization_information.org_information3%TYPE

140: ,p_org_id hr_organization_information.organization_id%TYPE
141: ,p_org_info_id hr_organization_information.org_information_id%TYPE
142: ,p_org_info1 hr_organization_information.org_information1%TYPE
143: ,p_org_info2 hr_organization_information.org_information2%TYPE
144: ,p_org_info3 hr_organization_information.org_information3%TYPE
145: ,p_sot varchar2
146: ,p_eot varchar2) is
147: select 'Y'
148: from hr_organization_information

Line 148: from hr_organization_information

144: ,p_org_info3 hr_organization_information.org_information3%TYPE
145: ,p_sot varchar2
146: ,p_eot varchar2) is
147: select 'Y'
148: from hr_organization_information
149: where org_information_context = p_context
150: and organization_id = p_org_id
151: and org_information_id <> nvl(p_org_info_id, -1)
152: and p_org_info2 >= nvl(org_information1,p_sot)

Line 161: l_org_id hr_organization_information.organization_id%TYPE;

157:
158: l_proc varchar2(72) := g_package || '.fr_validate_org_info';
159: l_sot varchar2(30);
160: l_eot varchar2(30);
161: l_org_id hr_organization_information.organization_id%TYPE;
162: l_org_info3 hr_organization_information.org_information3%TYPE;
163: l_overlap varchar2(1);
164:
165: BEGIN

Line 162: l_org_info3 hr_organization_information.org_information3%TYPE;

158: l_proc varchar2(72) := g_package || '.fr_validate_org_info';
159: l_sot varchar2(30);
160: l_eot varchar2(30);
161: l_org_id hr_organization_information.organization_id%TYPE;
162: l_org_info3 hr_organization_information.org_information3%TYPE;
163: l_overlap varchar2(1);
164:
165: BEGIN
166: --