APPS.GMP_PROCESS_PARAMETER_SET_PKG dependencies on GMP_PROCESS_PARAMETER_SET_B

Line 14: cursor C is select ROWID from GMP_PROCESS_PARAMETER_SET_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_PROCESS_PARAMETER_SET_B
15: where PARAMETER_SET_ID = X_PARAMETER_SET_ID
16: ;
17: begin
18: insert into GMP_PROCESS_PARAMETER_SET_B (

Line 18: insert into GMP_PROCESS_PARAMETER_SET_B (

14: cursor C is select ROWID from GMP_PROCESS_PARAMETER_SET_B
15: where PARAMETER_SET_ID = X_PARAMETER_SET_ID
16: ;
17: begin
18: insert into GMP_PROCESS_PARAMETER_SET_B (
19: PARAMETER_SET_ID,
20: PARAMETER_SET,
21: CREATION_DATE,
22: CREATED_BY,

Line 81: from GMP_PROCESS_PARAMETER_SET_B

77: X_SET_DESCRIPTION in VARCHAR2
78: ) is
79: cursor c is select
80: PARAMETER_SET
81: from GMP_PROCESS_PARAMETER_SET_B
82: where PARAMETER_SET_ID = X_PARAMETER_SET_ID
83: for update of PARAMETER_SET_ID nowait;
84: recinfo c%rowtype;
85:

Line 134: update GMP_PROCESS_PARAMETER_SET_B set

130: X_LAST_UPDATED_BY in NUMBER,
131: X_LAST_UPDATE_LOGIN in NUMBER
132: ) is
133: begin
134: update GMP_PROCESS_PARAMETER_SET_B set
135: PARAMETER_SET = X_PARAMETER_SET,
136: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
137: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
138: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 170: delete from GMP_PROCESS_PARAMETER_SET_B

166: if (sql%notfound) then
167: raise no_data_found;
168: end if;
169:
170: delete from GMP_PROCESS_PARAMETER_SET_B
171: where PARAMETER_SET_ID = X_PARAMETER_SET_ID;
172:
173: if (sql%notfound) then
174: raise no_data_found;

Line 184: from GMP_PROCESS_PARAMETER_SET_B B

180: begin
181: delete from GMP_PROCESS_PARAMETER_SET_TL T
182: where not exists
183: (select NULL
184: from GMP_PROCESS_PARAMETER_SET_B B
185: where B.PARAMETER_SET_ID = T.PARAMETER_SET_ID
186: );
187:
188: update GMP_PROCESS_PARAMETER_SET_TL T set (