APPS.AZ_SSET_TAXONOMIES_PKG dependencies on AZ_SELECTION_SET_TAXONOMIES

Line 15: cursor C is select ROWID from AZ_SELECTION_SET_TAXONOMIES

11: X_LAST_UPDATE_DATE in DATE,
12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER
14: ) is
15: cursor C is select ROWID from AZ_SELECTION_SET_TAXONOMIES
16: where TAXONOMY_CODE = X_TAXONOMY_CODE
17: and SELECTION_SET_CODE = X_SELECTION_SET_CODE;
18:
19: begin

Line 20: insert into AZ_SELECTION_SET_TAXONOMIES (

16: where TAXONOMY_CODE = X_TAXONOMY_CODE
17: and SELECTION_SET_CODE = X_SELECTION_SET_CODE;
18:
19: begin
20: insert into AZ_SELECTION_SET_TAXONOMIES (
21: TAXONOMY_CODE,
22: SELECTION_SET_CODE,
23: SEQ_NUM,
24: ENABLED_FLAG,

Line 63: update AZ_SELECTION_SET_TAXONOMIES set

59: X_LAST_UPDATED_BY in NUMBER,
60: X_LAST_UPDATE_LOGIN in NUMBER
61: ) is
62: begin
63: update AZ_SELECTION_SET_TAXONOMIES set
64: SEQ_NUM = X_SEQ_NUM,
65: ENABLED_FLAG = X_ENABLED_FLAG,
66: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
67: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 83: delete from AZ_SELECTION_SET_TAXONOMIES

79: X_TAXONOMY_CODE in VARCHAR2,
80: X_USER_ID in NUMBER
81: ) is
82: begin
83: delete from AZ_SELECTION_SET_TAXONOMIES
84: where TAXONOMY_CODE = X_TAXONOMY_CODE;
85:
86: if (sql%notfound) then
87: raise no_data_found;

Line 104: from AZ_SELECTION_SET_TAXONOMIES

100: luby number := null;
101: begin
102:
103: select last_updated_by into luby
104: from AZ_SELECTION_SET_TAXONOMIES
105: where TAXONOMY_CODE = X_TAXONOMY_CODE
106: and SELECTION_SET_CODE = X_SELECTION_SET_CODE;
107:
108: if (luby = 1) THEN