[Home] [Help]
PACKAGE: APPS.JTF_BRMPARAMETER_PVT
Source
1 PACKAGE JTF_BRMParameter_PVT AS
2 /* $Header: jtfvbps.pls 120.2 2005/07/05 07:44:44 abraina ship $ */
3
4 TYPE BRM_Parameter_rec_type IS RECORD
5 ( PARAMETER_ID NUMBER
6 , CREATED_BY NUMBER(15)
7 , CREATION_DATE DATE
8 , LAST_UPDATED_BY NUMBER(15)
9 , LAST_UPDATE_DATE DATE
10 , LAST_UPDATE_LOGIN NUMBER(15)
11 , BRM_UOM_TYPE VARCHAR2(30)
12 , BRM_UOM_CODE VARCHAR2(30)
13 , BRM_INTERVAL NUMBER(9)
14 , BRM_WF_COMMAND_TYPE VARCHAR2(30)
15 , BRM_WF_COMMAND_CODE VARCHAR2(30)
16 , WORKFLOW_PROCESS_ID NUMBER
17 , WORKFLOW_ITEM_TYPE VARCHAR2(8)
18 , WORKFLOW_PROCESS_NAME VARCHAR2(30)
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_BRMParameter
43 -- Type : Private
44 -- Function : Create record in JTF_BRM_PARAMETER 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_BRMParameter_rec IN brm_parameter_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_BRMParameter
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_bp_rec IN BRM_Parameter_rec_type
74 , x_record_id OUT NOCOPY NUMBER
75 );
76
77 --------------------------------------------------------------------------
78 -- Start of comments
79 -- API name : Update_BRMParameter
80 -- Type : Private
81 -- Function : Update record in JTF_BRM_PARAMETERS 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_BRMParameter_rec IN brm_parameter_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_BRMParameter
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_bp_rec IN BRM_Parameter_rec_type
112 );
113
114
115 --------------------------------------------------------------------------
116 -- Start of comments
117 -- API Name : Delete_BRMParameter
118 -- Type : Private
119 -- Description : Delete record in JTF_BRM_PARAMETERS table.
120 -- Pre-reqs : None
121 -- Parameters :
122 -- name direction type required?
123 -- ---- --------- ---- ---------
124 -- p_api_version IN NUMBER required
125 -- p_init_msg_list IN VARCHAR2 optional
126 -- p_commit IN VARCHAR2 optional
127 -- p_validation_level IN NUMBER optional
128 -- x_return_status OUT VARCHAR2 required
129 -- x_msg_count OUT NUMBER required
130 -- x_msg_data OUT VARCHAR2 required
131 -- p_parameter_id IN NUMBER required
132 --
133 -- Version : Current version 1.1
134 -- Previous version 1.0
135 -- Initial version 1.0
136 --
137 -- Notes: :
138 --
139 -- End of comments
140 --------------------------------------------------------------------------
141 PROCEDURE Delete_BRMParameter
142 ( p_api_version IN NUMBER
143 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
144 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
145 , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
146 , x_return_status OUT NOCOPY VARCHAR2
147 , x_msg_count OUT NOCOPY NUMBER
148 , x_msg_data OUT NOCOPY VARCHAR2
149 , p_parameter_id IN NUMBER
150 );
151
152 END JTF_BRMParameter_PVT;