APPS.AZ_SELECTION_SETS_PKG dependencies on AZ_SELECTION_SETS_B

Line 21: cursor C is select ROWID from AZ_SELECTION_SETS_B

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from AZ_SELECTION_SETS_B
22: where SELECTION_SET_CODE = X_SELECTION_SET_CODE
23: and USER_ID = X_USER_ID
24: ;
25: begin

Line 26: insert into AZ_SELECTION_SETS_B (

22: where SELECTION_SET_CODE = X_SELECTION_SET_CODE
23: and USER_ID = X_USER_ID
24: ;
25: begin
26: insert into AZ_SELECTION_SETS_B (
27: SELECTION_SET_CODE,
28: USER_ID,
29: STRUCTURE_CODE,
30: ACTIVE,

Line 112: from AZ_SELECTION_SETS_B

108: cursor c is select
109: STRUCTURE_CODE,
110: SOURCE_INSTANCE,
111: PREDEFINED_FLAG
112: from AZ_SELECTION_SETS_B
113: where SELECTION_SET_CODE = X_SELECTION_SET_CODE
114: and USER_ID = X_USER_ID
115: for update of SELECTION_SET_CODE nowait;
116: recinfo c%rowtype;

Line 179: update AZ_SELECTION_SETS_B set

175: X_LAST_UPDATED_BY in NUMBER,
176: X_LAST_UPDATE_LOGIN in NUMBER
177: ) is
178: begin
179: update AZ_SELECTION_SETS_B set
180: STRUCTURE_CODE = X_STRUCTURE_CODE,
181: ACTIVE = X_ACTIVE,
182: HIERARCHICAL_FLAG = X_HIERARCHICAL_FLAG,
183: PARTIAL_SELECTION = X_PARTIAL_SELECTION,

Line 225: delete from AZ_SELECTION_SETS_B

221: if (sql%notfound) then
222: raise no_data_found;
223: end if;
224:
225: delete from AZ_SELECTION_SETS_B
226: where SELECTION_SET_CODE = X_SELECTION_SET_CODE
227: and USER_ID = X_USER_ID;
228:
229: if (sql%notfound) then

Line 240: from AZ_SELECTION_SETS_B B

236: begin
237: delete from AZ_SELECTION_SETS_TL T
238: where not exists
239: (select NULL
240: from AZ_SELECTION_SETS_B B
241: where B.SELECTION_SET_CODE = T.SELECTION_SET_CODE
242: and B.USER_ID = T.USER_ID
243: );
244:

Line 351: from AZ_SELECTION_SETS_B

347: l_owner_id := 1;
348: end if;
349:
350: select last_updated_by into luby
351: from AZ_SELECTION_SETS_B
352: where SELECTION_SET_CODE = X_SELECTION_SET_CODE
353: and USER_ID = X_USER_ID;
354:
355: IF luby = 1 THEN