APPS.HR_LEGISLATION dependencies on HR_STU_HISTORY

Line 241: -- 115.58 divicker 13-SEP-2001 fix so that hr_stu_history contains info

237: -- 115.55 divicker 03-SEP-2001 nvl added to munge sequence for fresh
238: -- installs (1967626). remove owner hr
239: -- 115.56 divicker 03-SEP-2001 munge_sequence owner selection added
240: -- 115.57 divicker 07-SEP-2001 2 fixes to install_leg_field
241: -- 115.58 divicker 13-SEP-2001 fix so that hr_stu_history contains info
242: -- on all legislations selected
243: -- 115.59 divicker 14-SEP-2001 nvl added to validation_name in select
244: -- stmt in install_leg_field proc.
245: -- 115.60 divicker 24-SEP-2001 fix for munge_sequence where same named

Line 5292: -- INSTALLATION PROCEDURE FOR : HR_STU_HISTORY

5288:
5289: END install_urows;
5290:
5291: --****************************************************************************
5292: -- INSTALLATION PROCEDURE FOR : HR_STU_HISTORY
5293: --****************************************************************************
5294:
5295: FUNCTION maintain_history (p_phase IN number) RETURN BOOLEAN
5296: ------------------------------------------------------------

Line 5311: -- First insert a row into the hr_stu_history table

5307: v_package_name varchar2(30);
5308:
5309: BEGIN
5310:
5311: -- First insert a row into the hr_stu_history table
5312:
5313: FOR r_legs in c_legs loop
5314:
5315: v_package_name := r_legs.package_name;

Line 5332: update hr_stu_history

5328: rollback;
5329: return FALSE;
5330: END IF;
5331:
5332: update hr_stu_history
5333: set status = 'Phase '||p_phase
5334: where package_name = v_package_name;
5335:
5336: IF SQL%NOTFOUND THEN

Line 5340: insert into hr_stu_history

5336: IF SQL%NOTFOUND THEN
5337: -- History row must exist for phase 2
5338: IF p_phase = 2 THEN return FALSE; END IF;
5339:
5340: insert into hr_stu_history
5341: (package_name
5342: ,date_of_export
5343: ,date_of_import
5344: ,status

Line 6824: update hr_stu_history

6820: IF v_exception_counter > 0 THEN
6821: --
6822: -- Output information for all rows in hr_stu_exceptions
6823: --
6824: update hr_stu_history
6825: set status = 'Phase '||p_phase||' has exceptions raised'
6826: where package_name in
6827: (select package_name
6828: from hr_s_history);

Line 6836: update hr_stu_history a

6832: -- No exceptions have been raised, phase must have been successful
6833:
6834: IF p_phase = 2 THEN
6835:
6836: update hr_stu_history a
6837: set a.status = 'Complete'
6838: where exists
6839: (select null
6840: from hr_s_history b