APPS.GMS_PERSONNEL_PKG dependencies on GMS_PERSONNEL

Line 1: package body GMS_PERSONNEL_PKG as

1: package body GMS_PERSONNEL_PKG as
2: -- $Header: gmsawplb.pls 115.4 2002/11/26 18:49:56 jmuthuku ship $
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_PERSONNEL_ID in NUMBER,

Line 14: cursor C is select ROWID from GMS_PERSONNEL

10: X_END_DATE_ACTIVE in DATE,
11: X_REQUIRED_FLAG in VARCHAR2,
12: X_MODE in VARCHAR2 default 'R'
13: ) is
14: cursor C is select ROWID from GMS_PERSONNEL
15: where PERSONNEL_ID = X_PERSONNEL_ID;
16: X_LAST_UPDATE_DATE DATE;
17: X_LAST_UPDATED_BY NUMBER;
18: X_LAST_UPDATE_LOGIN NUMBER;

Line 37: insert into GMS_PERSONNEL (

33: else
34: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
35: app_exception.raise_exception;
36: end if;
37: insert into GMS_PERSONNEL (
38: AWARD_ID,
39: PERSON_ID,
40: AWARD_ROLE,
41: START_DATE_ACTIVE,

Line 91: from GMS_PERSONNEL

87: AWARD_ROLE,
88: START_DATE_ACTIVE,
89: END_DATE_ACTIVE,
90: REQUIRED_FLAG
91: from GMS_PERSONNEL
92: where PERSONNEL_ID = X_PERSONNEL_ID
93: for update of PERSONNEL_ID nowait;
94: tlinfo c1%rowtype;
95:

Line 159: update GMS_PERSONNEL set

155: else
156: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
157: app_exception.raise_exception;
158: end if;
159: update GMS_PERSONNEL set
160: AWARD_ID = X_AWARD_ID,
161: PERSON_ID = X_PERSON_ID,
162: AWARD_ROLE = X_AWARD_ROLE,
163: START_DATE_ACTIVE = X_START_DATE_ACTIVE,

Line 187: cursor c1 is select rowid from GMS_PERSONNEL

183: X_END_DATE_ACTIVE in DATE,
184: X_REQUIRED_FLAG in VARCHAR2,
185: X_MODE in VARCHAR2 default 'R'
186: ) is
187: cursor c1 is select rowid from GMS_PERSONNEL
188: where PERSONNEL_ID = X_PERSONNEL_ID
189: ;
190: dummy c1%rowtype;
191: begin

Line 224: delete from GMS_PERSONNEL

220: procedure DELETE_ROW (
221: X_PERSONNEL_ID in NUMBER
222: ) is
223: begin
224: delete from GMS_PERSONNEL
225: where PERSONNEL_ID = X_PERSONNEL_ID;
226: if (sql%notfound) then
227: raise no_data_found;
228: end if;

Line 231: end GMS_PERSONNEL_PKG;

227: raise no_data_found;
228: end if;
229: end DELETE_ROW;
230:
231: end GMS_PERSONNEL_PKG;