[Home] [Help]
PACKAGE: APPS.IGC_CC_ACCESS_PKG
Source
1 PACKAGE IGC_CC_ACCESS_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGCCACCS.pls 120.3.12000000.1 2007/08/20 12:10:35 mbremkum ship $ */
3
4
5 PROCEDURE Insert_Row
6 (
7 p_api_version IN NUMBER,
8 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
9 p_commit IN VARCHAR2 := FND_API.G_FALSE,
10 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11 x_return_status OUT NOCOPY VARCHAR2,
12 x_msg_count OUT NOCOPY NUMBER,
13 x_msg_data OUT NOCOPY VARCHAR2,
14
15 p_row_id IN OUT NOCOPY VARCHAR2,
16 p_CC_HEADER_ID NUMBER,
17 p_USER_ID NUMBER,
18 p_CC_GROUP_ID NUMBER,
19 p_CC_ACCESS_ID IN OUT NOCOPY NUMBER,
20 p_CC_ACCESS_LEVEL VARCHAR2,
21 p_CC_ACCESS_TYPE VARCHAR2,
22 p_LAST_UPDATE_DATE DATE,
23 p_LAST_UPDATED_BY NUMBER,
24 p_CREATION_DATE DATE,
25 p_CREATED_BY NUMBER,
26 p_LAST_UPDATE_LOGIN NUMBER
27 );
28
29 PROCEDURE Update_Row
30 (
31 p_api_version IN NUMBER,
32 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33 p_commit IN VARCHAR2 := FND_API.G_FALSE,
34 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2,
38
39 p_row_id VARCHAR2,
40 p_CC_HEADER_ID NUMBER,
41 p_USER_ID NUMBER,
42 p_CC_GROUP_ID NUMBER,
43 p_CC_ACCESS_ID NUMBER,
44 p_CC_ACCESS_LEVEL VARCHAR2,
45 p_CC_ACCESS_TYPE VARCHAR2,
46 p_LAST_UPDATE_DATE DATE,
47 p_LAST_UPDATED_BY NUMBER,
48 p_LAST_UPDATE_LOGIN NUMBER
49 );
50
51
52 PROCEDURE Lock_Row
53 (
54 p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
56 p_commit IN VARCHAR2 := FND_API.G_FALSE,
57 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2,
61
62 p_row_id VARCHAR2,
63 p_CC_HEADER_ID NUMBER,
64 p_USER_ID NUMBER,
65 p_CC_GROUP_ID NUMBER,
66 p_CC_ACCESS_ID NUMBER,
67 p_CC_ACCESS_LEVEL VARCHAR2,
68 p_CC_ACCESS_TYPE VARCHAR2,
69 p_row_locked OUT NOCOPY VARCHAR2
70
71 );
72
73
74 PROCEDURE Delete_Row
75 (
76 p_api_version IN NUMBER,
77 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
78 p_commit IN VARCHAR2 := FND_API.G_FALSE,
79 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83
84 p_row_id IN VARCHAR2
85 );
86
87
88 PROCEDURE Check_Unique
89 (
90 p_api_version IN NUMBER,
91 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92 p_commit IN VARCHAR2 := FND_API.G_FALSE,
93 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2,
97
98 p_row_id IN VARCHAR2,
99 p_cc_access_id IN NUMBER,
100 p_return_value IN OUT NOCOPY VARCHAR2
101 );
102
103
104 Function get_access_level
105 (
106 p_header_id IN NUMBER,
107 p_user_id IN NUMBER,
108 p_preparer_id IN NUMBER,
109 p_owner_id IN NUMBER
110 ) RETURN Char;
111
112 pragma RESTRICT_REFERENCES(get_access_level, WNDS, WNPS);
113
114 END IGC_CC_ACCESS_PKG;