[Home] [Help]
PACKAGE: APPS.EGO_WF_WRAPPER_PVT
Source
1 PACKAGE EGO_WF_WRAPPER_PVT AS
2 /* $Header: EGOVWFWS.pls 120.6 2007/12/28 05:45:27 pgandhik ship $ */
3
4
5
6 --=======================================================================--
7 --=*********************************************************************=--
8 --=*===================================================================*=--
9 --=*= =*=--
10 --=*= NOTE: This is a PRIVATE package; it is for internal use only, =*=--
11 --=*= and it is not supported for customer use. =*=--
12 --=*= =*=--
13 --=*===================================================================*=--
14 --=*********************************************************************=--
15 --=======================================================================--
16
17 G_AML_CHANGE_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.ego.item.postAMLChange';
18 G_ITEM_APPROVED_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.ego.item.postItemApproved';
19 G_REV_CHANGE_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.ego.item.postRevisionChange';
20 G_ITEM_UPDATE_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.ego.item.postItemUpdate';
21 G_ITEM_CREATE_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.ego.item.postItemCreate';
22 G_ITEM_CAT_ASSIGN_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.ego.item.postCatalogAssignmentChange';
23 --R12 Business Events
24 G_PRE_ATTR_CHANGE_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.ego.item.preAttributeChange';
25 G_GTIN_ATTR_CHANGE_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.ego.item.postGTINAttributeChange';
26 G_Xref_CHANGE_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.ego.item.postXrefChange';
27 G_CUST_ITEM_XREF_CHANGE_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.ego.item.postCustItemXrefChange';
28 G_REL_ITEM_CHANGE_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.ego.item.postRelatedItemChange';
29 G_DOC_ATTCH_CHANGE_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.ego.item.postDocAttachmentChange';
30 G_ITEM_ROLE_CHANGE_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.ego.item.postItemRoleChange';
31 G_VALID_CHANGE_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.ego.item.postValidCategoryChange';
32 G_ITEM_BULKLOAD_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.ego.item.postItemBulkload';
33 G_CAT_CATEGORY_CHANGE_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.ego.item.postCatalogCategoryChange';
34 --R12 Business Events
35 G_POST_PROCESS_MESSAGE_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.ego.orchestration.postProcessMessage';
36
37 ----------------
38 -- Procedures --
39 ----------------
40
41 PROCEDURE Raise_WF_Business_Event (
42 p_event_name IN VARCHAR2
43 ,p_event_key IN VARCHAR2
44 ,p_pre_event_flag IN VARCHAR2 DEFAULT NULL --Not null when used to raise pre event
45 ,p_request_id IN VARCHAR2 DEFAULT NULL
46 ,p_dml_type IN VARCHAR2 DEFAULT NULL
47 ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
48 ,p_extension_id IN NUMBER DEFAULT NULL
49 ,p_primary_key_1_col_name IN VARCHAR2 DEFAULT NULL
50 ,p_primary_key_1_value IN VARCHAR2 DEFAULT NULL
51 ,p_primary_key_2_col_name IN VARCHAR2 DEFAULT NULL
52 ,p_primary_key_2_value IN VARCHAR2 DEFAULT NULL
53 ,p_primary_key_3_col_name IN VARCHAR2 DEFAULT NULL
54 ,p_primary_key_3_value IN VARCHAR2 DEFAULT NULL
55 ,p_primary_key_4_col_name IN VARCHAR2 DEFAULT NULL
56 ,p_primary_key_4_value IN VARCHAR2 DEFAULT NULL
57 ,p_primary_key_5_col_name IN VARCHAR2 DEFAULT NULL
58 ,p_primary_key_5_value IN VARCHAR2 DEFAULT NULL
59 ,p_data_level_id IN NUMBER DEFAULT NULL
60 ,p_data_level_1_col_name IN VARCHAR2 DEFAULT NULL
61 ,p_data_level_1_value IN VARCHAR2 DEFAULT NULL
62 ,p_data_level_2_col_name IN VARCHAR2 DEFAULT NULL
63 ,p_data_level_2_value IN VARCHAR2 DEFAULT NULL
64 ,p_data_level_3_col_name IN VARCHAR2 DEFAULT NULL
65 ,p_data_level_3_value IN VARCHAR2 DEFAULT NULL
66 ,p_data_level_4_col_name IN VARCHAR2 DEFAULT NULL
67 ,p_data_level_4_value IN VARCHAR2 DEFAULT NULL
68 ,p_data_level_5_col_name IN VARCHAR2 DEFAULT NULL
69 ,p_data_level_5_value IN VARCHAR2 DEFAULT NULL
70 ,p_user_row_identifier IN VARCHAR2 DEFAULT NULL
71 ,p_attr_name_val_tbl IN EGO_ATTR_TABLE DEFAULT NULL
72 ,p_entity_id IN VARCHAR2 DEFAULT NULL
73 ,p_entity_index IN NUMBER DEFAULT NULL
74 ,p_entity_code IN VARCHAR2 DEFAULT NULL
75 ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT NULL
76 );
77
78 PROCEDURE Raise_AML_Event(
79 p_event_name IN VARCHAR2
80 ,p_dml_type IN VARCHAR2
81 ,p_Inventory_Item_Id IN NUMBER
82 ,p_Organization_Id IN NUMBER
83 ,p_Manufacturer_Id IN NUMBER
84 ,p_Mfg_Part_Num IN VARCHAR2
85 ,x_msg_data OUT NOCOPY VARCHAR2
86 ,x_return_status OUT NOCOPY VARCHAR2
87 );
88
89 --Start : 4105841 : Business Event Enhancement
90 /*Bug 6407303 Added the new parameter*/
91 PROCEDURE Raise_Item_Create_Update_Event(
92 p_event_name IN VARCHAR2
93 ,p_request_id IN NUMBER DEFAULT NULL
94 ,p_Organization_Id IN NUMBER DEFAULT NULL
95 ,p_organization_code IN VARCHAR2 DEFAULT NULL
96 ,p_Inventory_Item_Id IN NUMBER DEFAULT NULL
97 ,p_item_number IN VARCHAR2 DEFAULT NULL
98 ,p_item_description IN VARCHAR2 DEFAULT NULL
99 ,p_is_master_attr_modified IN VARCHAR2 DEFAULT 'N'
100 ,x_msg_data OUT NOCOPY VARCHAR2
101 ,x_return_status OUT NOCOPY VARCHAR2
102 );
103
104 PROCEDURE Raise_Item_Event(
105 p_event_name IN VARCHAR2
106 ,p_dml_type IN VARCHAR2 DEFAULT NULL
107 ,p_request_id IN VARCHAR2 DEFAULT NULL
108 ,p_Inventory_Item_Id IN NUMBER DEFAULT NULL
109 ,p_Organization_Id IN NUMBER DEFAULT NULL
110 ,p_Revision_id IN NUMBER DEFAULT NULL
111 ,p_category_id IN VARCHAR2 DEFAULT NULL
112 ,p_catalog_id IN VARCHAR2 DEFAULT NULL
113 ,p_cross_reference_type IN VARCHAR2 DEFAULT NULL --r12
114 ,p_cross_reference IN VARCHAR2 DEFAULT NULL --r12
115 ,p_customer_item_id IN NUMBER DEFAULT NULL --r12
116 ,p_related_item_id IN NUMBER DEFAULT NULL --r12
117 ,p_relationship_type_id IN NUMBER DEFAULT NULL --r12
118 ,p_role_id IN NUMBER DEFAULT NULL --r12
119 ,p_party_type IN VARCHAR2 DEFAULT NULL --r12
120 ,p_party_id IN NUMBER DEFAULT NULL --r12
121 ,p_start_date IN DATE DEFAULT NULL --r12
122 ,x_msg_data OUT NOCOPY VARCHAR2
123 ,x_return_status OUT NOCOPY VARCHAR2
124 );
125 --End : 4105841 : Business Event Enhancement
126
127 --R12 Business Event Enhancement
128 PROCEDURE Raise_Categories_Event(
129 p_event_name IN VARCHAR2
130 ,p_dml_type IN VARCHAR2 DEFAULT NULL
131 ,p_category_set_id IN NUMBER DEFAULT NULL
132 ,p_category_id IN NUMBER DEFAULT NULL
133 ,p_category_name IN VARCHAR2 DEFAULT NULL
134 ,x_msg_data OUT NOCOPY VARCHAR2
135 ,x_return_status OUT NOCOPY VARCHAR2
136 );
137
138 --R12C Raise Post Process Message Event for Orchestration
139 PROCEDURE Raise_Post_Process_Msg_Event(
140 p_event_name IN VARCHAR2
141 ,p_entity_name IN VARCHAR2
142 ,p_pk1_value IN VARCHAR2
143 ,p_pk2_value IN VARCHAR2
144 ,p_pk3_value IN VARCHAR2
145 ,p_pk4_value IN VARCHAR2
146 ,p_pk5_value IN VARCHAR2
147 ,p_processing_type IN VARCHAR2
148 ,p_language_code IN VARCHAR2
149 ,p_last_update_date IN VARCHAR2 /* Date Format: DD-MON-YYYY HH24:MI:SS */
150 ,x_msg_data OUT NOCOPY VARCHAR2
151 ,x_return_status OUT NOCOPY VARCHAR2
152 );
153
154 --R12C Setters for Entity Level Business events
155 PROCEDURE Set_Item_Bulkload_Bus_Event(p_true_false IN VARCHAR2);
156 PROCEDURE Set_Rev_Change_Bus_Event(p_true_false IN VARCHAR2);
157 PROCEDURE Set_Category_Assign_Bus_Event(p_true_false IN VARCHAR2);
158 PROCEDURE Set_PostAttr_Change_Event(p_true_false IN VARCHAR2);
159 PROCEDURE Set_PostAml_Change_Event(p_true_false IN VARCHAR2);
160 PROCEDURE Set_Item_People_Event(p_true_false IN VARCHAR2);
161
162 --R12C Getters for Entity Level Business events
163 FUNCTION Get_Item_Bulkload_Bus_Event RETURN VARCHAR2;
164 FUNCTION Get_Rev_Change_Bus_Event RETURN VARCHAR2;
165 FUNCTION Get_Category_Assign_Bus_Event RETURN VARCHAR2;
166 FUNCTION Get_PostAttr_Change_Event RETURN VARCHAR2;
167 FUNCTION Get_PostAml_Change_Event RETURN VARCHAR2;
168 FUNCTION Get_Item_People_Event RETURN VARCHAR2;
169
170
171 END EGO_WF_WRAPPER_PVT;
172