APPS.FND_OAM_BF_WIT_PKG dependencies on FND_OAM_BF_WIT

Line 1: package body FND_OAM_BF_WIT_PKG as

1: package body FND_OAM_BF_WIT_PKG as
2: /* $Header: AFOAMFWB.pls 120.1 2005/07/02 03:04:11 appldev noship $ */
3:
4:
5: procedure LOAD_ROW (

Line 13: fnd_oam_bf_wit_pkg.LOAD_ROW (

9: X_DISPLAY_ORDER in NUMBER,
10: X_OWNER in VARCHAR2)
11: is
12: begin
13: fnd_oam_bf_wit_pkg.LOAD_ROW (
14: X_BIZ_FLOW_KEY => X_BIZ_FLOW_KEY,
15: X_ITEM_TYPE => X_ITEM_TYPE,
16: X_MONITORED_FLAG => X_MONITORED_FLAG,
17: X_DISPLAY_ORDER => X_DISPLAY_ORDER,

Line 47: from fnd_oam_bf_wit

43:
44: begin
45: select LAST_UPDATED_BY, LAST_UPDATE_DATE
46: into db_luby, db_ludate
47: from fnd_oam_bf_wit
48: where biz_flow_key = X_BIZ_FLOW_KEY
49: and item_type = X_ITEM_TYPE;
50:
51: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 53: fnd_oam_bf_wit_pkg.UPDATE_ROW (

49: and item_type = X_ITEM_TYPE;
50:
51: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
52: db_ludate, X_CUSTOM_MODE)) then
53: fnd_oam_bf_wit_pkg.UPDATE_ROW (
54: X_BIZ_FLOW_KEY => X_BIZ_FLOW_KEY,
55: X_ITEM_TYPE => X_ITEM_TYPE,
56: X_MONITORED_FLAG => X_MONITORED_FLAG,
57: X_DISPLAY_ORDER => X_DISPLAY_ORDER,

Line 65: fnd_oam_bf_wit_pkg.INSERT_ROW (

61: end if;
62: exception
63: when NO_DATA_FOUND then
64:
65: fnd_oam_bf_wit_pkg.INSERT_ROW (
66: X_ROWID => row_id,
67: X_BIZ_FLOW_KEY => X_BIZ_FLOW_KEY,
68: X_ITEM_TYPE => X_ITEM_TYPE,
69: X_MONITORED_FLAG => X_MONITORED_FLAG,

Line 91: cursor C is select ROWID from FND_OAM_BF_WIT

87: X_LAST_UPDATE_DATE in DATE,
88: X_LAST_UPDATED_BY in NUMBER,
89: X_LAST_UPDATE_LOGIN in NUMBER)
90: is
91: cursor C is select ROWID from FND_OAM_BF_WIT
92: where BIZ_FLOW_KEY = X_BIZ_FLOW_KEY
93: and item_type = X_ITEM_TYPE;
94: begin
95: insert into fnd_oam_bf_wit (

Line 95: insert into fnd_oam_bf_wit (

91: cursor C is select ROWID from FND_OAM_BF_WIT
92: where BIZ_FLOW_KEY = X_BIZ_FLOW_KEY
93: and item_type = X_ITEM_TYPE;
94: begin
95: insert into fnd_oam_bf_wit (
96: BIZ_FLOW_KEY,
97: ITEM_TYPE,
98: MONITORED_FLAG,
99: DISPLAY_ORDER,

Line 136: update FND_OAM_BF_WIT set

132: X_LAST_UPDATED_BY in NUMBER,
133: X_LAST_UPDATE_LOGIN in NUMBER
134: ) is
135: begin
136: update FND_OAM_BF_WIT set
137: monitored_flag = x_monitored_flag,
138: display_order = x_display_order,
139: last_update_date = x_last_update_date,
140: last_updated_by = x_last_updated_by,

Line 155: delete from fnd_oam_bf_wit

151: X_BIZ_FLOW_KEY in VARCHAR2,
152: X_ITEM_TYPE in VARCHAR2
153: ) is
154: begin
155: delete from fnd_oam_bf_wit
156: where biz_flow_key = X_BIZ_FLOW_KEY
157: and item_type = X_ITEM_TYPE;
158:
159: if (sql%notfound) then

Line 164: end FND_OAM_BF_WIT_PKG;

160: raise no_data_found;
161: end if;
162: end DELETE_ROW;
163:
164: end FND_OAM_BF_WIT_PKG;