APPS.FRM_REP_TEMPLATE_ALIASES_PKG dependencies on FRM_REP_TEMPLATE_ALIASES_B

Line 16: cursor C is select ROWID from FRM_REP_TEMPLATE_ALIASES_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 FRM_REP_TEMPLATE_ALIASES_B
17: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
18: and CONCURRENT_PROGRAM_NAME = X_CONCURRENT_PROGRAM_NAME
19: and ELEMENT_NAME = X_ELEMENT_NAME
20: ;

Line 22: insert into FRM_REP_TEMPLATE_ALIASES_B (

18: and CONCURRENT_PROGRAM_NAME = X_CONCURRENT_PROGRAM_NAME
19: and ELEMENT_NAME = X_ELEMENT_NAME
20: ;
21: begin
22: insert into FRM_REP_TEMPLATE_ALIASES_B (
23: APPLICATION_SHORT_NAME,
24: CONCURRENT_PROGRAM_NAME,
25: ELEMENT_NAME,
26: OBJECT_VERSION_NUMBER,

Line 97: from FRM_REP_TEMPLATE_ALIASES_B

93: X_USER_NAME in VARCHAR2
94: ) is
95: cursor c is select
96: OBJECT_VERSION_NUMBER
97: from FRM_REP_TEMPLATE_ALIASES_B
98: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
99: and CONCURRENT_PROGRAM_NAME = X_CONCURRENT_PROGRAM_NAME
100: and ELEMENT_NAME = X_ELEMENT_NAME
101: for update of APPLICATION_SHORT_NAME nowait;

Line 155: update FRM_REP_TEMPLATE_ALIASES_B set

151: X_LAST_UPDATED_BY in NUMBER,
152: X_LAST_UPDATE_LOGIN in NUMBER
153: ) is
154: begin
155: update FRM_REP_TEMPLATE_ALIASES_B set
156: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
157: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
158: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
159: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 199: delete from FRM_REP_TEMPLATE_ALIASES_B

195: if (sql%notfound) then
196: raise no_data_found;
197: end if;
198:
199: delete from FRM_REP_TEMPLATE_ALIASES_B
200: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
201: and CONCURRENT_PROGRAM_NAME = X_CONCURRENT_PROGRAM_NAME
202: and ELEMENT_NAME = X_ELEMENT_NAME;
203:

Line 215: from FRM_REP_TEMPLATE_ALIASES_B B

211: begin
212: delete from FRM_REP_TEMPLATE_ALIASES_TL T
213: where not exists
214: (select NULL
215: from FRM_REP_TEMPLATE_ALIASES_B B
216: where B.APPLICATION_SHORT_NAME = T.APPLICATION_SHORT_NAME
217: and B.CONCURRENT_PROGRAM_NAME = T.CONCURRENT_PROGRAM_NAME
218: and B.ELEMENT_NAME = T.ELEMENT_NAME
219: );

Line 323: from FRM_REP_TEMPLATE_ALIASES_B

319: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
320: begin
321: select LAST_UPDATED_BY, LAST_UPDATE_DATE
322: into db_luby, db_ludate
323: from FRM_REP_TEMPLATE_ALIASES_B
324: where APPLICATION_SHORT_NAME = x_application_short_name
325: and CONCURRENT_PROGRAM_NAME = x_concurrent_program_name
326: and ELEMENT_NAME = x_element_name;
327: