[Home] [Help]
PACKAGE: APPS.PER_ORG_STRUCTURE_VERSIONS_PKG
Source
1 PACKAGE PER_ORG_STRUCTURE_VERSIONS_PKG AUTHID CURRENT_USER as
2 /* $Header: peosv01t.pkh 115.2 2002/12/06 16:34:42 pkakar ship $ */
3 ------------------------------------------------------------------------------
4 FUNCTION get_next_free_no(p_Org_Structure_Version_Id NUMBER) return NUMBER;
5 ------------------------------------------------------------------------------
6 PROCEDURE check_date_gaps(p_org_structure_id NUMBER
7 ,p_date_to DATE
8 ,p_date_from DATE
9 ,p_rowid VARCHAR2
10 ,p_gap_warning in out nocopy VARCHAR2);
11 ------------------------------------------------------------------------------
12 PROCEDURE check_version_number(p_org_structure_id NUMBER
13 ,p_version_number NUMBER
14 ,p_rowid VARCHAR2);
15 ------------------------------------------------------------------------------
16 PROCEDURE check_overlap(p_org_structure_id NUMBER
17 ,p_rowid VARCHAR2
18 ,p_date_from DATE
19 ,p_date_to DATE
20 ,p_end_of_time DATE
21 ,p_end_date_closedown in out nocopy VARCHAR2);
22 ------------------------------------------------------------------------------
23 PROCEDURE copy_elements(p_org_structure_Version_id NUMBER
24 ,p_copy_structure_version_id NUMBER);
25 ------------------------------------------------------------------------------
26 PROCEDURE Insert_Row(p_Rowid IN OUT NOCOPY VARCHAR2,
27 p_Org_Structure_Version_Id IN OUT NOCOPY NUMBER,
28 p_Business_Group_Id NUMBER,
29 p_Organization_Structure_Id NUMBER,
30 p_Date_From DATE,
31 p_Version_Number NUMBER,
32 p_Copy_Structure_Version_Id NUMBER,
33 p_Date_To DATE,
34 p_Pos_Ctrl_Enabled_Flag VARCHAR2,
35 p_end_of_time DATE,
36 p_Next_no_free IN OUT NOCOPY NUMBER,
37 p_closedown_warning IN OUT NOCOPY VARCHAR2,
38 p_gap_warning IN OUT NOCOPY VARCHAR2
39 );
40 ------------------------------------------------------------------------------
41 --
42 PROCEDURE Lock_Row(p_Rowid VARCHAR2,
43 p_Org_Structure_Version_Id NUMBER,
44 p_Business_Group_Id NUMBER,
45 p_Organization_Structure_Id NUMBER,
46 p_Date_From DATE,
47 p_Version_Number NUMBER,
48 p_Copy_Structure_Version_Id NUMBER,
49 p_Date_To DATE,
50 p_Pos_Ctrl_Enabled_Flag VARCHAR2
51 );
52 ------------------------------------------------------------------------------
53 --
54 PROCEDURE Update_Row(p_Rowid VARCHAR2,
55 p_Org_Structure_Version_Id NUMBER,
56 p_Business_Group_Id NUMBER,
57 p_Organization_Structure_Id NUMBER,
58 p_Date_From DATE,
59 p_Version_Number NUMBER,
60 p_Copy_Structure_Version_Id NUMBER,
61 p_Date_To DATE,
62 p_Pos_Ctrl_Enabled_Flag VARCHAR2,
63 p_end_of_time DATE,
64 p_Next_no_free IN OUT NOCOPY NUMBER,
65 p_closedown_warning IN OUT NOCOPY VARCHAR2,
66 p_gap_warning IN OUT NOCOPY VARCHAR2
67 );
68 ------------------------------------------------------------------------------
69 PROCEDURE pre_delete_checks(p_org_Structure_Version_Id NUMBER,
70 p_Pa_Installed VARCHAR2);
71 ------------------------------------------------------------------------------
72 PROCEDURE update_copied_versions(p_org_Structure_Version_Id NUMBER);
73 ------------------------------------------------------------------------------
74 PROCEDURE Delete_Row(p_Rowid VARCHAR2,
75 p_Organization_Structure_Id NUMBER,
76 p_org_Structure_Version_Id NUMBER,
77 p_Pa_Installed VARCHAR2,
78 p_Date_From DATE,
79 p_Date_To DATE,
80 p_gap_warning IN OUT NOCOPY VARCHAR2,
81 p_Next_no_free IN OUT NOCOPY NUMBER);
82 ------------------------------------------------------------------------------
83 END PER_ORG_STRUCTURE_VERSIONS_PKG;