APPS.GME_BATCH_GROUPS_PKG dependencies on GME_BATCH_GROUPS_B

Line 15: cursor C is select ROWID from GME_BATCH_GROUPS_B

11: X_LAST_UPDATE_DATE in DATE,
12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER
14: ) is
15: cursor C is select ROWID from GME_BATCH_GROUPS_B
16: where GROUP_ID = X_GROUP_ID
17: ;
18: begin
19: insert into GME_BATCH_GROUPS_B (

Line 19: insert into GME_BATCH_GROUPS_B (

15: cursor C is select ROWID from GME_BATCH_GROUPS_B
16: where GROUP_ID = X_GROUP_ID
17: ;
18: begin
19: insert into GME_BATCH_GROUPS_B (
20: GROUP_ID,
21: GROUP_NAME,
22: ORGANIZATION_ID,
23: CREATION_DATE,

Line 86: from GME_BATCH_GROUPS_B

82: ) is
83: cursor c is select
84: GROUP_NAME,
85: ORGANIZATION_ID
86: from GME_BATCH_GROUPS_B
87: where GROUP_ID = X_GROUP_ID
88: for update of GROUP_ID nowait;
89: recinfo c%rowtype;
90:

Line 142: update GME_BATCH_GROUPS_B set

138: X_LAST_UPDATED_BY in NUMBER,
139: X_LAST_UPDATE_LOGIN in NUMBER
140: ) is
141: begin
142: update GME_BATCH_GROUPS_B set
143: GROUP_NAME = X_GROUP_NAME,
144: ORGANIZATION_ID = X_ORGANIZATION_ID,
145: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
146: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 179: delete from GME_BATCH_GROUPS_B

175: if (sql%notfound) then
176: raise no_data_found;
177: end if;
178:
179: delete from GME_BATCH_GROUPS_B
180: where GROUP_ID = X_GROUP_ID;
181:
182: if (sql%notfound) then
183: raise no_data_found;

Line 193: from GME_BATCH_GROUPS_B B

189: begin
190: delete from GME_BATCH_GROUPS_TL T
191: where not exists
192: (select NULL
193: from GME_BATCH_GROUPS_B B
194: where B.GROUP_ID = T.GROUP_ID
195: );
196:
197: update GME_BATCH_GROUPS_TL T set (