31: X_LAST_UPDATE_LOGIN := -1;
32: end if;
33: else
34: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
35: app_exception.raise_exception;
36: end if;
37: insert into GMS_AWARDS_CONTACTS (
38: AWARD_ID,
39: CONTACT_ID,
83: fetch c1 into tlinfo;
84: if (c1%notfound) then
85: close c1;
86: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
87: app_exception.raise_exception;
88: end if;
89: close c1;
90: if (
91: (tlinfo.award_id = x_award_id)
100: ) then
101: return;
102: else
103: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
104: app_exception.raise_exception;
105: end if;
106: end LOCK_ROW;
107: procedure UPDATE_ROW (
108: X_AWARD_ID in NUMBER,
131: X_LAST_UPDATE_LOGIN := -1;
132: end if;
133: else
134: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
135: app_exception.raise_exception;
136: end if;
137: update GMS_AWARDS_CONTACTS set
138: CONTACT_ID = X_CONTACT_ID,
139: PRIMARY_FLAG = X_PRIMARY_FLAG,