APPS.PQH_FR_STAT_SITUATIONS_API dependencies on PQH_FR_STAT_SITUATIONS

Line 1: Package Body pqh_fr_stat_situations_api as

1: Package Body pqh_fr_stat_situations_api as
2: /* $Header: pqstsapi.pkb 120.0 2005/05/29 02:43:03 appldev noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' pqh_fr_stat_situations_api.';

2: /* $Header: pqstsapi.pkb 120.0 2005/05/29 02:43:03 appldev noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_fr_stat_situations_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |----------------------------------------------|

Line 57: l_statutory_situation_id pqh_fr_stat_situations.statutory_situation_id%type;

53: l_in_out_parameter number;
54: l_effective_date date;
55: l_proc varchar2(72) := g_package||'create_statutory_situation';
56: l_object_version_number number(9);
57: l_statutory_situation_id pqh_fr_stat_situations.statutory_situation_id%type;
58:
59: begin
60:
61: g_debug := hr_utility.debug_enabled;

Line 85: pqh_fr_stat_situations_bk1.create_statutory_situation_b

81: --
82: -- Call Before Process User Hook
83: --
84: begin
85: pqh_fr_stat_situations_bk1.create_statutory_situation_b
86: ( p_effective_date => l_effective_date
87: ,p_business_group_id => p_business_group_id
88: ,p_situation_name => p_situation_name
89: ,p_type_of_ps => p_type_of_ps

Line 176: pqh_fr_stat_situations_bk1.create_statutory_situation_a

172: --
173: -- Call After Process User Hook
174: --
175: begin
176: pqh_fr_stat_situations_bk1.create_statutory_situation_a
177: ( p_effective_date => l_effective_date
178: ,p_business_group_id => p_business_group_id
179: ,p_situation_name => p_situation_name
180: ,p_type_of_ps => p_type_of_ps

Line 324: l_statutory_situation_id pqh_fr_stat_situations.statutory_situation_id%type;

320: l_effective_date date;
321: l_proc varchar2(72) := g_package||'update_statutory_situation';
322: l_object_version_number number(9);
323: l_in_out_ovn number(9);
324: l_statutory_situation_id pqh_fr_stat_situations.statutory_situation_id%type;
325:
326: begin
327:
328: g_debug := hr_utility.debug_enabled;

Line 356: pqh_fr_stat_situations_bk2.update_statutory_situation_b

352: --
353: -- Call Before Process User Hook
354: --
355: begin
356: pqh_fr_stat_situations_bk2.update_statutory_situation_b
357: ( p_effective_date => l_effective_date
358: ,p_business_group_id => p_business_group_id
359: ,p_situation_name => p_situation_name
360: ,p_type_of_ps => p_type_of_ps

Line 447: pqh_fr_stat_situations_bk2.update_statutory_situation_a

443: --
444: -- Call After Process User Hook
445: --
446: begin
447: pqh_fr_stat_situations_bk2.update_statutory_situation_a
448: ( p_effective_date => l_effective_date
449: ,p_business_group_id => p_business_group_id
450: ,p_situation_name => p_situation_name
451: ,p_type_of_ps => p_type_of_ps

Line 560: l_statutory_situation_id pqh_fr_stat_situations.statutory_situation_id%type;

556: l_in_out_parameter number;
557: l_effective_date date;
558: l_proc varchar2(72) := g_package||'delete_statutory_situation';
559: l_object_version_number number(9);
560: l_statutory_situation_id pqh_fr_stat_situations.statutory_situation_id%type;
561:
562: --
563: Cursor Csr_Any_Civil_Servant_On_Sit IS
564: Select null

Line 609: pqh_fr_stat_situations_bk3.delete_statutory_situation_b

605: --
606: -- Call Before Process User Hook
607: --
608: begin
609: pqh_fr_stat_situations_bk3.delete_statutory_situation_b
610: ( p_statutory_situation_id => p_statutory_situation_id
611: ,p_object_version_number => l_object_version_number
612: );
613:

Line 637: pqh_fr_stat_situations_bk3.delete_statutory_situation_a

633: --
634: -- Call After Process User Hook
635: --
636: begin
637: pqh_fr_stat_situations_bk3.delete_statutory_situation_a
638: (
639: p_statutory_situation_id => p_statutory_situation_id
640: ,p_object_version_number => l_object_version_number
641: );

Line 699: end PQH_FR_STAT_SITUATIONS_API;

695:
696: end DELETE_STATUTORY_SITUATION;
697: --
698:
699: end PQH_FR_STAT_SITUATIONS_API;