1 PACKAGE m4u_global_regqry AUTHID CURRENT_USER AS
2 /* $Header: M4UQRRES.pls 120.0 2005/05/24 16:16:19 appldev noship $ */
3
4 -- Name
5 -- raise_regqry_event
6 -- Purpose
7 -- This procedure is called from a concurrent program.
8 -- The 'oracle.apps.m4u.registryquery.generate' is raised with the supplied event parameters
9 -- The sequence m4u_wlqid_sequence is used to obtain unique event key.
10 -- Arguments
11 -- Notes
12 --
13 PROCEDURE raise_regqry_event(
14 x_errbuf OUT NOCOPY VARCHAR2,
15 x_retcode OUT NOCOPY NUMBER,
16 p_qr_ipgln IN VARCHAR2,
17 p_qr_gtin IN VARCHAR2,
18 p_qr_targtMarkt IN VARCHAR2
19 );
20
21 -- Name
22 -- process_gtin_resp
23 -- Purpose
24 -- This procedure is called from the XGM m4u_230_resp_gbreqry_in
25 -- This procedure updates the UCCnet Registry-query collaboration with GTIN info
26 -- Arguments
27 -- RCIR Item Attributes
28 -- p_success_flag - Query success/failure flag
29 -- p_gtin_query_id - GTIN query Id
30 -- p_ucc_doc_unique_id - UCC Doc Unique ID
31 -- p_xmlg_internal_control_no - XMLG ICN from map
32 -- x_return_status - API ret status
33 -- x_msg_data - API ret msg
34 -- Notes
35 -- none
36 PROCEDURE process_gtin_resp(
37 p_gtin IN VARCHAR2,
38 p_data_source IN VARCHAR2,
39 p_target_market IN VARCHAR2,
40 p_src_data_pool IN VARCHAR2,
41 p_reg_data_pool IN VARCHAR2,
42 p_name_of_info_provider IN VARCHAR2,
43 p_brand_owner_name IN VARCHAR2,
44 p_brand_owner_gln IN VARCHAR2,
45 p_brand_name IN VARCHAR2,
46 p_trade_item_unit_desc IN VARCHAR2,
47 p_eanucc_code IN VARCHAR2,
48 p_eanucc_type IN VARCHAR2,
49 p_delivery_method IN VARCHAR2,
50 p_consumer_unit IN VARCHAR2,
51 p_ord_unit IN VARCHAR2,
52 p_effective_date IN VARCHAR2,
53 p_next_level_cnt IN VARCHAR2,
54 p_gross_wt IN VARCHAR2,
55 p_gross_wt_uom IN VARCHAR2,
56 p_height IN VARCHAR2,
57 p_height_uom IN VARCHAR2,
58 p_width IN VARCHAR2,
59 p_width_uom IN VARCHAR2,
60 p_depth IN VARCHAR2,
61 p_depth_uom IN VARCHAR2,
62 p_volume IN VARCHAR2,
63 p_volume_uom IN VARCHAR2,
64 p_net_content IN VARCHAR2,
65 p_net_content_uom IN VARCHAR2,
66 p_net_wt IN VARCHAR2,
67 p_net_wt_uom IN VARCHAR2,
68 p_is_info_pvt IN VARCHAR2,
69 p_success_flag IN VARCHAR2,
70 p_gtin_query_id IN VARCHAR2,
71 p_ucc_doc_unique_id IN VARCHAR2,
72 p_xmlg_internal_control_no IN NUMBER,
73 x_collab_dtl_id OUT NOCOPY NUMBER,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_data OUT NOCOPY VARCHAR2 );
76
77 END m4u_global_regqry;