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.1.12000000.2 2007/06/29 10:56:14 vpremach 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.1.12000000.2 2007/06/29 10:56:14 vpremach 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 208: SELECT CS_ESTIMATE_DETAILS_S.nextval

204: x_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER)
205:
206: IS
207: /* CURSOR C IS
208: SELECT CS_ESTIMATE_DETAILS_S.nextval
209: FROM sys.dual; */
210:
211:
212: BEGIN

Line 223: INSERT INTO CS_ESTIMATE_DETAILS(

219:
220:
221: --dbms_output.put_line('inserting into estimate_detail_id =' || x_estimate_detail_id);
222:
223: INSERT INTO CS_ESTIMATE_DETAILS(
224: ESTIMATE_DETAIL_ID,
225: ORG_ID,
226: INCIDENT_ID,
227: ORIGINAL_SOURCE_ID,

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

607: );
608:
609: X_OBJECT_VERSION_NUMBER := 1;
610:
611: -- dbms_output.put_line('after insert into cs_estimate_details');
612:
613: End Insert_Row;
614:
615: PROCEDURE Update_Row(

Line 811: FROM CS_ESTIMATE_DETAILS

807: IS
808:
809: CURSOR C2 IS
810: SELECT OBJECT_VERSION_NUMBER
811: FROM CS_ESTIMATE_DETAILS
812: WHERE estimate_detail_id = p_estimate_detail_id;
813:
814: BEGIN
815:

Line 820: Update CS_ESTIMATE_DETAILS

816: OPEN C2;
817: FETCH C2 INTO X_OBJECT_VERSION_NUMBER;
818: CLOSE C2;
819:
820: Update CS_ESTIMATE_DETAILS
821: SET
822: /* INCIDENT_ID = p_INCIDENT_ID,
823: ORG_ID = p_ORG_ID,
824: ORIGINAL_SOURCE_ID = p_ORIGINAL_SOURCE_ID,

Line 1217: DELETE FROM CS_ESTIMATE_DETAILS

1213: PROCEDURE Delete_Row(
1214: p_ESTIMATE_DETAIL_ID NUMBER)
1215: IS
1216: BEGIN
1217: DELETE FROM CS_ESTIMATE_DETAILS
1218: WHERE ESTIMATE_DETAIL_ID = p_ESTIMATE_DETAIL_ID;
1219:
1220: If (SQL%NOTFOUND) then
1221: RAISE NO_DATA_FOUND;

Line 1234: FROM CS_ESTIMATE_DETAILS

1230: IS
1231:
1232: CURSOR C IS
1233: SELECT *
1234: FROM CS_ESTIMATE_DETAILS
1235: WHERE ESTIMATE_DETAIL_ID = p_ESTIMATE_DETAIL_ID
1236: AND OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER
1237: FOR UPDATE of ESTIMATE_DETAIL_ID NOWAIT;
1238:

Line 1264: End CS_ESTIMATE_DETAILS_PKG;

1260: APP_EXCEPTION.RAISE_EXCEPTION;
1261: End If;
1262: END Lock_Row;
1263:
1264: End CS_ESTIMATE_DETAILS_PKG;