APPS.AZ_STRUCTURE_APIS_PKG dependencies on AZ_STRUCTURE_APIS_B

Line 18: cursor C is select ROWID from AZ_STRUCTURE_APIS_B

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from AZ_STRUCTURE_APIS_B
19: where STRUCTURE_CODE = X_STRUCTURE_CODE
20: and ENTITY_CODE = X_ENTITY_CODE
21: ;
22: begin

Line 23: insert into AZ_STRUCTURE_APIS_B (

19: where STRUCTURE_CODE = X_STRUCTURE_CODE
20: and ENTITY_CODE = X_ENTITY_CODE
21: ;
22: begin
23: insert into AZ_STRUCTURE_APIS_B (
24: PARENT_ENTITY_CODE,
25: FILTERING_PARAMETER,
26: DISPLAY_RECORDS_FLAG,
27: STRUCTURE_CODE,

Line 104: from AZ_STRUCTURE_APIS_B

100: PARENT_ENTITY_CODE,
101: FILTERING_PARAMETER,
102: DISPLAY_RECORDS_FLAG,
103: API_CODE
104: from AZ_STRUCTURE_APIS_B
105: where STRUCTURE_CODE = X_STRUCTURE_CODE
106: and ENTITY_CODE = X_ENTITY_CODE
107: for update of STRUCTURE_CODE nowait;
108: recinfo c%rowtype;

Line 168: update AZ_STRUCTURE_APIS_B set

164: X_LAST_UPDATED_BY in NUMBER,
165: X_LAST_UPDATE_LOGIN in NUMBER
166: ) is
167: begin
168: update AZ_STRUCTURE_APIS_B set
169: PARENT_ENTITY_CODE = X_PARENT_ENTITY_CODE,
170: FILTERING_PARAMETER = X_FILTERING_PARAMETER,
171: DISPLAY_RECORDS_FLAG = X_DISPLAY_RECORDS_FLAG,
172: API_CODE = X_API_CODE,

Line 211: delete from AZ_STRUCTURE_APIS_B

207: if (sql%notfound) then
208: raise no_data_found;
209: end if;
210:
211: delete from AZ_STRUCTURE_APIS_B
212: where STRUCTURE_CODE = X_STRUCTURE_CODE
213: and ENTITY_CODE = X_ENTITY_CODE;
214:
215: if (sql%notfound) then

Line 226: from AZ_STRUCTURE_APIS_B B

222: begin
223: delete from AZ_STRUCTURE_APIS_TL T
224: where not exists
225: (select NULL
226: from AZ_STRUCTURE_APIS_B B
227: where B.STRUCTURE_CODE = T.STRUCTURE_CODE
228: and B.ENTITY_CODE = T.ENTITY_CODE
229: );
230:

Line 327: from AZ_STRUCTURE_APIS_B

323: l_owner_id := 1;
324: end if;
325:
326: select last_updated_by into luby
327: from AZ_STRUCTURE_APIS_B
328: where STRUCTURE_CODE = X_STRUCTURE_CODE
329: and ENTITY_CODE = X_ENTITY_CODE;
330:
331: IF luby = 1 THEN