APPS.PN_SET_MILESTONES_PKG dependencies on PN_SET_MILESTONES

Line 1: package body PN_SET_MILESTONES_PKG as

1: package body PN_SET_MILESTONES_PKG as
2: -- $Header: PNTSTMLB.pls 120.1 2005/08/05 06:24:44 appldev ship $
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 37: from PN_SET_MILESTONES

33: X_LAST_UPDATE_LOGIN in NUMBER
34: ) IS
35: cursor C is
36: select ROWID
37: from PN_SET_MILESTONES
38: where MILESTONES_SET_ID = X_MILESTONES_SET_ID ;
39:
40: begin
41:

Line 44: select PN_SET_MILESTONES_S.nextval

40: begin
41:
42: if X_MILESTONES_SET_ID is null then
43:
44: select PN_SET_MILESTONES_S.nextval
45: into X_MILESTONES_SET_ID
46: from dual;
47:
48: end if;

Line 50: insert into PN_SET_MILESTONES (

46: from dual;
47:
48: end if;
49:
50: insert into PN_SET_MILESTONES (
51: MILESTONES_SET_ID,
52: SET_ID,
53: LAST_UPDATE_DATE,
54: LAST_UPDATED_BY,

Line 148: from PN_SET_MILESTONES

144: X_FREQUENCY in NUMBER
145: ) IS
146: cursor c1 is
147: select *
148: from PN_SET_MILESTONES
149: where MILESTONES_SET_ID = X_MILESTONES_SET_ID
150: for update of MILESTONES_SET_ID nowait;
151:
152: tlinfo c1%rowtype;

Line 244: update PN_SET_MILESTONES

240: X_LAST_UPDATE_LOGIN in NUMBER
241: ) IS
242: begin
243:
244: update PN_SET_MILESTONES
245: set
246: USER_ID = X_USER_ID,
247: NOTIFICATION_DATE = X_NOTIFICATION_DATE,
248: LEAD_DAYS = X_LEAD_DAYS,

Line 282: delete from PN_SET_MILESTONES

278: X_MILESTONES_SET_ID in NUMBER
279: ) IS
280: begin
281:
282: delete from PN_SET_MILESTONES
283: where MILESTONES_SET_ID = X_MILESTONES_SET_ID;
284:
285: if (sql%notfound) then
286: raise no_data_found;

Line 292: end PN_SET_MILESTONES_PKG;

288:
289: end DELETE_ROW;
290:
291:
292: end PN_SET_MILESTONES_PKG;