APPS.CSP_REQ_LINE_DETAILS_PKG dependencies on CSP_REQ_LINE_DETAILS_PKG

Line 1: PACKAGE BODY CSP_REQ_LINE_DETAILS_PKG as

1: PACKAGE BODY CSP_REQ_LINE_DETAILS_PKG as
2: /* $Header: csptrldb.pls 120.1 2006/03/10 10:39:43 jjalla noship $ */
3: -- Start of Comments
4: -- Package name : CSP_REQUIREMENT_LINES_PKG
5: -- Purpose :

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_REQ_LINE_DETAILS_PKG';

6: -- History :
7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_REQ_LINE_DETAILS_PKG';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csptrldb.pls';
12:
13: PROCEDURE Insert_Row(
14: px_REQ_LINE_DETAIL_ID IN OUT NOCOPY NUMBER,

Line 29: l_api_name_full varchar2(50) := 'CSP_REQ_LINE_DETAILS_PKG.INSERT_ROW';

25: l_req_line_details CSP_REQ_LINE_DETAILS_PVT.Req_line_details_Rec_Type;
26: l_return_status varchar2(100);
27: l_msg_count NUMBER;
28: l_msg_data varchar2(1000);
29: l_api_name_full varchar2(50) := 'CSP_REQ_LINE_DETAILS_PKG.INSERT_ROW';
30:
31:
32:
33: BEGIN

Line 114: l_api_name_full varchar2(50) := 'CSP_REQ_LINE_DETAILS_PKG.UPDATE_ROW';

110: p_SOURCE_TYPE VARCHAR2,
111: p_SOURCE_ID NUMBER)
112: IS
113: l_req_line_details CSP_REQ_line_details_PVT.Req_LINE_Details_Rec_Type;
114: l_api_name_full varchar2(50) := 'CSP_REQ_LINE_DETAILS_PKG.UPDATE_ROW';
115: l_return_status varchar2(100);
116: l_msg_count NUMBER;
117: l_msg_data varchar2(1000);
118: BEGIN

Line 177: l_api_name_full varchar2(50) := 'CSP_REQ_LINE_DETAILS_PKG.DELETE_ROW';

173: IS
174: l_return_status varchar2(100);
175: l_msg_count NUMBER;
176: l_msg_data varchar2(1000);
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

Line 267: End CSP_REQ_LINE_DETAILS_PKG;

263: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
264: APP_EXCEPTION.RAISE_EXCEPTION;
265: End If;
266: END Lock_Row;
267: End CSP_REQ_LINE_DETAILS_PKG;