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.OTA_FTU_BUS dependencies on OTA_FTU_BUS

Line 1: Package Body ota_ftu_bus as

1: Package Body ota_ftu_bus as
2: /* $Header: otfturhi.pkb 120.1 2005/09/21 02:31 aabalakr noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' ota_ftu_bus.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ota_ftu_bus.'; -- Global package name
9: --
10: -- The following two global variables are only to be
11: -- used by the return_legislation_code function.
12: --

Line 176: if (( nvl(ota_ftu_bus.g_forum_thread_id, hr_api.g_number)

172: ,p_argument => 'contact_id'
173: ,p_argument_value => p_contact_id
174: );
175: --
176: if (( nvl(ota_ftu_bus.g_forum_thread_id, hr_api.g_number)
177: = p_forum_thread_id)
178: and ( nvl(ota_ftu_bus.g_forum_id, hr_api.g_number)
179: = p_forum_id)
180: and ( nvl(ota_ftu_bus.g_person_id, hr_api.g_number)

Line 178: and ( nvl(ota_ftu_bus.g_forum_id, hr_api.g_number)

174: );
175: --
176: if (( nvl(ota_ftu_bus.g_forum_thread_id, hr_api.g_number)
177: = p_forum_thread_id)
178: and ( nvl(ota_ftu_bus.g_forum_id, hr_api.g_number)
179: = p_forum_id)
180: and ( nvl(ota_ftu_bus.g_person_id, hr_api.g_number)
181: = p_person_id)
182: and ( nvl(ota_ftu_bus.g_contact_id, hr_api.g_number)

Line 180: and ( nvl(ota_ftu_bus.g_person_id, hr_api.g_number)

176: if (( nvl(ota_ftu_bus.g_forum_thread_id, hr_api.g_number)
177: = p_forum_thread_id)
178: and ( nvl(ota_ftu_bus.g_forum_id, hr_api.g_number)
179: = p_forum_id)
180: and ( nvl(ota_ftu_bus.g_person_id, hr_api.g_number)
181: = p_person_id)
182: and ( nvl(ota_ftu_bus.g_contact_id, hr_api.g_number)
183: = p_contact_id)) then
184: --

Line 182: and ( nvl(ota_ftu_bus.g_contact_id, hr_api.g_number)

178: and ( nvl(ota_ftu_bus.g_forum_id, hr_api.g_number)
179: = p_forum_id)
180: and ( nvl(ota_ftu_bus.g_person_id, hr_api.g_number)
181: = p_person_id)
182: and ( nvl(ota_ftu_bus.g_contact_id, hr_api.g_number)
183: = p_contact_id)) then
184: --
185: -- The legislation code has already been found with a previous
186: -- call to this function. Just return the value in the global

Line 189: l_legislation_code := ota_ftu_bus.g_legislation_code;

185: -- The legislation code has already been found with a previous
186: -- call to this function. Just return the value in the global
187: -- variable.
188: --
189: l_legislation_code := ota_ftu_bus.g_legislation_code;
190: hr_utility.set_location(l_proc, 20);
191: else
192: --
193: -- The ID is different to the last call to this function

Line 213: ota_ftu_bus.g_forum_thread_id := p_forum_thread_id;

209: -- Set the global variables so the values are
210: -- available for the next call to this function.
211: --
212: close csr_leg_code;
213: ota_ftu_bus.g_forum_thread_id := p_forum_thread_id;
214: ota_ftu_bus.g_forum_id := p_forum_id;
215: ota_ftu_bus.g_person_id := p_person_id;
216: ota_ftu_bus.g_contact_id := p_contact_id;
217: ota_ftu_bus.g_legislation_code := l_legislation_code;

Line 214: ota_ftu_bus.g_forum_id := p_forum_id;

210: -- available for the next call to this function.
211: --
212: close csr_leg_code;
213: ota_ftu_bus.g_forum_thread_id := p_forum_thread_id;
214: ota_ftu_bus.g_forum_id := p_forum_id;
215: ota_ftu_bus.g_person_id := p_person_id;
216: ota_ftu_bus.g_contact_id := p_contact_id;
217: ota_ftu_bus.g_legislation_code := l_legislation_code;
218: end if;

Line 215: ota_ftu_bus.g_person_id := p_person_id;

211: --
212: close csr_leg_code;
213: ota_ftu_bus.g_forum_thread_id := p_forum_thread_id;
214: ota_ftu_bus.g_forum_id := p_forum_id;
215: ota_ftu_bus.g_person_id := p_person_id;
216: ota_ftu_bus.g_contact_id := p_contact_id;
217: ota_ftu_bus.g_legislation_code := l_legislation_code;
218: end if;
219: hr_utility.set_location(' Leaving:'|| l_proc, 40);

Line 216: ota_ftu_bus.g_contact_id := p_contact_id;

212: close csr_leg_code;
213: ota_ftu_bus.g_forum_thread_id := p_forum_thread_id;
214: ota_ftu_bus.g_forum_id := p_forum_id;
215: ota_ftu_bus.g_person_id := p_person_id;
216: ota_ftu_bus.g_contact_id := p_contact_id;
217: ota_ftu_bus.g_legislation_code := l_legislation_code;
218: end if;
219: hr_utility.set_location(' Leaving:'|| l_proc, 40);
220: return l_legislation_code;

Line 217: ota_ftu_bus.g_legislation_code := l_legislation_code;

213: ota_ftu_bus.g_forum_thread_id := p_forum_thread_id;
214: ota_ftu_bus.g_forum_id := p_forum_id;
215: ota_ftu_bus.g_person_id := p_person_id;
216: ota_ftu_bus.g_contact_id := p_contact_id;
217: ota_ftu_bus.g_legislation_code := l_legislation_code;
218: end if;
219: hr_utility.set_location(' Leaving:'|| l_proc, 40);
220: return l_legislation_code;
221: end return_legislation_code;

Line 370: end ota_ftu_bus;

366: --
367: hr_utility.set_location(' Leaving:'||l_proc, 10);
368: End delete_validate;
369: --
370: end ota_ftu_bus;