1 PACKAGE JTS_SETUP_FLOW_HIEARCHY_PKG AUTHID CURRENT_USER as
2 /* $Header: jtstcsfs.pls 115.2 2002/06/07 11:53:19 pkm ship $ */
3
4
5 -----------------------------------------------------------
6 -- PACKAGE
7 -- JTS_SETUP_FLOW_HIEARCHY_PKG
8 --
9 -- PURPOSE
10 -- Private API for Oracle Setup Online Configuration Management
11 --
12 -- PROCEDURES
13 -- DELETE_ROW(varchar2)
14 -- DELETE_ROW(NUMBER)
15 -- LOAD_ROW
16 -- TRANSLATE_ROW
17 -- In body: INSERT_ROW
18 -- UPDATE_ROW
19 ------------------------------------------------------------
20
21 G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTS_SETUP_FLOW_HIEARCHY_PKG';
22 G_FILE_NAME CONSTANT VARCHAR2(12) := 'jtstcsfb.pls';
23
24 -------------------------------------------------
25 -- This is for seeding the Flow hiearchy.
26 -- Deletes a flow based on flow_code
27 -------------------------------------------------
28 PROCEDURE DELETE_ROW(p_flow_code IN VARCHAR2);
29
30 -------------------------------------------------
31 -- This is for seeding the Flow hiearchy.
32 -- Deletes a flow based on flow_id
33 -------------------------------------------------
34 PROCEDURE DELETE_ROW(p_flow_id IN NUMBER);
35
36 -------------------------------------------------
37 -- This is for seeding the Flow hiearchy.
38 --
39 -- Translates the flow name
40 -------------------------------------------------
41 PROCEDURE TRANSLATE_ROW (
42 p_flow_code IN VARCHAR2,
43 p_owner IN VARCHAR2,
44 p_flow_name IN VARCHAR2
45 );
46
47 -------------------------------------------------y
48 -- This is for seeding the Flow hiearchy.
49 --
50 -- Uploads a flow
51 -- If p_flow_id is not NULL and there is no flow with
52 -- such flow_id in the database, then a new flow_id will be used
53 -------------------------------------------------
54 PROCEDURE LOAD_ROW (
55 P_FLOW_CODE IN VARCHAR2,
56 P_OWNER IN VARCHAR2,
57 p_flow_type IN VARCHAR2,
58 p_parent_code IN VARCHAR2,
59 p_has_child_flag IN VARCHAR2,
60 p_flow_sequence IN NUMBER,
61 p_num_steps IN NUMBER,
62 P_OVERVIEW_URL in VARCHAR2,
63 P_DIAGNOSTICS_URL in VARCHAR2,
64 P_DPF_CODE in VARCHAR2,
65 P_DPF_ASN in VARCHAR2,
66 P_FLOW_NAME IN VARCHAR2
67 );
68
69 procedure LOCK_ROW (
70 X_FLOW_ID in NUMBER,
71 X_FLOW_CODE in VARCHAR2,
72 X_FLOW_TYPE in VARCHAR2,
73 X_PARENT_ID in NUMBER,
74 X_HAS_CHILD_FLAG in VARCHAR2,
75 X_FLOW_SEQUENCE in NUMBER,
76 X_OVERVIEW_URL in VARCHAR2,
77 X_DIAGNOSTICS_URL in VARCHAR2,
78 X_DPF_CODE in VARCHAR2,
79 X_DPF_ASN in VARCHAR2,
80 X_NUM_STEPS in NUMBER,
81 X_SECURITY_GROUP_ID in NUMBER,
82 X_OBJECT_VERSION_NUMBER in NUMBER,
83 X_FLOW_NAME in VARCHAR2
84 );
85
86 procedure ADD_LANGUAGE;
87
88 END JTS_SETUP_FLOW_HIEARCHY_PKG;