[Home] [Help]
PACKAGE: APPS.EAM_DEPT_APPROVERS_PVT
Source
1 PACKAGE EAM_DEPT_APPROVERS_PVT AUTHID CURRENT_USER as
2 /* $Header: EAMVDAPS.pls 115.5 2003/08/19 06:49:47 yjhabak ship $ */
3 -- Start of comments
4 -- API name : EAM_DEPT_APPROVERS_PVT
5 -- Type : Private
6 -- Function :
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- IN P_API_VERSION IN NUMBER REQUIRED
10 -- P_INIT_MSG_LIST IN VARCHAR2 OPTIONAL
11 -- DEFAULT = FND_API.G_FALSE
12 -- P_COMMIT IN VARCHAR2 OPTIONAL
13 -- DEFAULT = FND_API.G_FALSE
14 -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
15 -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
16 -- P_DEPT_ID IN NUMBER REQUIRED
17 -- P_LAST_UPDATE_DATE IN DATE REQUIRED
18 -- P_LAST_UPDATED_BY IN NUMBER REQUIRED
19 -- P_CREATION_DATE IN DATE REQUIRED
20 -- P_CREATED_BY IN NUMBER REQUIRED
21 -- P_LAST_UPDATE_LOGIN IN NUMBER OPTIONAL
22 -- P_RESPONSIBILITY_ID IN NUMBER REQUIRED
23 -- P_RESPONSIBILITY_APPLICATN_ID IN NUMBER REQUIRED
24
25 -- OUT X_RETURN_STATUS OUT VARCHAR2(1)
26 -- X_MSG_COUNT OUT NUMBER
27 -- X_MSG_DATA OUT VARCHAR2(2000)
28 --
29 -- Version Current version 115.0
30 --
31 -- Notes : Note text
32 --
33 -- End of comments
34
35
36 PROCEDURE INSERT_ROW(
37 P_API_VERSION IN NUMBER,
38 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
39 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
40 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41 P_ROWID IN OUT NOCOPY VARCHAR2,
42 P_DEPT_ID NUMBER,
43 P_ORGANIZATION_ID NUMBER,
44 P_LAST_UPDATE_DATE DATE,
45 P_LAST_UPDATED_BY NUMBER,
46 P_CREATION_DATE DATE,
47 P_CREATED_BY NUMBER,
48 P_LAST_UPDATE_LOGIN NUMBER,
49 P_RESPONSIBILITY_ID NUMBER,
50 P_RESPONSIBILITY_APPLICATN_ID NUMBER,
51 P_PRIMARY_APPROVER NUMBER,
52 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
53 X_MSG_COUNT OUT NOCOPY NUMBER,
54 X_MSG_DATA OUT NOCOPY VARCHAR2);
55
56 PROCEDURE LOCK_ROW(
57 P_API_VERSION IN NUMBER,
58 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
59 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
60 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61 P_ROWID IN OUT NOCOPY VARCHAR2,
62 P_DEPT_ID NUMBER,
63 P_ORGANIZATION_ID NUMBER,
64 P_LAST_UPDATE_DATE DATE,
65 P_LAST_UPDATED_BY NUMBER,
66 P_CREATION_DATE DATE,
67 P_CREATED_BY NUMBER,
68 P_LAST_UPDATE_LOGIN NUMBER,
69 P_RESPONSIBILITY_ID NUMBER,
70 P_RESPONSIBILITY_APPLICATN_ID NUMBER,
71 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
72 X_MSG_COUNT OUT NOCOPY NUMBER,
73 X_MSG_DATA OUT NOCOPY VARCHAR2);
74
75 PROCEDURE UPDATE_ROW(
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 P_ROWID IN OUT NOCOPY VARCHAR2,
81 P_DEPT_ID NUMBER,
82 P_ORGANIZATION_ID NUMBER,
83 P_LAST_UPDATE_DATE DATE,
84 P_LAST_UPDATED_BY NUMBER,
85 P_CREATION_DATE DATE,
86 P_CREATED_BY NUMBER,
87 P_LAST_UPDATE_LOGIN NUMBER,
88 P_RESPONSIBILITY_ID NUMBER,
89 P_RESPONSIBILITY_APPLICATN_ID NUMBER,
90 P_PRIMARY_APPROVER NUMBER,
91 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
92 X_MSG_COUNT OUT NOCOPY NUMBER,
93 X_MSG_DATA OUT NOCOPY VARCHAR2);
94
95 PROCEDURE DELETE_ROW(
96 P_DEPT_ID NUMBER,
97 P_ORGANIZATION_ID NUMBER,
98 P_RESPONSIBILITY_ID NUMBER,
99 P_RESPONSIBILITY_APPLICATN_ID NUMBER
100 );
101
102 END EAM_DEPT_APPROVERS_PVT;