APPS.GMP_PARAMETER_VALUES_PKG dependencies on GMP_PARAMETER_VALUES_B

Line 14: cursor C is select ROWID from GMP_PARAMETER_VALUES_B

10: X_LAST_UPDATE_DATE in DATE,
11: X_LAST_UPDATED_BY in NUMBER,
12: X_LAST_UPDATE_LOGIN in NUMBER
13: ) is
14: cursor C is select ROWID from GMP_PARAMETER_VALUES_B
15: where PARAMETER_ID = X_PARAMETER_ID
16: ;
17: begin
18: insert into GMP_PARAMETER_VALUES_B (

Line 18: insert into GMP_PARAMETER_VALUES_B (

14: cursor C is select ROWID from GMP_PARAMETER_VALUES_B
15: where PARAMETER_ID = X_PARAMETER_ID
16: ;
17: begin
18: insert into GMP_PARAMETER_VALUES_B (
19: PARAMETER_ID,
20: PARAMETER_VALUE,
21: CREATION_DATE,
22: CREATED_BY,

Line 84: from GMP_PARAMETER_VALUES_B

80: X_PARAMETER_VALUE_DESCRIPTION in VARCHAR2
81: ) is
82: cursor c is select
83: PARAMETER_VALUE
84: from GMP_PARAMETER_VALUES_B
85: where PARAMETER_ID = X_PARAMETER_ID
86: and PARAMETER_VALUE = X_PARAMETER_VALUE
87: for update of PARAMETER_ID nowait;
88: recinfo c%rowtype;

Line 140: update GMP_PARAMETER_VALUES_B set

136: X_LAST_UPDATED_BY in NUMBER,
137: X_LAST_UPDATE_LOGIN in NUMBER
138: ) is
139: begin
140: update GMP_PARAMETER_VALUES_B set
141: PARAMETER_VALUE = X_PARAMETER_VALUE,
142: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
143: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
144: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 180: delete from GMP_PARAMETER_VALUES_B

176: if (sql%notfound) then
177: raise no_data_found;
178: end if;
179:
180: delete from GMP_PARAMETER_VALUES_B
181: where PARAMETER_ID = X_PARAMETER_ID
182: and PARAMETER_VALUE = X_PARAMETER_VALUE;
183:
184: if (sql%notfound) then

Line 195: from GMP_PARAMETER_VALUES_B B

191: begin
192: delete from GMP_PARAMETER_VALUES_TL T
193: where not exists
194: (select NULL
195: from GMP_PARAMETER_VALUES_B B
196: where B.PARAMETER_ID = T.PARAMETER_ID
197: and B.PARAMETER_VALUE = T.PARAMETER_VALUE
198: );
199: