1 PACKAGE JTS_FLOW_STEPS_PKG AUTHID CURRENT_USER as
2 /* $Header: jtstcfss.pls 115.3 2002/06/13 17:37:53 pkm ship $ */
3
4
5 -----------------------------------------------------------
6 -- PACKAGE
7 -- JTS_FLOW_STEPS_PKG
8 --
9 -- PURPOSE
10 -- Private API for Oracle Setup Online Configuration Management
11 --
12 -- PROCEDURES
13 -- DELETE_ROW(NUMBER)
14 -- TRANSLATE_ROW
15 -- LOAD_ROW
16 -- INSERT_ROW
17 -- UPDATE_ROW
18 -- LOCK_ROW
19 -- ADD_LANGUAGE
20 ------------------------------------------------------------
21
22 G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTS_FLOW_STEPS_PKG';
23 G_FILE_NAME CONSTANT VARCHAR2(12) := 'jtstcfsb.pls';
24
25 -------------------------------------------------
26 -- This is for seeding the step details.
27 -- Deletes a flow based on step_id
28 -------------------------------------------------
29 PROCEDURE DELETE_ROW(p_step_id IN NUMBER);
30
31 -------------------------------------------------
32 -- This is for seeding the step details.
33 --
34 -- Translates the step name, description, impact
35 -------------------------------------------------
36 PROCEDURE TRANSLATE_ROW (
37 p_step_id IN NUMBER,
38 p_owner IN VARCHAR2,
39 p_step_name IN VARCHAR2,
40 p_description IN VARCHAR2,
41 p_impact IN VARCHAR2
42 );
43
44 -------------------------------------------------
45 -- This is for seeding the step details.
46 --
47 -- Uploads a step
48 -- If p_step_id is not NULL and there is no step with
49 -- such step_id in the database, then a new step_id will be used
50 -------------------------------------------------
51 PROCEDURE LOAD_ROW (
52 p_setup_page IN VARCHAR2,
53 p_step_id IN NUMBER,
54 p_flow_id IN NUMBER,
55 P_OWNER IN VARCHAR2,
56 p_mandatory_flag IN VARCHAR2,
57 p_concurrent_flag IN VARCHAR2,
58 p_step_sequence IN NUMBER,
59 p_step_name IN VARCHAR2,
60 p_description IN VARCHAR2,
61 P_impact in VARCHAR2
62 );
63
64
65 ------------------------------------------------
66 -- INSERT_ROW
67 -------------------------------------------------
68 PROCEDURE INSERT_ROW(
69 p_setup_page IN VARCHAR2,
70 p_flow_id IN NUMBER,
71 p_mandatory_flag IN VARCHAR2,
72 p_concurrent_flag IN VARCHAR2,
73 p_step_sequence IN NUMBER,
74 p_step_name IN VARCHAR2,
75 p_description IN VARCHAR2,
76 p_impact IN VARCHAR2,
77 p_created_by IN NUMBER,
78 p_last_updated_by IN NUMBER,
79 p_last_update_login IN NUMBER,
80 x_step_id OUT NUMBER
81 );
82
83 -------------------------------------------------
84 -- UPDATE_ROW
85 -------------------------------------------------
86 procedure UPDATE_ROW (
87 p_setup_page IN VARCHAR2,
88 p_step_id IN NUMBER,
89 p_flow_id IN NUMBER,
90 p_mandatory_flag IN VARCHAR2,
91 p_concurrent_flag IN VARCHAR2,
92 p_step_sequence IN NUMBER,
93 p_step_name IN VARCHAR2,
94 p_description IN VARCHAR2,
95 p_impact IN VARCHAR2,
96 P_LAST_UPDATE_DATE in DATE,
97 P_LAST_UPDATED_BY in NUMBER,
98 P_LAST_UPDATE_LOGIN in NUMBER
99 );
100
101 -------------------------------------------------
102 -- LOCK_ROW procedure is required by forms.
103 -- It is automatically generated by tltblgen
104 -------------------------------------------------
105 procedure LOCK_ROW (
106 X_STEP_ID in NUMBER,
107 X_FLOW_ID in NUMBER,
108 X_MANDATORY_FLAG in VARCHAR2,
109 X_CONCURRENT_FLAG in VARCHAR2,
110 X_STEP_SEQUENCE in NUMBER,
111 X_SECURITY_GROUP_ID in NUMBER,
112 X_SETUP_PAGE in VARCHAR2,
113 X_STEP_NAME in VARCHAR2,
114 X_DESCRIPTION in VARCHAR2,
115 X_IMPACT in VARCHAR2
116 );
117
118 ---------------------------------------------------
119 -- ADD_LANGUAGE procedure is used to restore data integrity
120 -- to a corrupted base/translation pair.
121 -- It is also automatically generated.
122 ---------------------------------------------------
123 procedure ADD_LANGUAGE;
124
125 END JTS_FLOW_STEPS_PKG;