APPS.FRM_GLB_TEMPLATE_ALIASES_PKG dependencies on FRM_GLB_TEMPLATE_ALIASES_B

Line 14: cursor C is select ROWID from FRM_GLB_TEMPLATE_ALIASES_B

10: X_LAST_UPDATE_DATE in DATE,
11: X_LAST_UPDATED_BY in NUMBER,
12: X_LAST_UPDATE_LOGIN in NUMBER
13: ) is
14: cursor C is select ROWID from FRM_GLB_TEMPLATE_ALIASES_B
15: where ELEMENT_NAME = X_ELEMENT_NAME
16: ;
17: begin
18: insert into FRM_GLB_TEMPLATE_ALIASES_B (

Line 18: insert into FRM_GLB_TEMPLATE_ALIASES_B (

14: cursor C is select ROWID from FRM_GLB_TEMPLATE_ALIASES_B
15: where ELEMENT_NAME = X_ELEMENT_NAME
16: ;
17: begin
18: insert into FRM_GLB_TEMPLATE_ALIASES_B (
19: ELEMENT_NAME,
20: OBJECT_VERSION_NUMBER,
21: CREATION_DATE,
22: CREATED_BY,

Line 81: from FRM_GLB_TEMPLATE_ALIASES_B

77: X_USER_NAME in VARCHAR2
78: ) is
79: cursor c is select
80: OBJECT_VERSION_NUMBER
81: from FRM_GLB_TEMPLATE_ALIASES_B
82: where ELEMENT_NAME = X_ELEMENT_NAME
83: for update of ELEMENT_NAME nowait;
84: recinfo c%rowtype;
85:

Line 133: update FRM_GLB_TEMPLATE_ALIASES_B set

129: X_LAST_UPDATED_BY in NUMBER,
130: X_LAST_UPDATE_LOGIN in NUMBER
131: ) is
132: begin
133: update FRM_GLB_TEMPLATE_ALIASES_B set
134: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
135: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
136: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
137: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 169: delete from FRM_GLB_TEMPLATE_ALIASES_B

165: if (sql%notfound) then
166: raise no_data_found;
167: end if;
168:
169: delete from FRM_GLB_TEMPLATE_ALIASES_B
170: where ELEMENT_NAME = X_ELEMENT_NAME;
171:
172: if (sql%notfound) then
173: raise no_data_found;

Line 183: from FRM_GLB_TEMPLATE_ALIASES_B B

179: begin
180: delete from FRM_GLB_TEMPLATE_ALIASES_TL T
181: where not exists
182: (select NULL
183: from FRM_GLB_TEMPLATE_ALIASES_B B
184: where B.ELEMENT_NAME = T.ELEMENT_NAME
185: );
186:
187: update FRM_GLB_TEMPLATE_ALIASES_TL T set (

Line 273: from FRM_GLB_TEMPLATE_ALIASES_B

269: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
270: begin
271: select LAST_UPDATED_BY, LAST_UPDATE_DATE
272: into db_luby, db_ludate
273: from FRM_GLB_TEMPLATE_ALIASES_B
274: where ELEMENT_NAME = x_element_name;
275:
276: -- Test for customization and version
277: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,