1 PACKAGE GMD_PROCESS_INSTR_UTILS AUTHID CURRENT_USER AS
2 /* $Header: GMDPIUTS.pls 120.4 2006/07/12 18:07:28 txdaniel noship $ */
3
4 /*-------------------------------------------------------------------
5 -- NAME
6 -- Build_Array
7 --
8 -- SYNOPSIS
9 -- Procedure Build_Array
10 --
11 -- DESCRIPTION
12 -- This procedure is used to build the array to pass to GMO
13 --
14 -- HISTORY
15 --
16 --------------------------------------------------------------------*/
17
18 PROCEDURE Build_Array (
19 p_entity_name IN VARCHAR2 ,
20 p_entity_id IN NUMBER ,
21 x_name_array OUT NOCOPY GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
22 x_key_array OUT NOCOPY GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
23 x_return_status OUT NOCOPY VARCHAR2);
24
25 /*-------------------------------------------------------------------
26 -- NAME
27 -- Copy_Process_Instructions
28 --
29 -- SYNOPSIS
30 -- Procedure Copy_Process_Instructions
31 --
32 -- DESCRIPTION
33 -- This procedure is called to copy the process instructions from
34 -- one entity to another
35 --
36 -- HISTORY
37 --------------------------------------------------------------------*/
38
39 PROCEDURE Copy_Process_Instructions (
40 p_source_name_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
41 p_source_key_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
42 p_target_name_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
43 p_target_key_array IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
44 x_return_status OUT NOCOPY VARCHAR2);
45
46
47 /*-------------------------------------------------------------------
48 -- NAME
49 -- COPY_PROCESS_INSTR
50 --
51 -- SYNOPSIS
52 -- Procedure COPY_PROCESS_INSTR
53 --
54 -- DESCRIPTION
55 -- This procedure is called to copy the process instructions from
56 -- one entity to another
57 --
58 -- HISTORY
59 -- Sriram 7/20/2005 Created for GMD-GMO Integration Build
60 --------------------------------------------------------------------*/
61
62 PROCEDURE COPY_PROCESS_INSTR (
63 p_entity_name IN VARCHAR2 ,
64 p_from_entity_id IN NUMBER ,
65 p_to_entity_id IN NUMBER ,
66 x_return_status OUT NOCOPY VARCHAR2 ,
67 x_msg_count OUT NOCOPY NUMBER ,
68 x_msg_data OUT NOCOPY VARCHAR2 );
69
70
71 /*-------------------------------------------------------------------
72 -- NAME
73 -- COPY_PROCESS_INSTR
74 --
75 -- SYNOPSIS
76 -- Procedure COPY_PROCESS_INSTR
77 --
78 -- DESCRIPTION
79 -- This procedure is called to copy the process instructions from
80 -- child entities to parent entity
81 --
82 -- E.g When a reciipe is created, copy the PI's defined at routing and
83 -- formula level to recipe-routing and recipe-formula level
84 --
85 -- When a routing is created, copy the PI's defined at operation level to the
86 -- routing-operation level
87 --
88 -- HISTORY
89 -- Sriram 7/20/2005 Created for GMD-GMO Integration Build
90 --------------------------------------------------------------------*/
91
92 PROCEDURE COPY_PROCESS_INSTR (
93 p_entity_name IN VARCHAR2 ,
94 p_entity_id IN NUMBER ,
95 x_return_status OUT NOCOPY VARCHAR2 ,
96 x_msg_count OUT NOCOPY NUMBER ,
97 x_msg_data OUT NOCOPY VARCHAR2 );
98
99 /*-----------------------------------------------------------------------------
100 -- NAME
101 -- COPY_PROCESS_INSTR_ROW
102 --
103 -- SYNOPSIS
104 -- Procedure COPY_PROCESS_INSTR_ROW
105 --
106 -- DESCRIPTION
107 -- This procedure is called to copy the process instructions of a single from
108 -- child entity to a parent entity
109 --
110 -- When a routing is updated by adding an operation, copy the PI's defined at
111 -- operation level to the routing-operation level
112 --
113 -- HISTORY
114 -- Kapil M 18-MAY-2006 Bug# 5173039
115 --------------------------------------------------------------------------------*/
116
117
118 PROCEDURE COPY_PROCESS_INSTR_ROW (
119 p_entity_name IN VARCHAR2 ,
120 p_entity_id IN NUMBER ,
121 x_return_status OUT NOCOPY VARCHAR2 ,
122 x_msg_count OUT NOCOPY NUMBER ,
123 x_msg_data OUT NOCOPY VARCHAR2 );
124
125
126 /*-------------------------------------------------------------------
127 -- NAME
128 -- SEND_PI_ACKN
129 --
130 -- SYNOPSIS
131 -- Procedure SEND_PI_ACKN
132 --
133 -- DESCRIPTION
134 -- This procedure is called to send acknowledgment to the PI framework
135 -- if version contrl is ON. The source and entity names and keys needs to
136 -- passed to copy the pending (current) changes from old entity to new entity.
137 --
138 --
139 -- HISTORY
140 -- Sriram 7/20/2005 Created for GMD-GMO Integration Build
141 --------------------------------------------------------------------*/
142
143 PROCEDURE SEND_PI_ACKN(
144 p_entity_name IN VARCHAR2 ,
145 p_INSTRUCTION_PROCESS_ID IN NUMBER ,
146 p_old_entity_id IN NUMBER ,
147 p_new_entity_id IN NUMBER ,
148 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
149 X_MSG_COUNT OUT NOCOPY NUMBER ,
150 X_MSG_DATA OUT NOCOPY VARCHAR2 );
151
152 --API related Designer.
153 p_recipe_instr_process_id NUMBER;
154 p_formula_instr_process_id NUMBER;
155 p_routing_instr_process_id NUMBER;
156 p_setp_instr_process_id NUMBER;
157 PROCEDURE DESG_SEND_PI_ACKN(p_return_status OUT NOCOPY VARCHAR2);
158 FUNCTION GET_DESG_INVOKE_PI_ID(p_entity_type VARCHAR2)
159 RETURN NUMBER;
160 PROCEDURE SET_DESG_INVOKE_PI_ID(p_entity_type VARCHAR2,
161 p_pi_entity_id NUMBER);
162 PROCEDURE DESG_SEND_VER_PI_ACKN(p_from_recipe_id IN VARCHAR2,
163 p_from_formula_id IN VARCHAR2,
164 p_from_routing_id IN VARCHAR2,
165 p_to_recipe_id IN VARCHAR2,
166 p_return_status OUT NOCOPY VARCHAR2);
167
168 END GMD_PROCESS_INSTR_UTILS;
169