[Home] [Help]
PACKAGE: APPS.PER_ORG_STRUCTURE_ELEMENTS_PKG
Source
1 PACKAGE PER_ORG_STRUCTURE_ELEMENTS_PKG as
2 /* $Header: peose01t.pkh 120.0.12000000.2 2007/03/07 10:56:52 asgugupt ship $ */
3 ------------------------------------------------------------------------------
4 FUNCTION get_subordinates(p_view_all_orgs VARCHAR2
5 ,p_org_id_parent NUMBER
6 ,p_org_structure_version_id NUMBER
7 ,p_security_profile_id NUMBER) return NUMBER;
8 ------------------------------------------------------------------------------
9 PROCEDURE maintain_org_lists(p_business_group_id NUMBER
10 ,p_security_profile_id NUMBER
11 ,p_organization_id NUMBER);
12 ------------------------------------------------------------------------------
13 PROCEDURE delete_validation(p_org_structure_version_id NUMBER
14 ,p_org_structure_element_id NUMBER
15 ,p_org_id_child NUMBER
16 ,p_org_id_parent NUMBER
17 ,p_hr_installed VARCHAR2
18 ,p_pa_installed VARCHAR2);
19 ------------------------------------------------------------------------------
20 PROCEDURE perwsdor_delete_check(p_org_structure_version_id NUMBER
21 ,p_org_structure_element_id NUMBER
22 ,p_org_id_child NUMBER
23 ,p_org_id_parent NUMBER
24 ,p_business_group_id NUMBER
25 ,p_hr_installed VARCHAR2
26 ,p_pa_installed VARCHAR2);
27 ------------------------------------------------------------------------------
28 PROCEDURE check_duplicate_entry (p_org_structure_version_id NUMBER
29 ,p_org_structure_element_id NUMBER);
30 ------------------------------------------------------------------------------
31 PROCEDURE check_org_active(p_Org_Id_Parent NUMBER
32 ,p_date_from DATE
33 ,p_end_of_time DATE
34 ,p_warning_raised IN OUT NOCOPY VARCHAR2);
35 -------------------------------------------------------------------------------
36 PROCEDURE check_position_flag (
37 p_org_structure_version_id NUMBER
38 ,p_pos_control_enabled_flag VARCHAR2);
39 ------------------------------------------------------------------------------
40 FUNCTION post_delete_check(p_org_structure_version_id NUMBER
41 ,p_organization_id NUMBER) return BOOLEAN;
42 ------------------------------------------------------------------------------
43 PROCEDURE Insert_Row(p_Rowid IN OUT NOCOPY VARCHAR2,
44 p_Org_Structure_Element_Id IN OUT NOCOPY NUMBER,
45 p_Business_Group_Id NUMBER,
46 p_Organization_Id_Parent NUMBER,
47 p_Org_Structure_Version_Id NUMBER,
48 p_Organization_Id_Child NUMBER,
49 p_date_from DATE,
50 p_security_profile_id NUMBER,
51 p_view_all_orgs VARCHAR2,
52 p_end_of_time DATE,
53 p_pos_control_enabled_flag VARCHAR2
54 );
55 ------------------------------------------------------------------------------
56 PROCEDURE Insert_Row(p_Rowid IN OUT NOCOPY VARCHAR2,
57 p_Org_Structure_Element_Id IN OUT NOCOPY NUMBER,
58 p_Business_Group_Id NUMBER,
59 p_Organization_Id_Parent NUMBER,
60 p_Org_Structure_Version_Id NUMBER,
61 p_Organization_Id_Child NUMBER,
62 p_date_from DATE,
63 p_security_profile_id NUMBER,
64 p_view_all_orgs VARCHAR2,
65 p_end_of_time DATE,
66 p_pos_control_enabled_flag VARCHAR2,
67 p_warning_raised IN OUT NOCOPY VARCHAR2
68 );
69 ------------------------------------------------------------------------------
70 PROCEDURE Lock_Row(p_Rowid VARCHAR2,
71 p_Org_Structure_Element_Id NUMBER,
72 p_Business_Group_Id NUMBER,
73 p_Organization_Id_Parent NUMBER,
74 p_Org_Structure_Version_Id NUMBER,
75 p_Organization_Id_Child NUMBER,
76 p_pos_control_enabled_flag VARCHAR2
77 );
78 ------------------------------------------------------------------------------
79 PROCEDURE Update_Row(p_Rowid VARCHAR2,
80 p_Org_Structure_Element_Id NUMBER,
81 p_Business_Group_Id NUMBER,
82 p_Organization_Id_Parent NUMBER,
83 p_Org_Structure_Version_Id NUMBER,
84 p_Organization_Id_Child NUMBER,
85 p_pos_control_enabled_flag VARCHAR2
86 );
87 ------------------------------------------------------------------------------
88 --bug no 5912009 starts here
89 PROCEDURE Update_Row(p_Rowid VARCHAR2,
90 p_Org_Structure_Element_Id NUMBER,
91 p_Business_Group_Id NUMBER,
92 p_Organization_Id_Parent NUMBER,
93 p_Org_Structure_Version_Id NUMBER,
94 p_Organization_Id_Child NUMBER,
95 p_pos_control_enabled_flag VARCHAR2
96 ,p_pa_installed VARCHAR2
97 );
98 --bug no 5912009 ends here
99 ------------------------------------------------------------------------------
100 PROCEDURE Delete_Row(p_Rowid VARCHAR2
101 ,p_org_structure_version_id NUMBER
102 ,p_org_structure_element_id NUMBER
103 ,p_Organization_Id_Child NUMBER
104 ,p_Organization_Id_Parent NUMBER
105 ,p_hr_installed VARCHAR2
106 ,p_exists_in_hierarchy IN OUT NOCOPY VARCHAR2
107 ,p_pa_installed VARCHAR2);
108 ------------------------------------------------------------------------------
109 END PER_ORG_STRUCTURE_ELEMENTS_PKG;