APPS.CSD_FLWSTS_TRAN_MILES_PKG dependencies on CSD_FLWSTS_TRAN_MILES

Line 1: package body CSD_FLWSTS_TRAN_MILES_PKG as

1: package body CSD_FLWSTS_TRAN_MILES_PKG as
2: /* $Header: csdtflmb.pls 120.1 2005/07/29 16:35:31 vkjain noship $ */
3:
4: procedure INSERT_ROW (
5: -- P_ROWID in out nocopy VARCHAR2,

Line 19: cursor C is select ROWID from CSD_FLWSTS_TRAN_MILES

15: ) is
16:
17: P_ROWID ROWID;
18:
19: cursor C is select ROWID from CSD_FLWSTS_TRAN_MILES
20: where FLWSTS_TRAN_MILE_ID = PX_FLWSTS_TRAN_MILE_ID
21: ;
22:
23: begin

Line 25: select CSD_FLWSTS_TRAN_MILES_S1.nextval

21: ;
22:
23: begin
24:
25: select CSD_FLWSTS_TRAN_MILES_S1.nextval
26: into PX_FLWSTS_TRAN_MILE_ID
27: from dual;
28:
29: insert into CSD_FLWSTS_TRAN_MILES (

Line 29: insert into CSD_FLWSTS_TRAN_MILES (

25: select CSD_FLWSTS_TRAN_MILES_S1.nextval
26: into PX_FLWSTS_TRAN_MILE_ID
27: from dual;
28:
29: insert into CSD_FLWSTS_TRAN_MILES (
30: FLWSTS_TRAN_MILE_ID,
31: FLWSTS_TRAN_ID,
32: MILESTONE_CODE,
33: OBJECT_VERSION_NUMBER,

Line 67: from CSD_FLWSTS_TRAN_MILES

63: P_OBJECT_VERSION_NUMBER in NUMBER
64: ) is
65: cursor c is select
66: OBJECT_VERSION_NUMBER
67: from CSD_FLWSTS_TRAN_MILES
68: where FLWSTS_TRAN_MILE_ID = P_FLWSTS_TRAN_MILE_ID
69: for update of FLWSTS_TRAN_MILE_ID nowait;
70: recinfo c%rowtype;
71:

Line 103: update CSD_FLWSTS_TRAN_MILES set

99: P_LAST_UPDATED_BY in NUMBER,
100: P_LAST_UPDATE_LOGIN in NUMBER
101: ) is
102: begin
103: update CSD_FLWSTS_TRAN_MILES set
104: FLWSTS_TRAN_ID = P_FLWSTS_TRAN_ID,
105: MILESTONE_CODE = P_MILESTONE_CODE,
106: OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER + 1,
107: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,

Line 127: delete from CSD_FLWSTS_TRAN_MILES

123: P_FLWSTS_TRAN_MILE_ID in NUMBER
124: ) is
125: begin
126:
127: delete from CSD_FLWSTS_TRAN_MILES
128: where FLWSTS_TRAN_MILE_ID = P_FLWSTS_TRAN_MILE_ID;
129:
130: if (sql%notfound) then
131: raise no_data_found;

Line 135: end CSD_FLWSTS_TRAN_MILES_PKG;

131: raise no_data_found;
132: end if;
133: end DELETE_ROW;
134:
135: end CSD_FLWSTS_TRAN_MILES_PKG;