DBA Data[Home] [Help]

APPS.PER_QUA_BUS dependencies on PER_QUA_BUS

Line 1: Package Body per_qua_bus as

1: Package Body per_qua_bus as
2: /* $Header: pequarhi.pkb 120.0.12010000.2 2008/08/06 09:31:13 ubhat ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 111: if ( nvl(per_qua_bus.g_qualification_id, hr_api.g_number)

107: ,p_argument => 'qualification_id'
108: ,p_argument_value => p_qualification_id
109: );
110: --
111: if ( nvl(per_qua_bus.g_qualification_id, hr_api.g_number)
112: = p_qualification_id) then
113: --
114: -- The legislation code has already been found with a previous
115: -- call to this function. Just return the value in the global

Line 118: l_legislation_code := per_qua_bus.g_legislation_code;

114: -- The legislation code has already been found with a previous
115: -- call to this function. Just return the value in the global
116: -- variable.
117: --
118: l_legislation_code := per_qua_bus.g_legislation_code;
119: hr_utility.set_location(l_proc, 20);
120: else
121: --
122: -- The ID is different to the last call to this function

Line 142: per_qua_bus.g_qualification_id := p_qualification_id;

138: -- Set the global variables so the values are
139: -- available for the next call to this function.
140: --
141: close csr_leg_code;
142: per_qua_bus.g_qualification_id := p_qualification_id;
143: per_qua_bus.g_legislation_code := l_legislation_code;
144: end if;
145: hr_utility.set_location(' Leaving:'|| l_proc, 40);
146: return l_legislation_code;

Line 143: per_qua_bus.g_legislation_code := l_legislation_code;

139: -- available for the next call to this function.
140: --
141: close csr_leg_code;
142: per_qua_bus.g_qualification_id := p_qualification_id;
143: per_qua_bus.g_legislation_code := l_legislation_code;
144: end if;
145: hr_utility.set_location(' Leaving:'|| l_proc, 40);
146: return l_legislation_code;
147: end return_legislation_code;

Line 703: per_qua_bus.chk_awarded_date

699: --
700: --
701: Begin
702: --
703: per_qua_bus.chk_awarded_date
704: (p_qualification_id ,
705: p_awarded_date ,
706: p_start_date ,
707: NULL ,

Line 2257: per_qua_bus.chk_df(p_rec => p_rec);

2253: */
2254: --
2255: -- call descriptive flexfield validation routines
2256: --
2257: per_qua_bus.chk_df(p_rec => p_rec);
2258: --
2259: per_qua_bus.chk_ddf(p_rec);
2260: --
2261: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 2259: per_qua_bus.chk_ddf(p_rec);

2255: -- call descriptive flexfield validation routines
2256: --
2257: per_qua_bus.chk_df(p_rec => p_rec);
2258: --
2259: per_qua_bus.chk_ddf(p_rec);
2260: --
2261: hr_utility.set_location(' Leaving:'||l_proc, 10);
2262: End insert_validate;
2263: --

Line 2436: per_qua_bus.chk_df(p_rec => p_rec);

2432: */
2433: --
2434: -- call descriptive flexfield validation routines
2435: --
2436: per_qua_bus.chk_df(p_rec => p_rec);
2437: --
2438: per_qua_bus.chk_ddf(p_rec);
2439: --
2440: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 2438: per_qua_bus.chk_ddf(p_rec);

2434: -- call descriptive flexfield validation routines
2435: --
2436: per_qua_bus.chk_df(p_rec => p_rec);
2437: --
2438: per_qua_bus.chk_ddf(p_rec);
2439: --
2440: hr_utility.set_location(' Leaving:'||l_proc, 10);
2441: End update_validate;
2442: --

Line 2463: end per_qua_bus;

2459: --
2460: hr_utility.set_location(' Leaving:'||l_proc, 10);
2461: End delete_validate;
2462: --
2463: end per_qua_bus;