[Home] [Help]
PACKAGE: APPS.JTF_BRMWFATTRVALUE_PVT
Source
1 PACKAGE JTF_BRMWFAttrValue_PVT AS
2 /* $Header: jtfvbwas.pls 120.2 2005/07/05 07:45:15 abraina ship $ */
3
4 TYPE brm_wf_attr_value_rec_type IS RECORD
5 ( WF_ATTR_VALUE_ID NUMBER
6 , PROCESS_ID NUMBER(38)
7 , WF_ITEM_TYPE VARCHAR2(8)
8 , WF_ACTIVITY_NAME VARCHAR2(30)
9 , WF_ACTIVITY_VERSION VARCHAR2(9)
10 , WF_ACTIVITY_ATTRIBUTE_NAME VARCHAR2(30)
11 , CREATED_BY NUMBER(15)
12 , CREATION_DATE DATE
13 , LAST_UPDATED_BY NUMBER(15)
14 , LAST_UPDATE_DATE DATE
15 , LAST_UPDATE_LOGIN NUMBER(15)
16 , TEXT_VALUE VARCHAR2(4000)
17 , NUMBER_VALUE NUMBER(15)
18 , DATE_VALUE DATE
19 , ATTRIBUTE1 VARCHAR2(150)
20 , ATTRIBUTE2 VARCHAR2(150)
21 , ATTRIBUTE3 VARCHAR2(150)
22 , ATTRIBUTE4 VARCHAR2(150)
23 , ATTRIBUTE5 VARCHAR2(150)
24 , ATTRIBUTE6 VARCHAR2(150)
25 , ATTRIBUTE7 VARCHAR2(150)
26 , ATTRIBUTE8 VARCHAR2(150)
27 , ATTRIBUTE9 VARCHAR2(150)
28 , ATTRIBUTE10 VARCHAR2(150)
29 , ATTRIBUTE11 VARCHAR2(150)
30 , ATTRIBUTE12 VARCHAR2(150)
31 , ATTRIBUTE13 VARCHAR2(150)
32 , ATTRIBUTE14 VARCHAR2(150)
33 , ATTRIBUTE15 VARCHAR2(150)
34 , ATTRIBUTE_CATEGORY VARCHAR2(30)
35 , SECURITY_GROUP_ID NUMBER
36 , OBJECT_VERSION_NUMBER NUMBER
37 , APPLICATION_ID NUMBER
38 );
39
40 --------------------------------------------------------------------------
41 -- Start of comments
42 -- API name : Create_WFAttrValue
43 -- Type : Private
44 -- Function : Create record in JTF_BRM_WF_ATTR_VALUES table.
45 -- Pre-reqs : None.
46 -- Parameters :
47 -- name direction type required?
48 -- ---- --------- ---- ---------
49 -- p_api_version IN NUMBER required
50 -- p_init_msg_list IN VARCHAR2 optional
51 -- p_commit IN VARCHAR2 optional
52 -- p_validation_level IN NUMBER optional
53 -- x_return_status OUT VARCHAR2 required
54 -- x_msg_count OUT NUMBER required
55 -- x_msg_data OUT VARCHAR2 required
56 -- p_bwa_rec IN brm_wf_attr_value_rec_type required
57 -- x_record_id OUT NUMBER required
58 --
59 -- Version : Current version 1.1
60 -- Previous version 1.0
61 -- Initial version 1.0
62 --
63 -- End of comments
64 --------------------------------------------------------------------------
65 PROCEDURE Create_WFAttrValue
66 ( p_api_version IN NUMBER
67 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
68 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
69 , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
70 , x_return_status OUT NOCOPY VARCHAR2
71 , x_msg_count OUT NOCOPY NUMBER
72 , x_msg_data OUT NOCOPY VARCHAR2
73 , p_bwa_rec IN brm_wf_attr_value_rec_type
74 , x_record_id OUT NOCOPY NUMBER
75 );
76
77 --------------------------------------------------------------------------
78 -- Start of comments
79 -- API name : Update_WFAttrValue
80 -- Type : Private
81 -- Function : Update record in JTF_BRM_WF_ATTR_VALUES table.
82 -- Pre-reqs : None.
83 -- Parameters :
84 -- name direction type required?
85 -- ---- --------- ---- ---------
86 -- p_api_version IN NUMBER required
87 -- p_init_msg_list IN VARCHAR2 optional
88 -- p_commit IN VARCHAR2 optional
89 -- p_validation_level IN NUMBER optional
90 -- x_return_status OUT VARCHAR2 required
91 -- x_msg_count OUT NUMBER required
92 -- x_msg_data OUT VARCHAR2 required
93 -- p_bel_rec IN brm_wf_attr_value_rec_type required
94 --
95 -- Version : Current version 1.1
96 -- Previous version 1.0
97 -- Initial Version 1.0
98 --
99 -- Notes:
100 --
101 -- End of comments
102 --------------------------------------------------------------------------
103 PROCEDURE Update_WFAttrValue
104 ( p_api_version IN NUMBER
105 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
106 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
107 , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
108 , x_return_status OUT NOCOPY VARCHAR2
109 , x_msg_count OUT NOCOPY NUMBER
110 , x_msg_data OUT NOCOPY VARCHAR2
111 , p_bwa_rec IN brm_wf_attr_value_rec_type
112 );
113
114 --------------------------------------------------------------------------
115 -- Start of comments
116 -- API Name : Delete_WFAttrValue
117 -- Type : Private
118 -- Description : Delete record in JTF_BRM_WF_ATTR_VALUES table.
119 -- Pre-reqs : None
120 -- Parameters :
121 -- name direction type required?
122 -- ---- --------- ---- ---------
123 -- p_api_version IN NUMBER required
124 -- p_init_msg_list IN VARCHAR2 optional
125 -- p_commit IN VARCHAR2 optional
126 -- p_validation_level IN NUMBER optional
127 -- x_return_status OUT VARCHAR2 required
128 -- x_msg_count OUT NUMBER required
129 -- x_msg_data OUT VARCHAR2 required
130 -- p_wf_attr_value_id IN NUMBER required
131 --
132 -- Version : Current version 1.1
133 -- Previous version 1.0
134 -- Initial version 1.0
135 --
136 -- Notes: :
137 --
138 -- End of comments
139 --------------------------------------------------------------------------
140 PROCEDURE Delete_WFAttrValue
141 ( p_api_version IN NUMBER
142 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
143 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
144 , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
145 , x_return_status OUT NOCOPY VARCHAR2
146 , x_msg_count OUT NOCOPY NUMBER
147 , x_msg_data OUT NOCOPY VARCHAR2
148 , p_wf_attr_value_id IN NUMBER
149 );
150
151
152 END JTF_BRMWFAttrValue_PVT;