APPS.FND_OAM_BF_ASSOC_CUST_PKG dependencies on FND_OAM_BF_ASSOC_CUST

Line 1: package body FND_OAM_BF_ASSOC_CUST_PKG as

1: package body FND_OAM_BF_ASSOC_CUST_PKG as
2: /* $Header: AFOAMFACB.pls 120.1 2005/07/02 03:03:16 appldev noship $ */
3: -- Module name for this package
4: MODULE constant varchar2(200) := 'fnd.plsql.FND_OAM_BF_ASSOC_CUST_PKG';
5:

Line 4: MODULE constant varchar2(200) := 'fnd.plsql.FND_OAM_BF_ASSOC_CUST_PKG';

1: package body FND_OAM_BF_ASSOC_CUST_PKG as
2: /* $Header: AFOAMFACB.pls 120.1 2005/07/02 03:03:16 appldev noship $ */
3: -- Module name for this package
4: MODULE constant varchar2(200) := 'fnd.plsql.FND_OAM_BF_ASSOC_CUST_PKG';
5:
6: --
7: -- Name
8: -- check_loop

Line 31: from fnd_oam_bf_assoc_cust a

27: v_ct_ancestors number := 0;
28: v_msg varchar2(1024) := '';
29: begin
30: select count(*) into v_ct_ancestors
31: from fnd_oam_bf_assoc_cust a
32: where a.biz_flow_parent_key = X_BIZ_FLOW_CHILD_KEY
33: start with a.biz_flow_child_key = X_BIZ_FLOW_PARENT_KEY
34: connect by prior a.biz_flow_parent_key = a.biz_flow_child_key;
35:

Line 81: FND_OAM_BF_ASSOC_CUST_pkg.LOAD_ROW (

77: X_DISPLAY_ORDER in NUMBER,
78: X_OWNER in VARCHAR2)
79: is
80: begin
81: FND_OAM_BF_ASSOC_CUST_pkg.LOAD_ROW (
82: X_BIZ_FLOW_PARENT_KEY => X_BIZ_FLOW_PARENT_KEY,
83: X_BIZ_FLOW_CHILD_KEY => X_BIZ_FLOW_CHILD_KEY,
84: X_MONITORED_FLAG => X_MONITORED_FLAG,
85: X_DISPLAY_ORDER => X_DISPLAY_ORDER,

Line 115: from FND_OAM_BF_ASSOC_CUST

111:
112: begin
113: select LAST_UPDATED_BY, LAST_UPDATE_DATE
114: into db_luby, db_ludate
115: from FND_OAM_BF_ASSOC_CUST
116: where biz_flow_parent_key = X_BIZ_FLOW_PARENT_KEY
117: and biz_flow_child_key = X_BIZ_FLOW_CHILD_KEY;
118:
119: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 121: FND_OAM_BF_ASSOC_CUST_pkg.UPDATE_ROW (

117: and biz_flow_child_key = X_BIZ_FLOW_CHILD_KEY;
118:
119: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
120: db_ludate, X_CUSTOM_MODE)) then
121: FND_OAM_BF_ASSOC_CUST_pkg.UPDATE_ROW (
122: X_BIZ_FLOW_PARENT_KEY => X_BIZ_FLOW_PARENT_KEY,
123: X_BIZ_FLOW_CHILD_KEY => X_BIZ_FLOW_CHILD_KEY,
124: X_MONITORED_FLAG => X_MONITORED_FLAG,
125: X_DISPLAY_ORDER => X_DISPLAY_ORDER,

Line 133: FND_OAM_BF_ASSOC_CUST_pkg.INSERT_ROW (

129: end if;
130: exception
131: when NO_DATA_FOUND then
132:
133: FND_OAM_BF_ASSOC_CUST_pkg.INSERT_ROW (
134: X_ROWID => row_id,
135: X_BIZ_FLOW_PARENT_KEY => X_BIZ_FLOW_PARENT_KEY,
136: X_BIZ_FLOW_CHILD_KEY => X_BIZ_FLOW_CHILD_KEY,
137: X_MONITORED_FLAG => X_MONITORED_FLAG,

Line 159: cursor C is select ROWID from FND_OAM_BF_ASSOC_CUST

155: X_LAST_UPDATE_DATE in DATE,
156: X_LAST_UPDATED_BY in NUMBER,
157: X_LAST_UPDATE_LOGIN in NUMBER)
158: is
159: cursor C is select ROWID from FND_OAM_BF_ASSOC_CUST
160: where BIZ_FLOW_PARENT_KEY = X_BIZ_FLOW_PARENT_KEY
161: and biz_flow_child_key = x_biz_flow_child_key;
162: begin
163: check_loop(

Line 167: insert into FND_OAM_BF_ASSOC_CUST (

163: check_loop(
164: X_BIZ_FLOW_PARENT_KEY,
165: X_BIZ_FLOW_CHILD_KEY);
166:
167: insert into FND_OAM_BF_ASSOC_CUST (
168: BIZ_FLOW_PARENT_KEY,
169: BIZ_FLOW_CHILD_KEY,
170: MONITORED_FLAG,
171: DISPLAY_ORDER,

Line 208: update FND_OAM_BF_ASSOC_CUST set

204: X_LAST_UPDATED_BY in NUMBER,
205: X_LAST_UPDATE_LOGIN in NUMBER
206: ) is
207: begin
208: update FND_OAM_BF_ASSOC_CUST 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 227: delete from FND_OAM_BF_ASSOC_CUST

223: X_BIZ_FLOW_PARENT_KEY in VARCHAR2,
224: X_BIZ_FLOW_CHILD_KEY in VARCHAR2
225: ) is
226: begin
227: delete from FND_OAM_BF_ASSOC_CUST
228: where biz_flow_parent_key = x_biz_flow_parent_key
229: and biz_flow_child_key = x_biz_flow_child_key;
230:
231: if (sql%notfound) then

Line 236: end FND_OAM_BF_ASSOC_CUST_PKG;

232: raise no_data_found;
233: end if;
234: end DELETE_ROW;
235:
236: end FND_OAM_BF_ASSOC_CUST_PKG;