APPS.CSP_REQ_LINE_DETAILS_PKG dependencies on CSP_REQ_LINE_DETAILS_IUHK

Line 44: csp_req_line_details_iuhk.Create_req_line_detail_Pre

40: l_req_line_details.LAST_UPDATE_LOGIN :=p_LAST_UPDATE_LOGIN ;
41: l_req_line_details.SOURCE_TYPE :=p_SOURCE_TYPE;
42: l_req_line_details.SOURCE_ID :=p_SOURCE_ID;
43:
44: csp_req_line_details_iuhk.Create_req_line_detail_Pre
45: ( x_return_status => l_return_status
46: ) ;
47: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
48: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');

Line 89: csp_req_line_details_iuhk.Create_req_line_detail_Post

85: decode( l_req_line_details.SOURCE_ID, FND_API.G_MISS_NUM, NULL, l_req_line_details.SOURCE_ID)
86: );
87:
88: user_hook_rec.REQUIREMENT_LINE_ID := l_req_line_details.REQUIREMENT_LINE_ID;
89: csp_req_line_details_iuhk.Create_req_line_detail_Post
90: ( x_return_status => l_return_status
91: ) ;
92: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
93: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');

Line 130: csp_req_line_details_iuhk.Update_req_line_detail_Pre

126: l_req_line_details.SOURCE_TYPE :=p_SOURCE_TYPE;
127: l_req_line_details.SOURCE_ID :=p_SOURCE_ID;
128:
129: user_hook_rec.REQ_LINE_DETAIL_ID := l_req_line_details.REQ_LINE_DETAIL_ID;
130: csp_req_line_details_iuhk.Update_req_line_detail_Pre
131: ( x_return_status => l_return_status
132: ) ;
133: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
134: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');

Line 154: csp_req_line_details_iuhk.Update_req_line_detail_post

150: SOURCE_TYPE = decode( l_req_line_details.SOURCE_TYPE, FND_API.G_MISS_CHAR, SOURCE_TYPE, l_req_line_details.SOURCE_TYPE),
151: SOURCE_ID = decode( l_req_line_details.SOURCE_ID, FND_API.G_MISS_NUM, SOURCE_ID, l_req_line_details.SOURCE_ID)
152: where REQ_LINE_DETAIL_ID = l_req_line_details.REQ_LINE_DETAIL_ID;
153:
154: csp_req_line_details_iuhk.Update_req_line_detail_post
155: ( x_return_status => l_return_status
156: ) ;
157: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
158: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');

Line 181: csp_req_line_details_iuhk.delete_req_line_detail_Pre

177: l_api_name_full varchar2(50) := 'CSP_REQ_LINE_DETAILS_PKG.DELETE_ROW';
178:
179: BEGIN
180: user_hook_rec.REQ_LINE_DETAIL_ID := px_REQ_LINE_DETAIL_ID;
181: csp_req_line_details_iuhk.delete_req_line_detail_Pre
182: ( x_return_status => l_return_status
183: ) ;
184: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
185: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');

Line 193: csp_req_line_details_iuhk.delete_req_line_detail_Post

189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;
191: DELETE FROM CSP_REQ_LINE_DETAILS
192: WHERE REQ_LINE_DETAIL_ID = px_REQ_LINE_DETAIL_ID;
193: csp_req_line_details_iuhk.delete_req_line_detail_Post
194: ( x_return_status => l_return_status
195: ) ;
196: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
197: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');