APPS.GMS_AWARDS_TC_PKG dependencies on GMS_AWARDS_TERMS_CONDITIONS

Line 12: cursor C is select ROWID from GMS_AWARDS_TERMS_CONDITIONS

8: X_OPERAND in VARCHAR2,
9: X_VALUE in NUMBER,
10: X_MODE in VARCHAR2 default 'R'
11: ) is
12: cursor C is select ROWID from GMS_AWARDS_TERMS_CONDITIONS
13: where AWARD_ID = X_AWARD_ID
14: and CATEGORY_ID = X_CATEGORY_ID
15: and TERM_ID = X_TERM_ID;
16: X_LAST_UPDATE_DATE DATE;

Line 37: insert into GMS_AWARDS_TERMS_CONDITIONS (

33: else
34: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
35: app_exception.raise_exception;
36: end if;
37: insert into GMS_AWARDS_TERMS_CONDITIONS (
38: AWARD_ID,
39: CATEGORY_ID,
40: TERM_ID,
41: OPERAND,

Line 78: from GMS_AWARDS_TERMS_CONDITIONS

74: ) is
75: cursor c1 is select
76: OPERAND,
77: VALUE
78: from GMS_AWARDS_TERMS_CONDITIONS
79: where AWARD_ID = X_AWARD_ID
80: and CATEGORY_ID = X_CATEGORY_ID
81: and TERM_ID = X_TERM_ID
82: for update of AWARD_ID nowait;

Line 137: update GMS_AWARDS_TERMS_CONDITIONS set

133: else
134: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
135: app_exception.raise_exception;
136: end if;
137: update GMS_AWARDS_TERMS_CONDITIONS set
138: OPERAND = X_OPERAND,
139: VALUE = X_VALUE,
140: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
141: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 157: delete from GMS_AWARDS_TERMS_CONDITIONS

153: X_CATEGORY_ID in NUMBER,
154: X_TERM_ID in NUMBER
155: ) is
156: begin
157: delete from GMS_AWARDS_TERMS_CONDITIONS
158: where AWARD_ID = X_AWARD_ID
159: and CATEGORY_ID = X_CATEGORY_ID
160: and TERM_ID = X_TERM_ID;
161: if (sql%notfound) then