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 5042: -- INSTALLATION PROCEDURE FOR : HR_STU_HISTORY

5038:
5039: END install_urows;
5040:
5041: --****************************************************************************
5042: -- INSTALLATION PROCEDURE FOR : HR_STU_HISTORY
5043: --****************************************************************************
5044:
5045: FUNCTION maintain_history (p_phase IN number) RETURN BOOLEAN
5046: ------------------------------------------------------------

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

5057: v_package_name varchar2(30);
5058:
5059: BEGIN
5060:
5061: -- First insert a row into the hr_stu_history table
5062:
5063: FOR r_legs in c_legs loop
5064:
5065: v_package_name := r_legs.package_name;

Line 5082: update hr_stu_history

5078: rollback;
5079: return FALSE;
5080: END IF;
5081:
5082: update hr_stu_history
5083: set status = 'Phase '||p_phase
5084: where package_name = v_package_name;
5085:
5086: IF SQL%NOTFOUND THEN

Line 5090: insert into hr_stu_history

5086: IF SQL%NOTFOUND THEN
5087: -- History row must exist for phase 2
5088: IF p_phase = 2 THEN return FALSE; END IF;
5089:
5090: insert into hr_stu_history
5091: (package_name
5092: ,date_of_export
5093: ,date_of_import
5094: ,status

Line 6574: update hr_stu_history

6570: IF v_exception_counter > 0 THEN
6571: --
6572: -- Output information for all rows in hr_stu_exceptions
6573: --
6574: update hr_stu_history
6575: set status = 'Phase '||p_phase||' has exceptions raised'
6576: where package_name in
6577: (select package_name
6578: from hr_s_history);

Line 6586: update hr_stu_history a

6582: -- No exceptions have been raised, phase must have been successful
6583:
6584: IF p_phase = 2 THEN
6585:
6586: update hr_stu_history a
6587: set a.status = 'Complete'
6588: where exists
6589: (select null
6590: from hr_s_history b