APPS.AZ_SELECTION_SET_ENTITIES_PKG dependencies on AZ_SELECTION_SET_ENTITIES_B

Line 25: cursor C is select ROWID from AZ_SELECTION_SET_ENTITIES_B

21: X_LAST_UPDATE_DATE in DATE,
22: X_LAST_UPDATED_BY in NUMBER,
23: X_LAST_UPDATE_LOGIN in NUMBER
24: ) is
25: cursor C is select ROWID from AZ_SELECTION_SET_ENTITIES_B
26: where SELECTION_SET_CODE = X_SELECTION_SET_CODE
27: and USER_ID = X_USER_ID
28: and ENTITY_OCCURANCE_CODE = X_ENTITY_OCCURANCE_CODE
29: ;

Line 31: insert into AZ_SELECTION_SET_ENTITIES_B (

27: and USER_ID = X_USER_ID
28: and ENTITY_OCCURANCE_CODE = X_ENTITY_OCCURANCE_CODE
29: ;
30: begin
31: insert into AZ_SELECTION_SET_ENTITIES_B (
32: REF_ENTITY_OCCURANCE_CODE,
33: UPDATABLE_FLAG,
34: ALLOW_SET_TARGETVAL_FLAG,
35: ALLOW_FILTER_FLAG,

Line 138: from AZ_SELECTION_SET_ENTITIES_B

134: CHANGE_UPDATABLE_FLAG,
135: ENTITY_CODE,
136: FILTERING_PARAMETERS,
137: INCLUDE_TYPE
138: from AZ_SELECTION_SET_ENTITIES_B
139: where SELECTION_SET_CODE = X_SELECTION_SET_CODE
140: and USER_ID = X_USER_ID
141: and ENTITY_OCCURANCE_CODE = X_ENTITY_OCCURANCE_CODE
142: for update of SELECTION_SET_CODE nowait;

Line 221: update AZ_SELECTION_SET_ENTITIES_B set

217: X_LAST_UPDATED_BY in NUMBER,
218: X_LAST_UPDATE_LOGIN in NUMBER
219: ) is
220: begin
221: update AZ_SELECTION_SET_ENTITIES_B set
222: REF_ENTITY_OCCURANCE_CODE = X_REF_ENTITY_OCCURANCE_CODE,
223: UPDATABLE_FLAG = X_UPDATABLE_FLAG,
224: ALLOW_SET_TARGETVAL_FLAG = X_ALLOW_SET_TARGETVAL_FLAG,
225: ALLOW_FILTER_FLAG = X_ALLOW_FILTER_FLAG,

Line 274: delete from AZ_SELECTION_SET_ENTITIES_B

270: if (sql%notfound) then
271: raise no_data_found;
272: end if;
273:
274: delete from AZ_SELECTION_SET_ENTITIES_B
275: where SELECTION_SET_CODE = X_SELECTION_SET_CODE
276: and USER_ID = X_USER_ID
277: and ENTITY_OCCURANCE_CODE = X_ENTITY_OCCURANCE_CODE;
278:

Line 290: from AZ_SELECTION_SET_ENTITIES_B B

286: begin
287: delete from AZ_SELECTION_SET_ENTITIES_TL T
288: where not exists
289: (select NULL
290: from AZ_SELECTION_SET_ENTITIES_B B
291: where B.SELECTION_SET_CODE = T.SELECTION_SET_CODE
292: and B.USER_ID = T.USER_ID
293: and B.ENTITY_OCCURANCE_CODE = T.ENTITY_OCCURANCE_CODE
294: );

Line 409: from AZ_SELECTION_SET_ENTITIES_B

405: l_owner_id := 1;
406: end if;
407:
408: select created_by into luby
409: from AZ_SELECTION_SET_ENTITIES_B
410: where SELECTION_SET_CODE = X_SELECTION_SET_CODE
411: and USER_ID = X_USER_ID
412: and ENTITY_OCCURANCE_CODE = X_ENTITY_OCCURANCE_CODE;
413: