1 package FND_OAM_BF_ASSOC_PKG as
2 /* $Header: AFOAMFAS.pls 120.1 2005/07/02 03:03:25 appldev noship $ */
3 ROOT_KEY constant varchar2(40) := '$ROOT$';
4
5 --
6 -- Name
7 -- load_row
8 --
9 -- Purpose
10 -- Loads the association between a parent flow and a child flow
11 -- into the database. This procedure will be called by the
12 -- OAM Business Flows Definition Loader program.
13 --
14 -- Input Arguments
15 -- x_biz_flow_parent_key - parent flow key. Pass in ROOT_KEY for
16 -- flows that are top level that dont have a parent.
17 -- x_biz_flow_child_key - child flow key.
18 -- x_monitored_flag - Y/N - whether the child flow is active in
19 -- context of its parent.
20 -- x_owner - owner e.g. ORACLE
21 -- Output Arguments
22 --
23 -- Notes:
24 --
25 --
26 procedure LOAD_ROW (
27 X_BIZ_FLOW_PARENT_KEY in VARCHAR2,
28 X_BIZ_FLOW_CHILD_KEY in VARCHAR2,
29 X_MONITORED_FLAG in VARCHAR2,
30 X_DISPLAY_ORDER in NUMBER,
31 X_OWNER in VARCHAR2);
32
33 procedure LOAD_ROW (
34 X_BIZ_FLOW_PARENT_KEY in VARCHAR2,
35 X_BIZ_FLOW_CHILD_KEY in VARCHAR2,
36 X_MONITORED_FLAG in VARCHAR2,
37 X_DISPLAY_ORDER in NUMBER,
38 X_OWNER in VARCHAR2,
39 x_custom_mode in varchar2,
40 x_last_update_date in varchar2);
41
42 procedure INSERT_ROW (
43 X_ROWID in out nocopy VARCHAR2,
44 X_BIZ_FLOW_PARENT_KEY in VARCHAR2,
45 X_BIZ_FLOW_CHILD_KEY in VARCHAR2,
46 X_MONITORED_FLAG in VARCHAR2,
47 X_DISPLAY_ORDER in NUMBER,
48 X_CREATION_DATE in DATE,
49 X_CREATED_BY in NUMBER,
50 X_LAST_UPDATE_DATE in DATE,
51 X_LAST_UPDATED_BY in NUMBER,
52 X_LAST_UPDATE_LOGIN in NUMBER);
53
54 procedure UPDATE_ROW (
55 X_BIZ_FLOW_PARENT_KEY in VARCHAR2,
56 X_BIZ_FLOW_CHILD_KEY in VARCHAR2,
57 X_MONITORED_FLAG in VARCHAR2,
58 X_DISPLAY_ORDER in NUMBER,
59 X_LAST_UPDATE_DATE in DATE,
60 X_LAST_UPDATED_BY in NUMBER,
61 X_LAST_UPDATE_LOGIN in NUMBER
62 );
63 procedure DELETE_ROW (
64 X_BIZ_FLOW_PARENT_KEY in VARCHAR2,
65 X_BIZ_FLOW_CHILD_KEY in VARCHAR2
66 );
67
68 end FND_OAM_BF_ASSOC_PKG;