[Home] [Help]
PACKAGE: APPS.EAM_ATTR_ASSIGN_PVT
Source
1 PACKAGE EAM_ATTR_ASSIGN_PVT AUTHID CURRENT_USER as
2 /* $Header: EAMVATAS.pls 115.5 2003/10/23 23:27:16 sraval ship $ */
3 -- Start of comments
4 -- API name : EAM_ATTR_ASSIGN_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_ROWID IN OUT VARCHAR2 REQUIRED
17 -- P_ATTRIBUTE_ASSOCIATION_ID IN NUMBER REQUIRED
18 -- P_APPLICATION_ID IN NUMBER REQUIRED
19 -- P_FLEXFIELD_NAME IN VARCHAR2(40) REQUIRED
20 -- P_FLEX_CONTEXT_CODE IN VARCHAR2(30) REQUIRED
21 -- P_ORGANIZATION_ID IN NUMBER REQUIRED
22 -- P_INVENTORY_ITEM_ID IN NUMBER REQUIRED
23 -- P_ENABLED_FLAG IN VARCHAR2(1) REQUIRED
24 -- P_LAST_UPDATE_DATE IN DATE REQUIRED
25 -- P_LAST_UPDATED_BY IN NUMBER REQUIRED
26 -- P_CREATION_DATE IN DATE REQUIRED
27 -- P_CREATED_BY IN NUMBER REQUIRED
28 -- P_LAST_UPDATE_LOGIN IN NUMBER REQUIRED
29 -- P_REQUEST_ID IN NUMBER DEFAULT NULL OPTIONAL
30 -- P_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT NULL OPTIONAL
31 -- P_PROGRAM_ID IN NUMBER DEFAULT NULL OPTIONAL
32 -- P_PROGRAM_UPDATE_DATE IN DATE DEFAULT NULL
33 -- OUT X_RETURN_STATUS OUT VARCHAR2(1)
34 -- X_MSG_COUNT OUT NUMBER
35 -- X_MSG_DATA OUT VARCHAR2(2000)
36 --
37 -- Version Current version 115.0
38 --
39 -- Notes : Note text
40 --
41 -- End of comments
42
43
44 PROCEDURE INSERT_ROW(
45 P_API_VERSION IN NUMBER,
46 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
47 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
48 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49 P_ROWID IN OUT NOCOPY VARCHAR2,
50 P_ATTRIBUTE_ASSOCIATION_ID IN OUT NOCOPY NUMBER,
51 P_APPLICATION_ID NUMBER,
52 P_FLEXFIELD_NAME VARCHAR2,
53 P_FLEX_CONTEXT_CODE VARCHAR2,
54 P_ORGANIZATION_ID NUMBER,
55 P_INVENTORY_ITEM_ID NUMBER,
56 P_ENABLED_FLAG VARCHAR2,
57 P_LAST_UPDATE_DATE DATE,
58 P_LAST_UPDATED_BY NUMBER,
59 P_CREATION_DATE DATE,
60 P_CREATED_BY NUMBER,
61 P_LAST_UPDATE_LOGIN NUMBER,
62 P_CREATION_ORGANIZATION_ID NUMBER,
63 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
64 X_MSG_COUNT OUT NOCOPY NUMBER,
65 X_MSG_DATA OUT NOCOPY VARCHAR2);
66
67
68
69 PROCEDURE LOCK_ROW(
70 P_API_VERSION IN NUMBER,
71 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
72 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
73 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
74 P_ROWID VARCHAR2,
75 P_ATTRIBUTE_ASSOCIATION_ID IN OUT NOCOPY NUMBER,
76 P_APPLICATION_ID NUMBER,
77 P_FLEXFIELD_NAME VARCHAR2,
78 P_FLEX_CONTEXT_CODE VARCHAR2,
79 P_ORGANIZATION_ID NUMBER,
80 P_INVENTORY_ITEM_ID NUMBER,
81 P_ENABLED_FLAG VARCHAR2,
82 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
83 X_MSG_COUNT OUT NOCOPY NUMBER,
84 X_MSG_DATA OUT NOCOPY VARCHAR2);
85
86
87 PROCEDURE UPDATE_ROW(
88 P_API_VERSION IN NUMBER,
89 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
90 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
91 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92 P_ROWID VARCHAR2,
93 P_ENABLED_FLAG VARCHAR2,
94 P_LAST_UPDATE_DATE DATE,
95 P_LAST_UPDATED_BY NUMBER,
96 P_LAST_UPDATE_LOGIN NUMBER,
97 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
98 X_MSG_COUNT OUT NOCOPY NUMBER,
99 X_MSG_DATA OUT NOCOPY VARCHAR2);
100
101
102 END EAM_ATTR_ASSIGN_PVT;