APPS.CS_ESTIMATE_DETAILS_PKG dependencies on CS_ESTIMATE_DETAILS

Line 1: PACKAGE BODY CS_ESTIMATE_DETAILS_PKG as

1: PACKAGE BODY CS_ESTIMATE_DETAILS_PKG as
2: /* $Header: csxtchdb.pls 120.7.12020000.3 2013/01/30 09:11:32 bkanimoz ship $ */
3: -- Start of Comments
4: -- Package name : CS_ESTIMATE_DETAILS_PKG
5: -- Purpose :

Line 4: -- Package name : CS_ESTIMATE_DETAILS_PKG

1: PACKAGE BODY CS_ESTIMATE_DETAILS_PKG as
2: /* $Header: csxtchdb.pls 120.7.12020000.3 2013/01/30 09:11:32 bkanimoz ship $ */
3: -- Start of Comments
4: -- Package name : CS_ESTIMATE_DETAILS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CS_ESTIMATE_DETAILS_PKG';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CS_ESTIMATE_DETAILS_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csxtchdb.pls';
13:
14: PROCEDURE Insert_Row(
15: p_ORG_ID NUMBER,

Line 225: SELECT CS_ESTIMATE_DETAILS_S.nextval

221: x_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER)
222:
223: IS
224: /* CURSOR C IS
225: SELECT CS_ESTIMATE_DETAILS_S.nextval
226: FROM sys.dual; */
227:
228:
229: BEGIN

Line 240: INSERT INTO CS_ESTIMATE_DETAILS(

236:
237:
238: --dbms_output.put_line('inserting into estimate_detail_id =' || x_estimate_detail_id);
239:
240: INSERT INTO CS_ESTIMATE_DETAILS(
241: ESTIMATE_DETAIL_ID,
242: ORG_ID,
243: INCIDENT_ID,
244: ORIGINAL_SOURCE_ID,

Line 662: -- dbms_output.put_line('after insert into cs_estimate_details');

658: );
659:
660: X_OBJECT_VERSION_NUMBER := 1;
661:
662: -- dbms_output.put_line('after insert into cs_estimate_details');
663:
664: End Insert_Row;
665:
666: PROCEDURE Update_Row(

Line 879: FROM CS_ESTIMATE_DETAILS

875: IS
876:
877: CURSOR C2 IS
878: SELECT OBJECT_VERSION_NUMBER
879: FROM CS_ESTIMATE_DETAILS
880: WHERE estimate_detail_id = p_estimate_detail_id;
881:
882: BEGIN
883:

Line 888: Update CS_ESTIMATE_DETAILS

884: OPEN C2;
885: FETCH C2 INTO X_OBJECT_VERSION_NUMBER;
886: CLOSE C2;
887:
888: Update CS_ESTIMATE_DETAILS
889: SET
890: /* INCIDENT_ID = p_INCIDENT_ID,
891: ORG_ID = p_ORG_ID,
892: ORIGINAL_SOURCE_ID = p_ORIGINAL_SOURCE_ID,

Line 1300: DELETE FROM CS_ESTIMATE_DETAILS

1296: PROCEDURE Delete_Row(
1297: p_ESTIMATE_DETAIL_ID NUMBER)
1298: IS
1299: BEGIN
1300: DELETE FROM CS_ESTIMATE_DETAILS
1301: WHERE ESTIMATE_DETAIL_ID = p_ESTIMATE_DETAIL_ID;
1302:
1303: If (SQL%NOTFOUND) then
1304: RAISE NO_DATA_FOUND;

Line 1317: FROM CS_ESTIMATE_DETAILS

1313: IS
1314:
1315: CURSOR C IS
1316: SELECT *
1317: FROM CS_ESTIMATE_DETAILS
1318: WHERE ESTIMATE_DETAIL_ID = p_ESTIMATE_DETAIL_ID
1319: AND OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER
1320: FOR UPDATE of ESTIMATE_DETAIL_ID NOWAIT;
1321:

Line 1347: End CS_ESTIMATE_DETAILS_PKG;

1343: APP_EXCEPTION.RAISE_EXCEPTION;
1344: End If;
1345: END Lock_Row;
1346:
1347: End CS_ESTIMATE_DETAILS_PKG;