APPS.AZ_TAXONOMIES_PKG dependencies on AZ_TAXONOMIES_B

Line 16: cursor C is select ROWID from AZ_TAXONOMIES_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_TAXONOMIES_B
17: where TAXONOMY_CODE = X_TAXONOMY_CODE
18: and USER_ID = X_USER_ID ;
19:
20: begin

Line 21: insert into AZ_TAXONOMIES_B (

17: where TAXONOMY_CODE = X_TAXONOMY_CODE
18: and USER_ID = X_USER_ID ;
19:
20: begin
21: insert into AZ_TAXONOMIES_B (
22: TAXONOMY_CODE,
23: USER_ID ,
24: ENABLED_FLAG,
25: CREATION_DATE,

Line 96: update AZ_TAXONOMIES_B set

92: X_LAST_UPDATED_BY in NUMBER,
93: X_LAST_UPDATE_LOGIN in NUMBER
94: ) is
95: begin
96: update AZ_TAXONOMIES_B set
97: ENABLED_FLAG = X_ENABLED_FLAG,
98: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
99: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
100: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 137: delete from AZ_TAXONOMIES_B

133: if (sql%notfound) then
134: raise no_data_found;
135: end if;
136:
137: delete from AZ_TAXONOMIES_B
138: where TAXONOMY_CODE = X_TAXONOMY_CODE
139: and USER_ID = X_USER_ID;
140:
141: if (sql%notfound) then

Line 152: from AZ_TAXONOMIES_B B

148: begin
149: delete from AZ_TAXONOMIES_TL T
150: where not exists
151: (select NULL
152: from AZ_TAXONOMIES_B B
153: where B.TAXONOMY_CODE = T.TAXONOMY_CODE
154: and B.USER_ID = T.USER_ID
155: );
156:

Line 258: from AZ_TAXONOMIES_B

254: l_owner_id := 1;
255: end if;
256:
257: select last_updated_by into luby
258: from AZ_TAXONOMIES_B
259: where TAXONOMY_CODE = X_TAXONOMY_CODE
260: and USER_ID = X_USER_ID;
261:
262: if (luby = 1) then