[Home] [Help]
PACKAGE: APPS.CSP_REQUIREMENT_HEADERS_PUB
Source
1 PACKAGE CSP_REQUIREMENT_HEADERS_PUB AUTHID CURRENT_USER AS
2 /* $Header: cspprqhs.pls 120.0.12010000.1 2010/03/17 16:45:05 htank noship $ */
3 -- Start of Comments
4 -- Package name : CSP_Requirement_Headers_PUB
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12 -- *******************************************************
13 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name:RQ_Rec_Type
16 -- -------------------------------------------------------
17 -- Required:
18 -- Defaults:
19 -- Note: This is automatic generated record definition, it includes all columns
20 -- defined in the table, developer must manually add or delete some of the attributes.
21 --
22 -- End of Comments
23
24 TYPE RQH_Rec_Type IS RECORD
25 (
26 ROW_ID ROWID := FND_API.G_MISS_CHAR,
27 REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
28 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29 CREATION_DATE DATE := FND_API.G_MISS_DATE,
30 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
32 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
33 OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
34 ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
35 SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
36 TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
37 TASK_ID NUMBER := FND_API.G_MISS_NUM,
38 TASK_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
39 TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
40 RESOURCE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
41 RESOURCE_TYPE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
42 RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
43 RESOURCE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
44 SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
45 NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
46 DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
47 DESTINATION_ORGANIZATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
48 ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
49 ORDER_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
50 PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
51 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
52 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67 SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
68 DESTINATION_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR
69 );
70
71 G_MISS_RQH_REC RQH_Rec_Type;
72 TYPE RQH_Tbl_Type IS TABLE OF RQH_Rec_Type
73 INDEX BY BINARY_INTEGER;
74 G_MISS_RQH_TBL RQH_Tbl_Type;
75
76 TYPE RQH_sort_rec_type IS RECORD
77 (
78 -- Please define your own sort by record here.
79 REQUIREMENT_HEADER_ID NUMBER := NULL
80 );
81
82 -- *******************************************************
83 -- Start of Comments
84 -- *******************************************************
85 -- API Name: Create_requirement_headers
86 -- Type : Public
87 -- Pre-Req :
88 -- Parameters:
89 -- IN
90 -- p_api_version_number IN NUMBER Required
91 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
92 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
93 -- P_RQH_Rec IN RQH_Rec_Type Required
94 --
95 -- OUT:
96 -- x_return_status OUT NOCOPY VARCHAR2
97 -- x_msg_count OUT NOCOPY NUMBER
98 -- x_msg_data OUT NOCOPY VARCHAR2
99 -- Version : Current version 2.0
100 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
101 -- and basic operation, developer must manually add parameters and business logic as necessary.
102 --
103 -- End of Comments
104 --
105 PROCEDURE Create_requirement_headers(
106 P_Api_Version_Number IN NUMBER,
107 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
108 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
109 P_RQH_Rec IN RQH_Rec_Type := G_MISS_RQH_REC,
110 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
111 X_REQUIREMENT_HEADER_ID OUT NOCOPY NUMBER,
112 X_Return_Status OUT NOCOPY VARCHAR2,
113 X_Msg_Count OUT NOCOPY NUMBER,
114 X_Msg_Data OUT NOCOPY VARCHAR2
115 );
116
117 -- *******************************************************
118 -- Start of Comments
119 -- *******************************************************
120 -- API Name: Update_requirement_headers
121 -- Type : Public
122 -- Pre-Req :
123 -- Parameters:
124 -- IN
125 -- p_api_version_number IN NUMBER Required
126 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
127 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
128 -- P_RQH_Rec IN RQH_Rec_Type Required
129 --
130 -- OUT:
131 -- x_return_status OUT NOCOPY VARCHAR2
132 -- x_msg_count OUT NOCOPY NUMBER
133 -- x_msg_data OUT NOCOPY VARCHAR2
134 -- Version : Current version 2.0
135 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
136 -- and basic operation, developer must manually add parameters and business logic as necessary.
137 --
138 -- End of Comments
139 --
140 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
141 PROCEDURE Update_requirement_headers(
142 P_Api_Version_Number IN NUMBER,
143 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
144 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
145 P_RQH_Rec IN RQH_Rec_Type := G_MISS_RQH_REC,
146 X_Return_Status OUT NOCOPY VARCHAR2,
147 X_Msg_Count OUT NOCOPY NUMBER,
148 X_Msg_Data OUT NOCOPY VARCHAR2
149 );
150
151 -- *******************************************************
152 -- Start of Comments
153 -- *******************************************************
154 -- API Name: Delete_requirement_headers
155 -- Type : Public
156 -- Pre-Req :
157 -- Parameters:
158 -- IN
159 -- p_api_version_number IN NUMBER Required
160 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
161 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
162 -- P_RQH_Rec IN RQH_Rec_Type Required
163 --
164 -- OUT:
165 -- x_return_status OUT NOCOPY VARCHAR2
166 -- x_msg_count OUT NOCOPY NUMBER
167 -- x_msg_data OUT NOCOPY VARCHAR2
168 -- Version : Current version 2.0
169 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
170 -- and basic operation, developer must manually add parameters and business logic as necessary.
171 --
172 -- End of Comments
173 --
174 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
175 -- The Master delete procedure may not be needed depends on different business requirements.
176 PROCEDURE Delete_requirement_headers(
177 P_Api_Version_Number IN NUMBER,
178 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
179 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
180 P_RQH_Rec IN RQH_Rec_Type,
181 X_Return_Status OUT NOCOPY VARCHAR2,
182 X_Msg_Count OUT NOCOPY NUMBER,
183 X_Msg_Data OUT NOCOPY VARCHAR2
184 );
185
186 END CSP_REQUIREMENT_HEADERS_PUB; -- Package spec