[Home] [Help]
14: g_gap_daily_absence_id number default null;
15:
16: /*
17: -- Commented out set_security_group_id proc as currently
18: -- the proc in row handler of parent table PQP_GAP_ABSENCE_PLANS
19: -- does the job.
20: --
21: -- ---------------------------------------------------------------------------
22: -- |----------------------< set_security_group_id >--------------------------|
32: cursor csr_sec_grp is
33: select pbg.security_group_id,
34: pbg.legislation_code
35: from pqp_gap_daily_absences gda
36: , pqp_gap_absence_plans gap
37: , per_all_assignments_f paa
38: , per_business_groups_perf pbg
39: where gda.gap_daily_absence_id = p_gap_daily_absence_id
40: and gap.gap_absence_plan_id = gda.gap_absence_plan_id
108: --
109: cursor csr_leg_code is
110: select pbg.legislation_code
111: from pqp_gap_daily_absences gda
112: , pqp_gap_absence_plans gap
113: , per_all_assignments_f paa
114: , per_business_groups_perf pbg
115: where gda.gap_daily_absence_id = p_gap_daily_absence_id
116: and gap.gap_absence_plan_id = gda.gap_absence_plan_id
276: ) IS
277: --
278: Cursor ChkGAPId is
279: Select 'Y'
280: From pqp_gap_absence_plans gap
281: Where gap.gap_absence_plan_id = p_gap_absence_plan_id;
282: --
283: l_proc varchar2(72) := g_package || 'chk_gap_absence_plan_id';
284: l_GAPValid char(1) := 'N';
925: -- Call all supporting business operations
926: --
927:
928: -- Calling set_securit_group_id from row handler of parent
929: -- table PQP_GAP_ABSENCE_PLANS as FK is available
930: pqp_gap_bus.set_security_group_id
931: (p_gap_absence_plan_id => p_rec.gap_absence_plan_id
932: );
933: --
998: -- Call all supporting business operations
999: --
1000:
1001: -- Calling set_securit_group_id from row handler of parent
1002: -- table PQP_GAP_ABSENCE_PLANS as FK is available
1003: pqp_gap_bus.set_security_group_id
1004: (p_gap_absence_plan_id => p_rec.gap_absence_plan_id
1005: );
1006: