1 PACKAGE EGO_IMPORT_UTIL_PVT AUTHID CURRENT_USER AS
2 /* $Header: EGOVIMUS.pls 120.14 2011/07/14 11:48:09 nendrapu ship $ */
3
4 PROCEDURE Propagate_Item_Num_To_Child (
5 p_batch_id NUMBER
6 , p_ss_id NUMBER
7 , p_ss_ref VARCHAR2
8 , p_old_item_number VARCHAR2
9 , p_item_number VARCHAR2
10 );
11
12 /* Function to do the preprocessing of Import
13 * This method is called from Concurrent Program
14 * and then, this method internally calls the
15 * various defaulting/copy APIs that are needed
16 * for preprocessing
17 */
18 PROCEDURE Preprocess_Import(retcode OUT NOCOPY VARCHAR2,
19 errbuf OUT NOCOPY VARCHAR2,
20 p_batch_id NUMBER);
21
22 /*
23 * This API does the defaulting of Org Assignments
24 * from Style to SKU and from SKU to Style
25 */
26 PROCEDURE Default_Org_Assignments( retcode OUT NOCOPY VARCHAR2,
27 errbuf OUT NOCOPY VARCHAR2,
28 p_batch_id NUMBER
29 );
30
31 /*
32 * This method does the defaulting of Item people
33 */
34 PROCEDURE Default_Item_People( retcode OUT NOCOPY VARCHAR2,
35 errbuf OUT NOCOPY VARCHAR2,
36 p_batch_id NUMBER
37 );
38
39 /*
40 * This method copies Item people from style to SKU (that are newly added to style) directly into the Procudution table
41 */
42 PROCEDURE Copy_Item_People_From_Style( retcode OUT NOCOPY VARCHAR2,
43 errbuf OUT NOCOPY VARCHAR2,
44 p_batch_id NUMBER
45 );
46
47 /*
48 * This API Marks all the records to process_flag 10 in all interface tables
49 * to disable SKUs for processing, and marks process_flag to 1
50 * to enable SKUs for processing
51 */
52 PROCEDURE Enable_Disable_SKU_Processing( retcode OUT NOCOPY VARCHAR2,
53 errbuf OUT NOCOPY VARCHAR2,
54 p_batch_id NUMBER,
55 p_enable_sku_processing VARCHAR2, /* T - TRUE / F - FALSE */
56 x_skus_to_process OUT NOCOPY VARCHAR2 -- Bug 9678667
57 );
58
59 /*
60 * This method copies the LC Project
61 */
62 PROCEDURE Copy_LC_Projects( retcode OUT NOCOPY VARCHAR2,
63 errbuf OUT NOCOPY VARCHAR2,
64 p_batch_id NUMBER
65 );
66
67 PROCEDURE Process_Import_Copy_Options
68 ( p_api_version IN NUMBER
69 , p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE
70 , p_batch_id IN NUMBER
71 , p_copy_option IN VARCHAR2
72 , p_template_name IN VARCHAR2
73 , p_template_sequence IN NUMBER
74 , p_selection_flag IN VARCHAR2
75 , x_return_status OUT NOCOPY VARCHAR2
76 , x_msg_count OUT NOCOPY NUMBER
77 , x_msg_data OUT NOCOPY VARCHAR2
78 );
79
80 PROCEDURE Process_Variant_Attrs
81 ( p_api_version IN NUMBER
82 , p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE
83 , p_batch_id IN NUMBER
84 , p_item_number IN VARCHAR2
85 , p_organization_id IN NUMBER
86 , p_attr_group_type IN VARCHAR2
87 , p_attr_group_name IN VARCHAR2
88 , p_attr_name IN VARCHAR2
89 , p_data_level_name IN VARCHAR2
90 , p_attr_value_num IN NUMBER
91 , p_attr_value_str IN VARCHAR2
92 , p_attr_value_date IN DATE
93 , x_return_status OUT NOCOPY VARCHAR2
94 , x_msg_count OUT NOCOPY NUMBER
95 , x_msg_data OUT NOCOPY VARCHAR2
96 );
97
98 PROCEDURE Get_Interface_Errors(
99 p_batch_id IN NUMBER,
100 x_item_err_table OUT NOCOPY EGO_VARCHAR_TBL_TYPE,
101 x_rev_err_table OUT NOCOPY EGO_VARCHAR_TBL_TYPE,
102 x_uda_err_table OUT NOCOPY EGO_VARCHAR_TBL_TYPE
103 );
104
105 /*
106 * This method will stale out all the rows in batch
107 * that are not latest for enabled_for_data_pool batches
108 */
109 PROCEDURE Validate_Timestamp_In_Batch(retcode OUT NOCOPY VARCHAR2,
110 errbuf OUT NOCOPY VARCHAR2,
111 p_batch_id IN NUMBER);
112
113 PROCEDURE Update_Timestamp_In_Prod(retcode OUT NOCOPY VARCHAR2,
114 errbuf OUT NOCOPY VARCHAR2,
115 p_batch_id IN NUMBER);
116
117 PROCEDURE Copy_Attachments ( retcode OUT NOCOPY VARCHAR2,
118 errbuf OUT NOCOPY VARCHAR2,
119 p_batch_id IN NUMBER );
120
121 /*
122 * This method is called at the end of import processing.
123 * If any SKUs are created in EGO_SKU_VARIANT_ATTR_USAGES table
124 * but corresponding variant attributes are not present in
125 * production table, then delete that entry.
126 */
127 PROCEDURE Clean_Dirty_SKUs( retcode OUT NOCOPY VARCHAR2,
128 errbuf OUT NOCOPY VARCHAR2,
129 p_batch_id IN NUMBER );
130
131 PROCEDURE check_for_duplicates(p_batch_id IN NUMBER,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE);
132
133 /* Fix for bug#9336604 Change: */
134 PROCEDURE INSERT_FUN_GEN_SETUP_UDAS( p_batch_id IN NUMBER);
135 /* Fix for bug#9336604 Change: */
136
137 -- Bug 8442016 set procedure Call_UDA_Apply_Template as public for reusing it in other API package
138 PROCEDURE Call_UDA_Apply_Template
139 ( p_batch_id IN NUMBER,
140 p_entity_sql IN VARCHAR2,
141 p_gdsn_entity_sql IN VARCHAR2,
142 p_user_id IN NUMBER,
143 p_login_id IN NUMBER,
144 p_prog_appid IN NUMBER,
145 p_prog_id IN NUMBER,
146 p_request_id IN NUMBER,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_err_msg OUT NOCOPY VARCHAR2
149 );
150
151 -- Bug 9959169 : Making this procedure public and added a new parameter
152 PROCEDURE Do_AGLevel_UDA_Defaulting( p_batch_id NUMBER,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_err_msg OUT NOCOPY VARCHAR2,
155 p_msii_miri_process_flag IN NUMBER DEFAULT 1
156 );
157
158 -- Bug 10263673 : Added the below procedure spec to make it public.
159 PROCEDURE Process_Copy_Options_For_UDAs( retcode OUT NOCOPY VARCHAR2,
160 errbuf OUT NOCOPY VARCHAR2,
161 p_batch_id NUMBER,
162 p_copy_options_exist VARCHAR2
163 );
164
165 -- Bug 12635842 : Making the below procedure as public for reusing it in other APIs.
166 PROCEDURE Default_Child_Entities( retcode OUT NOCOPY VARCHAR2
167 ,errbuf OUT NOCOPY VARCHAR2
168 ,p_batch_id NUMBER
169 ,p_msii_miri_process_flag IN NUMBER DEFAULT 1
170 );
171
172 END EGO_IMPORT_UTIL_PVT;