1 PACKAGE JTS_CONFIG_VERSION_FLOW_PVT AUTHID CURRENT_USER as
2 /* $Header: jtsvcvfs.pls 115.2 2002/04/10 18:10:20 pkm ship $ */
3
4
5 -----------------------------------------------------------
6 -- PACKAGE
7 -- JTS_CONFIG_VERSION_FLOW_PVT
8 --
9 -- PURPOSE
10 -- Private API for Oracle Setup Online Configuration Management
11 --
12 -- PROCEDURES
13 --
14 ------------------------------------------------------------
15
16 G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTS_CONFIG_VERSION_FLOW_PVT';
17 G_FILE_NAME CONSTANT VARCHAR2(12) := 'jtsvcvfb.pls';
18
19 TYPE Version_Flow_Rec_Type IS RECORD (
20 version_id NUMBER,
21 flow_id NUMBER,
22 complete_flag VARCHAR2(1),
23 creation_date DATE,
24 created_by NUMBER(15),
25 last_update_date DATE,
26 last_updated_by NUMBER(15),
27 last_update_login NUMBER(15),
28 created_by_name VARCHAR2(100),
29 last_updated_by_name VARCHAR2(100)
30 ); -- End Record Version_Flow_Rec_Type
31
32 TYPE Version_Flow_Tbl_Type IS TABLE OF Version_Flow_Rec_Type INDEX BY BINARY_INTEGER;
33
34 -- Precondition: Complete Flag for all the parents have been set
35 -- UPDATE_COMPLETE_FLAGS have been called
36 FUNCTION GET_PERCENT_COMPLETE(p_api_version IN NUMBER,
37 p_version_id IN NUMBER) RETURN NUMBER;
38
39 -- Updates last_update_date, last_updated_by of a subflow and its
40 -- parent up to one level below the root
41 PROCEDURE UPDATE_FLOW_DETAILS(p_api_version IN NUMBER,
42 p_version_id IN NUMBER,
43 p_flow_id IN NUMBER,
44 p_complete_flag IN VARCHAR2
45 );
46
47 -- Creates Setup Summary data by getting the flow hiearchy
48 -- and inserting with the appropriate flow_id
49 PROCEDURE CREATE_VERSION_FLOWS(p_api_version IN NUMBER,
50 p_version_id IN NUMBER,
51 p_flow_hiearchy IN JTS_SETUP_FLOW_PVT.Setup_Flow_Tbl_Type);
52
53 --Deletes from jts_config_version_flows
54 PROCEDURE DELETE_VERSION_FLOWS(p_api_version IN NUMBER,
55 p_version_id IN NUMBER);
56
57
58 -- Deletes all records from jts_config_version_flows where
59 -- version_id exists for p_config_id in versions table
60 PROCEDURE DELETE_CONFIG_VERSION_FLOWS(p_api_version IN NUMBER,
61 p_config_id IN NUMBER);
62
63 -- Gets all the version flows
64 PROCEDURE GET_VERSION_FLOWS(p_api_version IN NUMBER,
65 p_version_id IN NUMBER,
66 p_flow_tbl OUT NOCOPY Version_Flow_Tbl_Type);
67
68
69 END JTS_CONFIG_VERSION_FLOW_PVT;