DBA Data[Home] [Help]

APPS.FND_OAM_BF_COMP_PKG dependencies on FND_OAM_BF_COMP

Line 1: package body FND_OAM_BF_COMP_PKG as

1: package body FND_OAM_BF_COMP_PKG as
2: /* $Header: AFOAMFPB.pls 120.1 2005/07/02 03:03:48 appldev noship $ */
3:
4:
5: procedure LOAD_ROW (

Line 15: fnd_oam_bf_comp_pkg.LOAD_ROW(

11: X_DISPLAY_ORDER in NUMBER,
12: X_OWNER in VARCHAR2)
13: is
14: begin
15: fnd_oam_bf_comp_pkg.LOAD_ROW(
16: X_BIZ_FLOW_KEY => X_BIZ_FLOW_KEY,
17: X_COMPONENT_TYPE => X_COMPONENT_TYPE,
18: X_COMPONENT_APPL_SHORT_NAME => X_COMPONENT_APPL_SHORT_NAME,
19: X_COMPONENT_NAME => X_COMPONENT_NAME,

Line 64: fnd_oam_bf_comp_pkg.LOAD_ROW(

60: when others then
61: raise;
62: end;
63:
64: fnd_oam_bf_comp_pkg.LOAD_ROW(
65: X_BIZ_FLOW_KEY => X_BIZ_FLOW_KEY,
66: X_COMPONENT_TYPE => X_COMPONENT_TYPE,
67: X_COMPONENT_APPL_ID => v_component_appl_id,
68: X_COMPONENT_ID => v_component_id,

Line 102: from fnd_oam_bf_comp

98:
99: begin
100: select LAST_UPDATED_BY, LAST_UPDATE_DATE
101: into db_luby, db_ludate
102: from fnd_oam_bf_comp
103: where biz_flow_key = X_BIZ_FLOW_KEY
104: and component_type = x_component_type
105: and component_appl_id = x_component_appl_id
106: and component_id = x_component_id;

Line 110: fnd_oam_bf_comp_pkg.UPDATE_ROW (

106: and component_id = x_component_id;
107:
108: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
109: db_ludate, X_CUSTOM_MODE)) then
110: fnd_oam_bf_comp_pkg.UPDATE_ROW (
111: X_BIZ_FLOW_KEY => X_BIZ_FLOW_KEY,
112: X_COMPONENT_TYPE => X_COMPONENT_TYPE,
113: X_COMPONENT_APPL_ID => X_COMPONENT_APPL_ID,
114: X_COMPONENT_ID => X_COMPONENT_ID,

Line 124: fnd_oam_bf_comp_pkg.INSERT_ROW (

120: end if;
121: exception
122: when NO_DATA_FOUND then
123:
124: fnd_oam_bf_comp_pkg.INSERT_ROW (
125: X_ROWID => row_id,
126: X_BIZ_FLOW_KEY => X_BIZ_FLOW_KEY,
127: X_COMPONENT_TYPE => X_COMPONENT_TYPE,
128: X_COMPONENT_APPL_ID => X_COMPONENT_APPL_ID,

Line 154: cursor C is select ROWID from FND_OAM_BF_COMP

150: X_LAST_UPDATE_DATE in DATE,
151: X_LAST_UPDATED_BY in NUMBER,
152: X_LAST_UPDATE_LOGIN in NUMBER)
153: is
154: cursor C is select ROWID from FND_OAM_BF_COMP
155: where BIZ_FLOW_KEY = X_BIZ_FLOW_KEY
156: and component_type = x_component_type
157: and component_appl_id = x_component_appl_id
158: and component_id = x_component_id;

Line 160: insert into fnd_oam_bf_comp (

156: and component_type = x_component_type
157: and component_appl_id = x_component_appl_id
158: and component_id = x_component_id;
159: begin
160: insert into fnd_oam_bf_comp (
161: BIZ_FLOW_KEY,
162: component_type,
163: component_appl_id,
164: component_id,

Line 208: update FND_OAM_BF_COMP set

204: X_LAST_UPDATE_LOGIN in NUMBER
205: )
206: is
207: begin
208: update FND_OAM_BF_COMP set
209: monitored_flag = x_monitored_flag,
210: display_order = x_display_order,
211: last_update_date = x_last_update_date,
212: last_updated_by = x_last_updated_by,

Line 232: delete from fnd_oam_bf_comp

228: X_COMPONENT_ID in NUMBER
229: )
230: is
231: begin
232: delete from fnd_oam_bf_comp
233: where biz_flow_key = x_biz_flow_key
234: and component_type = x_component_type
235: and component_appl_id = x_component_appl_id
236: and component_id = x_component_id;

Line 271: fnd_oam_bf_comp_pkg.delete_row(

267: when others then
268: raise;
269: end;
270:
271: fnd_oam_bf_comp_pkg.delete_row(
272: X_BIZ_FLOW_KEY => X_BIZ_FLOW_KEY,
273: X_COMPONENT_TYPE => X_COMPONENT_TYPE,
274: X_COMPONENT_APPL_ID => v_component_appl_id,
275: X_COMPONENT_ID => v_component_id);

Line 278: end FND_OAM_BF_COMP_PKG;

274: X_COMPONENT_APPL_ID => v_component_appl_id,
275: X_COMPONENT_ID => v_component_id);
276: end DELETE_ROW;
277:
278: end FND_OAM_BF_COMP_PKG;