1 Package CSP_REQ_LINE_DETAILS_PVT AUTHID CURRENT_USER AS
2 /* $Header: cspvrlds.pls 115.1 2003/12/16 20:13:49 phegde noship $ */
3 -- Start of Comments
4 -- Package name : CSP_Req_Line_Details_PVT
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:Req_Line_Details_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- REQ_LINE_DETAIL_ID
19 -- REQUIREMENT_LINE_ID
20 -- CREATED_BY
21 -- CREATION_DATE
22 -- LAST_UPDATED_BY
23 -- LAST_UPDATE_DATE
24 -- LAST_UPDATE_LOGIN
25 -- SOURCE_TYPE
26 -- SOURCE_ID
27 --
28 -- Required:
29 -- Defaults:
30 -- Note: This is automatic generated record definition, it includes all columns
31 -- defined in the table, developer must manually add or delete some of the attributes.
32 --
33 -- End of Comments
34
35 TYPE Req_Line_Details_Rec_Type IS RECORD
36 (
37 REQ_LINE_DETAIL_ID NUMBER ,
38 REQUIREMENT_LINE_ID NUMBER ,
39 CREATED_BY NUMBER ,
40 CREATION_DATE DATE ,
41 LAST_UPDATED_BY NUMBER ,
42 LAST_UPDATE_DATE DATE ,
43 LAST_UPDATE_LOGIN NUMBER ,
44 SOURCE_TYPE VARCHAR2(30) ,
45 SOURCE_ID NUMBER
46 );
47
48 G_MISS_Req_Line_Details_REC Req_Line_Details_Rec_Type;
49 TYPE Req_Line_Details_Tbl_Type IS TABLE OF Req_Line_Details_Rec_Type
50 INDEX BY BINARY_INTEGER;
51 G_MISS_Req_Line_Details_TBL Req_Line_Details_Tbl_Type;
52
53 -- *******************************************************
54 -- Start of Comments
55 -- *******************************************************
56 -- API Name: Create_req_line_details
57 -- Type : Private
58 -- Pre-Req :
59 -- Parameters:
60 -- IN
61 -- p_api_version_number IN NUMBER Required
62 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
63 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
64 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
65 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
66 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
67 -- p_admin_group_id IN NUMBER Required
68 -- P_Req_Line_Details_Rec IN Req_Line_Details_Rec_Type Required
69 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
70 --
71 -- OUT:
72 -- x_return_status OUT NOCOPY VARCHAR2
73 -- x_msg_count OUT NOCOPY NUMBER
74 -- x_msg_data OUT NOCOPY VARCHAR2
75 -- Version : Current version 2.0
76 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
77 -- and basic operation, developer must manually add parameters and business logic as necessary.
78 --
79 -- End of Comments
80 --
81 PROCEDURE Create_req_line_details(
82 P_Api_Version_Number IN NUMBER,
83 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
84 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
85 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86 P_Req_Line_Details_Tbl IN Req_Line_Details_Tbl_Type := G_MISS_Req_Line_Details_Tbl,
87 x_Req_Line_Details_tbl OUT NOCOPY Req_Line_Details_Tbl_Type,
88 X_Return_Status OUT NOCOPY VARCHAR2,
89 X_Msg_Count OUT NOCOPY NUMBER,
90 X_Msg_Data OUT NOCOPY VARCHAR2
91 );
92
93 -- *******************************************************
94 -- Start of Comments
95 -- *******************************************************
96 -- API Name: Update_req_line_details
97 -- Type : Private
98 -- Pre-Req :
99 -- Parameters:
100 -- IN
101 -- p_api_version_number IN NUMBER Required
102 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
103 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
104 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
105 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
106 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
107 -- p_admin_group_id IN NUMBER Required
108 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
109 -- P_Req_Line_Details_Rec IN Req_Line_Details_Rec_Type Required
110 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
111 --
112 -- OUT:
113 -- x_return_status OUT NOCOPY VARCHAR2
114 -- x_msg_count OUT NOCOPY NUMBER
115 -- x_msg_data OUT NOCOPY VARCHAR2
116 -- Version : Current version 2.0
117 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
118 -- and basic operation, developer must manually add parameters and business logic as necessary.
119 --
120 -- End of Comments
121 --
122 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
123 PROCEDURE Update_req_line_details(
124 P_Api_Version_Number IN NUMBER,
125 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
126 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
127 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
128 P_Req_Line_Details_Tbl IN Req_Line_Details_Tbl_Type,
129 X_Return_Status OUT NOCOPY VARCHAR2,
130 X_Msg_Count OUT NOCOPY NUMBER,
131 X_Msg_Data OUT NOCOPY VARCHAR2
132 );
133
134 -- *******************************************************
135 -- Start of Comments
136 -- *******************************************************
137 -- API Name: Delete_req_line_details
138 -- Type : Private
139 -- Pre-Req :
140 -- Parameters:
141 -- IN
142 -- p_api_version_number IN NUMBER Required
143 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
146 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
147 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
148 -- p_admin_group_id IN NUMBER Required
149 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
150 -- P_Req_Line_Details_Rec IN Requirement_Line_details_Rec_Type Required
151 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
152 --
153 -- OUT:
154 -- x_return_status OUT NOCOPY VARCHAR2
155 -- x_msg_count OUT NOCOPY NUMBER
156 -- x_msg_data OUT NOCOPY VARCHAR2
157 -- Version : Current version 2.0
158 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
159 -- and basic operation, developer must manually add parameters and business logic as necessary.
160 --
161 -- End of Comments
162 --
163 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
164 -- The Master delete procedure may not be needed depends on different business requirements.
165 PROCEDURE Delete_req_line_details(
166 P_Api_Version_Number IN NUMBER,
167 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
168 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
169 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
170 P_Req_Line_Details_Tbl IN Req_Line_Details_Tbl_Type,
171 X_Return_Status OUT NOCOPY VARCHAR2,
172 X_Msg_Count OUT NOCOPY NUMBER,
173 X_Msg_Data OUT NOCOPY VARCHAR2
174 );
175
176 End CSP_Req_Line_Details_PVT;