[Home] [Help]
PACKAGE: APPS.PER_POS_STRUCTURE_VERSIONS_PKG
Source
1 PACKAGE PER_POS_STRUCTURE_VERSIONS_PKG AUTHID CURRENT_USER as
2 /* $Header: pepsv01t.pkh 115.1 2003/02/11 11:54:54 eumenyio ship $ */
3
4 ------------------------------------------------------------------------------
5 FUNCTION get_next_free_no(X_Position_Structure_Id NUMBER) return NUMBER;
6 ------------------------------------------------------------------------------
7 PROCEDURE check_version_number(X_Position_Structure_Id NUMBER
8 ,X_Version_Number NUMBER
9 ,X_Rowid VARCHAR2);
10 ------------------------------------------------------------------------------
11 PROCEDURE check_date_gap(X_Date_From DATE,
12 X_Date_To DATE ,
13 X_Position_Structure_Id NUMBER,
14 X_gap_warning IN OUT NOCOPY VARCHAR2,
15 X_Rowid VARCHAR2);
16 ------------------------------------------------------------------------------
17 PROCEDURE check_overlap(X_Position_Structure_Id NUMBER
18 ,X_Rowid VARCHAR2
19 ,X_Date_From DATE
20 ,X_Date_To DATE
21 ,X_End_Of_Time DATE
22 ,X_End_Date_Closedown IN OUT NOCOPY VARCHAR2);
23 ------------------------------------------------------------------------------
24 PROCEDURE copy_elements(X_Pos_Structure_Version_Id NUMBER
25 ,X_Copy_Structure_Version_Id NUMBER);
26 ------------------------------------------------------------------------------
27 PROCEDURE pre_delete_checks(X_Pos_Structure_Version_Id NUMBER,
28 X_Business_Group_Id NUMBER,
29 X_Position_Structure_Id NUMBER,
30 X_Hr_Installed VARCHAR2);
31 ------------------------------------------------------------------------------
32 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
33 X_Pos_Structure_Version_Id IN OUT NOCOPY NUMBER,
34 X_Business_Group_Id NUMBER,
35 X_Position_Structure_Id NUMBER,
36 X_Date_From DATE,
37 X_Version_Number NUMBER,
38 X_Copy_Structure_Version_Id NUMBER ,
39 X_Date_To DATE ,
40 X_end_of_time DATE,
41 X_Next_no_free IN OUT NOCOPY NUMBER,
42 X_closedown_warning IN OUT NOCOPY VARCHAR2,
43 X_gap_warning IN OUT NOCOPY VARCHAR2
44 );
45 ------------------------------------------------------------------------------
46 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
47 X_Pos_Structure_Version_Id NUMBER,
48 X_Business_Group_Id NUMBER,
49 X_Position_Structure_Id NUMBER,
50 X_Date_From DATE,
51 X_Version_Number NUMBER,
52 X_Copy_Structure_Version_Id NUMBER ,
53 X_Date_To DATE
54 );
55 ------------------------------------------------------------------------------
56 PROCEDURE Update_Row(X_Rowid VARCHAR2,
57 X_Pos_Structure_Version_Id NUMBER,
58 X_Business_Group_Id NUMBER,
59 X_Position_Structure_Id NUMBER,
60 X_Date_From DATE,
61 X_Version_Number NUMBER,
62 X_Copy_Structure_Version_Id NUMBER ,
63 X_Date_To DATE ,
64 X_end_of_time DATE,
65 X_Next_no_free IN OUT NOCOPY NUMBER,
66 X_closedown_warning IN OUT NOCOPY VARCHAR2,
67 X_gap_warning IN OUT NOCOPY VARCHAR2
68 );
69 ------------------------------------------------------------------------------
70 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
71 X_Pos_Structure_Version_Id NUMBER,
72 X_Business_Group_Id NUMBER,
73 X_Position_Structure_Id NUMBER,
74 X_Hr_Installed VARCHAR2,
75 X_Next_no_free IN OUT NOCOPY NUMBER,
76 X_closedown_warning IN OUT NOCOPY VARCHAR2);
77 ------------------------------------------------------------------------------
78 END PER_POS_STRUCTURE_VERSIONS_PKG;