APPS.CS_COST_DETAILS_PKG dependencies on CS_COST_DETAILS

Line 1: PACKAGE BODY CS_COST_DETAILS_PKG AS

1: PACKAGE BODY CS_COST_DETAILS_PKG AS
2: /* $Header: csxcstb.pls 120.2 2008/01/18 07:01:10 bkanimoz noship $ */
3:
4: L_API_NAME_FULL CONSTANT VARCHAR2(255):='CS_COST_DETAILS_PKG';
5: L_LOG_MODULE CONSTANT VARCHAR2(255):='csxcstb.pls'|| L_API_NAME_FULL ||'.';

Line 4: L_API_NAME_FULL CONSTANT VARCHAR2(255):='CS_COST_DETAILS_PKG';

1: PACKAGE BODY CS_COST_DETAILS_PKG AS
2: /* $Header: csxcstb.pls 120.2 2008/01/18 07:01:10 bkanimoz noship $ */
3:
4: L_API_NAME_FULL CONSTANT VARCHAR2(255):='CS_COST_DETAILS_PKG';
5: L_LOG_MODULE CONSTANT VARCHAR2(255):='csxcstb.pls'|| L_API_NAME_FULL ||'.';
6:
7:
8: /*====================================

Line 62: SELECT cs_cost_details_s.nextval

58:
59:
60:
61: --get the cost_id from the sequence
62: SELECT cs_cost_details_s.nextval
63: INTO l_cost_id
64: FROM DUAL;
65:
66:

Line 78: INTO cs_cost_details

74:
75:
76: --insert the data into cost table
77: INSERT
78: INTO cs_cost_details
79: (
80: cost_id ,
81: incident_id ,
82: estimate_detail_id ,

Line 235: FROM CS_cost_details

231: ) IS
232:
233: CURSOR C2 IS
234: SELECT OBJECT_VERSION_NUMBER
235: FROM CS_cost_details
236: WHERE cost_id = p_cost_id;
237:
238: l_cost_id NUMBER;
239:

Line 242: FROM cs_cost_details

238: l_cost_id NUMBER;
239:
240: CURSOR get_cost_id IS
241: SELECT cost_id
242: FROM cs_cost_details
243: WHERE estimate_detail_id =p_estimate_detail_id;
244:
245:
246: BEGIN

Line 273: UPDATE cs_cost_details

269: END IF;
270:
271:
272:
273: UPDATE cs_cost_details
274: SET cost_id = decode(l_cost_id,FND_API.G_MISS_NUM,cost_id,l_cost_id),
275: incident_id = decode(p_incident_id,FND_API.G_MISS_NUM,incident_id,p_incident_id),
276: estimate_detail_id = decode(p_estimate_detail_id,FND_API.G_MISS_NUM,estimate_detail_id,p_estimate_detail_id),
277: transaction_type_id = decode(p_transaction_type_id,FND_API.G_MISS_NUM ,transaction_type_id,p_transaction_type_id),

Line 352: DELETE FROM cs_cost_details

348: 'Before Deleting the cost record . p_cost_id '||p_cost_id
349: );
350: END IF;
351:
352: DELETE FROM cs_cost_details
353: WHERE cost_id=p_cost_id;
354:
355: IF (SQL%NOTFOUND) THEN
356: RAISE NO_DATA_FOUND;

Line 370: END CS_COST_DETAILS_PKG;

366:
367: END Delete_Row;
368:
369:
370: END CS_COST_DETAILS_PKG;
371: