APPS.AZ_STRUCTURES_PKG dependencies on AZ_STRUCTURES_B

Line 16: cursor C is select ROWID from AZ_STRUCTURES_B

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from AZ_STRUCTURES_B
17: where STRUCTURE_CODE = X_STRUCTURE_CODE
18: ;
19: begin
20: insert into AZ_STRUCTURES_B (

Line 20: insert into AZ_STRUCTURES_B (

16: cursor C is select ROWID from AZ_STRUCTURES_B
17: where STRUCTURE_CODE = X_STRUCTURE_CODE
18: ;
19: begin
20: insert into AZ_STRUCTURES_B (
21: STRUCTURE_CODE,
22: HIERARCHICAL_FLAG,
23: ACTIVE,
24: CREATION_DATE,

Line 88: from AZ_STRUCTURES_B

84: X_STRUCTURE_DESC in VARCHAR2
85: ) is
86: cursor c is select
87: HIERARCHICAL_FLAG
88: from AZ_STRUCTURES_B
89: where STRUCTURE_CODE = X_STRUCTURE_CODE
90: for update of STRUCTURE_CODE nowait;
91: recinfo c%rowtype;
92:

Line 146: update AZ_STRUCTURES_B set

142: X_LAST_UPDATED_BY in NUMBER,
143: X_LAST_UPDATE_LOGIN in NUMBER
144: ) is
145: begin
146: update AZ_STRUCTURES_B set
147: HIERARCHICAL_FLAG = X_HIERARCHICAL_FLAG,
148: ACTIVE = X_ACTIVE,
149: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
150: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 184: delete from AZ_STRUCTURES_B

180: if (sql%notfound) then
181: raise no_data_found;
182: end if;
183:
184: delete from AZ_STRUCTURES_B
185: where STRUCTURE_CODE = X_STRUCTURE_CODE;
186:
187: if (sql%notfound) then
188: raise no_data_found;

Line 198: from AZ_STRUCTURES_B B

194: begin
195: delete from AZ_STRUCTURES_TL T
196: where not exists
197: (select NULL
198: from AZ_STRUCTURES_B B
199: where B.STRUCTURE_CODE = T.STRUCTURE_CODE
200: );
201:
202: update AZ_STRUCTURES_TL T set (

Line 296: from AZ_STRUCTURES_B

292: l_owner_id := 1;
293: end if;
294:
295: select last_updated_by into luby
296: from AZ_STRUCTURES_B
297: where STRUCTURE_CODE = X_STRUCTURE_CODE;
298:
299: IF luby = 1 THEN
300: AZ_STRUCTURES_PKG.UPDATE_ROW(