[Home] [Help]
124: l_dummy varchar2(1);
125: --
126: cursor c1 is
127: select null
128: from per_establishment_attendances per
129: where per.person_id = p_person_id
130: and per.attended_start_date = nvl(p_attended_start_date,hr_api.g_sot)
131: and nvl(per.establishment_id,-1) = nvl(p_establishment_id,-1)
132: and nvl(per.establishment,-1) = nvl(p_establishment,-1)
133: and nvl(per.business_group_id,-1) = nvl(p_business_group_id,-1);
134: --
135: cursor c2 is
136: select null
137: from per_establishment_attendances per
138: where per.party_id = p_party_id
139: and per.attended_start_date = nvl(p_attended_start_date,hr_api.g_sot)
140: and nvl(per.establishment_id,-1) = nvl(p_establishment_id,-1)
141: and nvl(per.establishment,-1) = nvl(p_establishment,-1);
178: --
179: else
180: --
181: -- check if the changes made to the above parameters result in a unique
182: -- record existing in the per_establishment_attendances table, if not raise an
183: -- error as someone is trying to enter the same person twice.
184: --
185: open c2;
186: --
201: end if;
202: else
203: --
204: -- check if the changes made to the above parameters result in a unique
205: -- record existing in the per_establishment_attendances table, if not raise an
206: -- error as someone is trying to enter the same person twice.
207: --
208: open c1;
209: --
276: ,p_effective_date in date
277: )is
278: --
279: l_proc varchar2(72) := g_package||'chk_party_id';
280: l_party_id per_establishment_attendances.party_id%TYPE;
281: l_party_id2 per_establishment_attendances.party_id%TYPE;
282: --
283: --
284: -- cursor to check that the party_id maches person_id
277: )is
278: --
279: l_proc varchar2(72) := g_package||'chk_party_id';
280: l_party_id per_establishment_attendances.party_id%TYPE;
281: l_party_id2 per_establishment_attendances.party_id%TYPE;
282: --
283: --
284: -- cursor to check that the party_id maches person_id
285: --
668: l_dob date;
669: --
670: cursor c1 is
671: select null
672: from per_establishment_attendances per
673: where per.person_id = p_person_id
674: and per.establishment_id = p_establishment_id
675: and per.attendance_id <> nvl(p_attendance_id,-1)
676: and (nvl(p_attended_start_date,hr_api.g_sot)
693: -- HR/TCA merge
694: -- For party_id
695: cursor c3 is
696: select null
697: from per_establishment_attendances per
698: where per.party_id = p_party_id
699: and per.establishment_id = p_establishment_id
700: and per.attendance_id <> nvl(p_attendance_id,-1)
701: and (nvl(p_attended_start_date,hr_api.g_sot)
1148: -- b) During insert.
1149: --
1150: hr_dflex_utility.ins_or_upd_descflex_attribs
1151: (p_appl_short_name => 'PER'
1152: ,p_descflex_name => 'PER_ESTABLISHMENT_ATTENDANCES'
1153: ,p_attribute_category => p_rec.attribute_category
1154: ,p_attribute1_name => 'ATTRIBUTE1'
1155: ,p_attribute1_value => p_rec.attribute1
1156: ,p_attribute2_name => 'ATTRIBUTE2'
1448: -- |---------------------< return_legislation_code >-------------------------|
1449: -- ---------------------------------------------------------------------------
1450: --
1451: function return_legislation_code
1452: (p_attendance_id in per_establishment_attendances.attendance_id%TYPE
1453: ) return varchar2 is
1454: --
1455: -- Cursor to find legislation code
1456: --
1456: --
1457: cursor csr_leg_code is
1458: select pbg.legislation_code
1459: from per_business_groups pbg
1460: , per_establishment_attendances esa
1461: where esa.attendance_id = p_attendance_id
1462: and pbg.business_group_id = esa.business_group_id;
1463: --
1464: -- Cursor to find if the business group exists
1464: -- Cursor to find if the business group exists
1465: --
1466: cursor csr_no_bg is
1467: select 'Y'
1468: from per_establishment_attendances
1469: where attendance_id = p_attendance_id
1470: and business_group_id is null;
1471: --
1472: -- Declare local variables