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.2.12020000.2 2013/01/18 07:06:58 htank ship $ */
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 30: l_api_name_full varchar2(50) := 'CSP_REQ_LINE_DETAILS_PKG.INSERT_ROW';

26: l_req_line_details CSP_REQ_LINE_DETAILS_PVT.Req_line_details_Rec_Type;
27: l_return_status varchar2(100);
28: l_msg_count NUMBER;
29: l_msg_data varchar2(1000);
30: l_api_name_full varchar2(50) := 'CSP_REQ_LINE_DETAILS_PKG.INSERT_ROW';
31: l_dml_mode varchar2(10) := p_dml_mode;
32:
33: l_module_name VARCHAR2(100) := 'csp.plsql.csp_req_line_details_pkg.insert_row';
34:

Line 33: l_module_name VARCHAR2(100) := 'csp.plsql.csp_req_line_details_pkg.insert_row';

29: l_msg_data varchar2(1000);
30: l_api_name_full varchar2(50) := 'CSP_REQ_LINE_DETAILS_PKG.INSERT_ROW';
31: l_dml_mode varchar2(10) := p_dml_mode;
32:
33: l_module_name VARCHAR2(100) := 'csp.plsql.csp_req_line_details_pkg.insert_row';
34:
35: BEGIN
36:
37: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

159: p_SOURCE_ID NUMBER,
160: p_DML_MODE VARCHAR2)
161: IS
162: l_req_line_details CSP_REQ_line_details_PVT.Req_LINE_Details_Rec_Type;
163: l_api_name_full varchar2(50) := 'CSP_REQ_LINE_DETAILS_PKG.UPDATE_ROW';
164: l_return_status varchar2(100);
165: l_msg_count NUMBER;
166: l_msg_data varchar2(1000);
167: l_dml_mode varchar2(10) := p_dml_mode;

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

233: IS
234: l_return_status varchar2(100);
235: l_msg_count NUMBER;
236: l_msg_data varchar2(1000);
237: l_api_name_full varchar2(50) := 'CSP_REQ_LINE_DETAILS_PKG.DELETE_ROW';
238: l_dml_mode varchar2(10) := p_dml_mode;
239: BEGIN
240: IF l_dml_mode is null THEN
241: l_dml_mode :='BOTH';

Line 339: End CSP_REQ_LINE_DETAILS_PKG;

335: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
336: APP_EXCEPTION.RAISE_EXCEPTION;
337: End If;
338: END Lock_Row;
339: End CSP_REQ_LINE_DETAILS_PKG;