[Home] [Help]
PACKAGE: APPS.JTS_SETUP_FLOW_PVT
Source
1 PACKAGE JTS_SETUP_FLOW_PVT AUTHID CURRENT_USER as
2 /* $Header: jtsvcsfs.pls 115.5 2002/04/10 18:10:15 pkm ship $ */
3
4
5 -----------------------------------------------------------
6 -- PACKAGE
7 -- JTS_SETUP_FLOW_PVT
8 --
9 -- PURPOSE
10 -- Private API for Oracle Setup Online Configuration Management
11 --
12 -- PROCEDURES
13 -- GET_PARENT_FLOW_ID
14 -- GET_FLOW_ROOT_FLOWS
15 -- GET_MODULE_ROOT_FLOWS
16 -- GET_FLOW_HIEARCHY
17 ------------------------------------------------------------
18
19 G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTS_SETUP_FLOW_PVT';
20 G_FILE_NAME CONSTANT VARCHAR2(12) := 'jtsvcsfb.pls';
21
22 C_FLOW_FLOW_TYPE CONSTANT Varchar2(30) := 'FLOW';
23 C_MODULE_FLOW_TYPE CONSTANT Varchar2(30) := 'MODULE';
24
25 -- Stores Setup Summary hiearchy
26 TYPE Setup_Flow_Rec_Type IS RECORD (
27 flow_id NUMBER,
28 flow_name VARCHAR2(80),
29 flow_code VARCHAR2(30),
30 parent_id NUMBER,
31 level NUMBER,
32 flow_sequence NUMBER,
33 overview_url VARCHAR2(240),
34 diagnostics_url VARCHAR2(240),
35 dpf_code VARCHAR2(50),
36 dpf_asn VARCHAR2(50),
37 num_steps NUMBER,
38 flow_type VARCHAR2(30),
39 has_child_flag VARCHAR2(1)
40 ); -- End Setup_Flow_Rec_Type
41
42 -- Stores Setup Summary hiearchy
43 TYPE Flow_Rec_Type IS RECORD (
44 flow_id NUMBER,
45 flow_name VARCHAR2(80),
46 flow_code VARCHAR2(30),
47 parent_id NUMBER,
48 level NUMBER,
49 flow_sequence NUMBER,
50 overview_url VARCHAR2(240),
51 diagnostics_url VARCHAR2(240),
52 dpf_code VARCHAR2(50),
53 dpf_asn VARCHAR2(50),
54 num_steps NUMBER,
55 flow_type VARCHAR2(30),
56 has_child_flag VARCHAR2(1),
57 --columns from jts_config_version_flows
58 version_id NUMBER,
59 complete_flag VARCHAR2(1),
60 creation_date DATE,
61 last_update_date DATE,
62 created_by_name VARCHAR2(100),
63 last_updated_by_name VARCHAR2(100)
64 --end columns from jts_config_version_flows
65 ); -- End Flow_Rec_Type
66
67 -- Stores Configuration Types
68 TYPE Root_Setup_Flow_Rec_Type IS RECORD (
69 flow_id NUMBER,
70 flow_name VARCHAR2(80),
71 flow_type VARCHAR2(30)
72 ); -- End Root_Setup_Flow_Rec_Type
73
74 TYPE Setup_Flow_Tbl_Type IS TABLE OF Setup_Flow_Rec_Type INDEX BY BINARY_INTEGER;
75
76 TYPE Flow_Tbl_Type IS TABLE OF Flow_Rec_Type INDEX BY BINARY_INTEGER;
77
78 TYPE Root_Setup_Flow_Tbl_Type IS TABLE OF Root_Setup_Flow_Rec_Type INDEX BY BINARY_INTEGER;
79
80 -- Returns the flow id of a flow's parent
81 FUNCTION GET_PARENT_FLOW_ID(p_flow_id IN NUMBER)
82 RETURN NUMBER;
83
84 -- Returns the flow name of a flow given a flow id
85 FUNCTION GET_FLOW_NAME(p_flow_id IN NUMBER)
86 RETURN VARCHAR2;
87
88 -- Gets Configuration Types that is a Complete Business Flow
89 PROCEDURE GET_FLOW_ROOT_FLOWS(p_api_version IN NUMBER,
90 x_flow_tbl OUT NOCOPY Root_Setup_Flow_Tbl_Type);
91
92 -- Gets Configuration Types that are indivdual modules
93 PROCEDURE GET_MODULE_ROOT_FLOWS(p_api_version IN NUMBER,
94 x_flow_tbl OUT NOCOPY Root_Setup_Flow_Tbl_Type);
95
96 -- Gets Setup Hiearchy through recursion, starting from the root
97 PROCEDURE GET_FLOW_HIEARCHY(p_api_version IN Number,
98 p_flow_id IN NUMBER,
99 x_flow_tbl OUT NOCOPY Setup_Flow_Tbl_Type);
100
101 -- Gets Setup Hiearchy and Data for each subflow through recursion, starting from the root
102 PROCEDURE GET_FLOW_DATA_HIEARCHY(p_api_version IN Number,
103 p_flow_id IN NUMBER,
104 p_version_id IN NUMBER,
105 x_flow_tbl OUT NOCOPY Flow_Tbl_Type);
106
107
108 END JTS_SETUP_FLOW_PVT;