APPS.CSD_REPAIR_MILESTONES_PKG dependencies on CSD_REPAIR_MILESTONES

Line 1: package body CSD_REPAIR_MILESTONES_PKG as

1: package body CSD_REPAIR_MILESTONES_PKG as
2: /* $Header: csdtromb.pls 120.0 2005/07/14 18:57:09 vkjain noship $ */
3:
4: procedure INSERT_ROW (
5: -- P_ROWID in out nocopy VARCHAR2,

Line 20: cursor C is select ROWID from CSD_REPAIR_MILESTONES

16: ) is
17:
18: P_ROWID ROWID;
19:
20: cursor C is select ROWID from CSD_REPAIR_MILESTONES
21: where REPAIR_MILESTONE_ID = PX_REPAIR_MILESTONE_ID
22: ;
23:
24: begin

Line 26: select CSD_REPAIR_MILESTONES_S1.nextval

22: ;
23:
24: begin
25:
26: select CSD_REPAIR_MILESTONES_S1.nextval
27: into PX_REPAIR_MILESTONE_ID
28: from dual;
29:
30: insert into CSD_REPAIR_MILESTONES (

Line 30: insert into CSD_REPAIR_MILESTONES (

26: select CSD_REPAIR_MILESTONES_S1.nextval
27: into PX_REPAIR_MILESTONE_ID
28: from dual;
29:
30: insert into CSD_REPAIR_MILESTONES (
31: REPAIR_MILESTONE_ID,
32: REPAIR_LINE_ID,
33: MILESTONE_CODE,
34: MILESTONE_DATE,

Line 70: from CSD_REPAIR_MILESTONES

66: P_OBJECT_VERSION_NUMBER in NUMBER
67: ) is
68: cursor c is select
69: OBJECT_VERSION_NUMBER
70: from CSD_REPAIR_MILESTONES
71: where REPAIR_MILESTONE_ID = P_REPAIR_MILESTONE_ID
72: for update of REPAIR_MILESTONE_ID nowait;
73: recinfo c%rowtype;
74:

Line 107: update CSD_REPAIR_MILESTONES set

103: P_LAST_UPDATED_BY in NUMBER,
104: P_LAST_UPDATE_LOGIN in NUMBER
105: ) is
106: begin
107: update CSD_REPAIR_MILESTONES set
108: REPAIR_LINE_ID = P_REPAIR_LINE_ID,
109: MILESTONE_CODE = P_MILESTONE_CODE,
110: MILESTONE_DATE = P_MILESTONE_DATE,
111: OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER,

Line 132: delete from CSD_REPAIR_MILESTONES

128: P_REPAIR_MILESTONE_ID in NUMBER
129: ) is
130: begin
131:
132: delete from CSD_REPAIR_MILESTONES
133: where REPAIR_MILESTONE_ID = P_REPAIR_MILESTONE_ID;
134:
135: if (sql%notfound) then
136: raise no_data_found;

Line 140: end CSD_REPAIR_MILESTONES_PKG;

136: raise no_data_found;
137: end if;
138: end DELETE_ROW;
139:
140: end CSD_REPAIR_MILESTONES_PKG;