eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_REQ_LINE_DETAILS_PKG dependencies on CSP_REQ_LINE_DETAILS

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 25: CURSOR C2 IS SELECT CSP_REQ_LINE_DETAILS_S1.nextval FROM sys.dual;

21: p_SOURCE_TYPE VARCHAR2,
22: p_SOURCE_ID NUMBER,
23: p_DML_MODE VARCHAR2)
24: IS
25: CURSOR C2 IS SELECT CSP_REQ_LINE_DETAILS_S1.nextval FROM sys.dual;
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);

Line 26: l_req_line_details CSP_REQ_LINE_DETAILS_PVT.Req_line_details_Rec_Type;

22: p_SOURCE_ID NUMBER,
23: p_DML_MODE VARCHAR2)
24: IS
25: CURSOR C2 IS SELECT CSP_REQ_LINE_DETAILS_S1.nextval FROM sys.dual;
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';

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 67: 'before calling csp_req_line_details_iuhk.Create_req_line_detail_Pre...');

63: IF l_dml_mode <> 'POST' THEN
64: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
65: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
66: l_module_name,
67: 'before calling csp_req_line_details_iuhk.Create_req_line_detail_Pre...');
68: end if;
69:
70: csp_req_line_details_iuhk.Create_req_line_detail_Pre
71: ( x_return_status => l_return_status

Line 70: csp_req_line_details_iuhk.Create_req_line_detail_Pre

66: l_module_name,
67: 'before calling csp_req_line_details_iuhk.Create_req_line_detail_Pre...');
68: end if;
69:
70: csp_req_line_details_iuhk.Create_req_line_detail_Pre
71: ( x_return_status => l_return_status
72: ) ;
73: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
74: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 76: 'after calling csp_req_line_details_iuhk.Create_req_line_detail_Pre. l_return_status = ' || l_return_status);

72: ) ;
73: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
74: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
75: l_module_name,
76: 'after calling csp_req_line_details_iuhk.Create_req_line_detail_Pre. l_return_status = ' || l_return_status);
77: end if;
78: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
79: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
80: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_INT_CUST_USR_HK');

Line 97: INSERT INTO CSP_REQ_LINE_DETAILS(

93: user_hook_rec.REQ_LINE_DETAIL_ID := l_req_line_details.REQ_LINE_DETAIL_ID;
94:
95: IF l_dml_mode = 'BOTH' THEN
96:
97: INSERT INTO CSP_REQ_LINE_DETAILS(
98: REQ_LINE_DETAIL_ID,
99: REQUIREMENT_LINE_ID,
100: CREATED_BY,
101: CREATION_DATE,

Line 127: 'before calling csp_req_line_details_iuhk.Create_req_line_detail_Post...');

123:
124: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
125: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
126: l_module_name,
127: 'before calling csp_req_line_details_iuhk.Create_req_line_detail_Post...');
128: end if;
129:
130: csp_req_line_details_iuhk.Create_req_line_detail_Post
131: ( x_return_status => l_return_status

Line 130: csp_req_line_details_iuhk.Create_req_line_detail_Post

126: l_module_name,
127: 'before calling csp_req_line_details_iuhk.Create_req_line_detail_Post...');
128: end if;
129:
130: csp_req_line_details_iuhk.Create_req_line_detail_Post
131: ( x_return_status => l_return_status
132: ) ;
133:
134: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 137: 'after calling csp_req_line_details_iuhk.Create_req_line_detail_Post. l_return_status = ' || l_return_status);

133:
134: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
135: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
136: l_module_name,
137: 'after calling csp_req_line_details_iuhk.Create_req_line_detail_Post. l_return_status = ' || l_return_status);
138: end if;
139:
140: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
141: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');

Line 162: l_req_line_details CSP_REQ_line_details_PVT.Req_LINE_Details_Rec_Type;

158: p_SOURCE_TYPE VARCHAR2,
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);

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 185: csp_req_line_details_iuhk.Update_req_line_detail_Pre

181:
182: IF l_dml_mode <> 'POST' THEN
183:
184: user_hook_rec.REQ_LINE_DETAIL_ID := l_req_line_details.REQ_LINE_DETAIL_ID;
185: csp_req_line_details_iuhk.Update_req_line_detail_Pre
186: ( x_return_status => l_return_status
187: ) ;
188: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
189: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');

Line 199: Update CSP_REQ_LINE_DETAILS

195: END IF;
196:
197: IF l_dml_mode = 'BOTH' THEN
198:
199: Update CSP_REQ_LINE_DETAILS
200: SET
201: REQUIREMENT_LINE_ID = decode( l_req_line_details.REQUIREMENT_LINE_ID, FND_API.G_MISS_NUM, REQUIREMENT_LINE_ID, l_req_line_details.REQUIREMENT_LINE_ID),
202: CREATED_BY = decode( l_req_line_details.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_req_line_details.CREATED_BY),
203: CREATION_DATE = decode( l_req_line_details.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_req_line_details.CREATION_DATE),

Line 213: csp_req_line_details_iuhk.Update_req_line_detail_post

209: where REQ_LINE_DETAIL_ID = l_req_line_details.REQ_LINE_DETAIL_ID;
210: END IF;
211:
212: IF l_dml_mode <> 'PRE' THEN
213: csp_req_line_details_iuhk.Update_req_line_detail_post
214: ( x_return_status => l_return_status
215: ) ;
216: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
217: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');

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 246: csp_req_line_details_iuhk.delete_req_line_detail_Pre

242: END IF;
243:
244: IF l_dml_mode <> 'POST' THEN
245: user_hook_rec.REQ_LINE_DETAIL_ID := px_REQ_LINE_DETAIL_ID;
246: csp_req_line_details_iuhk.delete_req_line_detail_Pre
247: ( x_return_status => l_return_status
248: ) ;
249: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
250: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');

Line 259: DELETE FROM CSP_REQ_LINE_DETAILS

255: END IF;
256: END IF;
257:
258: IF l_dml_mode = 'BOTH' THEN
259: DELETE FROM CSP_REQ_LINE_DETAILS
260: WHERE REQ_LINE_DETAIL_ID = px_REQ_LINE_DETAIL_ID;
261: END IF;
262:
263: IF l_dml_mode <> 'PRE' THEN

Line 264: csp_req_line_details_iuhk.delete_req_line_detail_Post

260: WHERE REQ_LINE_DETAIL_ID = px_REQ_LINE_DETAIL_ID;
261: END IF;
262:
263: IF l_dml_mode <> 'PRE' THEN
264: csp_req_line_details_iuhk.delete_req_line_detail_Post
265: ( x_return_status => l_return_status
266: ) ;
267: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
268: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');

Line 293: FROM CSP_REQ_LINE_DETAILS

289: p_SOURCE_ID NUMBER)
290: IS
291: CURSOR C IS
292: SELECT *
293: FROM CSP_REQ_LINE_DETAILS
294: WHERE REQ_LINE_DETAIL_ID = px_REQ_LINE_DETAIL_ID
295: FOR UPDATE of REQ_LINE_DETAIL_ID NOWAIT;
296: Recinfo C%ROWTYPE;
297: BEGIN

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;