1 package HZ_IMP_ADDRESS_VAL_PKG as
2 /*$Header: ARHADRVS.pls 120.8 2005/10/30 04:16:57 appldev noship $*/
3
4 -----------------------------------------------------------------------
5 -- The procedure,address_validation_main will be called by
6 -- UI Console wrapper concurrent program for each batch.
7 -- This procedure will intern call address_validation_child cp
8 --
9 ------------------------------------------------------------------------
10 procedure address_validation_main(
11 Errbuf OUT NOCOPY VARCHAR2,
12 Retcode OUT NOCOPY VARCHAR2,
13 p_batch_id IN NUMBER);
14
15
16 -----------------------------------------------------------------------
17 -- The procedure,address_validation_child will be called by
18 -- address_validation_main procedure for each batch.
19 -- This procedure will intern call 'oracle.apps.ar.hz.import.outboundxml'
20 -- event subscription.
21 ------------------------------------------------------------------------
22 procedure address_validation_child(
23 Errbuf OUT NOCOPY VARCHAR2,
24 Retcode OUT NOCOPY VARCHAR2,
25 p_batch_id IN NUMBER,
26 P_VAL_SUBSET_ID IN NUMBER DEFAULT NULL,
27 p_country_code IN VARCHAR2 DEFAULT NULL,
28 p_module IN VARCHAR2 DEFAULT NULL,
29 p_module_id IN NUMBER DEFAULT NULL ,
30 P_OVERWRITE_THRESHOLD IN VARCHAR2 DEFAULT NULL ,
31 P_ORIG_SYSTEM IN VARCHAR2 DEFAULT NULL,
32 P_ADAPTER_ID IN NUMBER DEFAULT NULL);
33
34 -----------------------------------------------------------------------
35 -- This function will be called by update_validated_address procedure,
36 -- to compare the threshold and validated status code.
37 --
38 ------------------------------------------------------------------------
39 function compare_treshhold(p_value1 varchar2, p_value2 varchar2) return varchar2;
40
41 -----------------------------------------------------------------------
42 -- This procedure will be called by xml gateway through mapcode,
43 -- as a procedure call.
44 --
45 ------------------------------------------------------------------------
46 Procedure update_validated_address(
47 p_SITE_ORIG_SYSTEM_REFERENCE in VARCHAR2 ,
48 p_SITE_ORIG_SYSTEM in VARCHAR2 ,
49 p_batch_id in NUMBER,
50 p_Address1 in VARCHAR2 DEFAULT NULL,
51 p_Address2 in VARCHAR2 DEFAULT NULL,
52 p_Address3 in VARCHAR2 DEFAULT NULL,
53 p_Address4 in VARCHAR2 DEFAULT NULL,
54 p_city in VARCHAR2 DEFAULT NULL,
55 p_county in VARCHAR2 DEFAULT NULL,
56 p_CountrySubEntity in VARCHAR2 DEFAULT NULL,
57 p_country in VARCHAR2 DEFAULT NULL,
58 p_postal_code in VARCHAR2 DEFAULT NULL,
59 p_status in VARCHAR2 DEFAULT NULL,
60 P_OVERWRITE_THRESHOLD in VARCHAR2 DEFAULT NULL);
61
62 -----------------------------------------------------------------------
63 -- Folowing Rule Function will be called from event subscription,
64 --'oracle.apps.ar.hz.import.outboundxml' which is raised by
65 -- address_validation_child Concurrent Program.
66 --
67 -- This function rule will do the following
68 -- 1) Get the generated xml doc by ecx_standard.generate
69 -- 2) Pass the xml doc to HZ_LOCATION_SERVICES_PUB.submit_addrval_doc
70 -- 3) Get returned validated xml doc, raise another wf event to parse
71 -- the validated addresses.
72 ------------------------------------------------------------------------
73 function outboundxml_rule(
74 p_subscription_guid in raw,
75 p_event in out nocopy wf_event_t
76 ) return varchar2;
77
78 -----------------------------------------------------------------------
79 -- Folowing Rule Function will be called from event subscription,
80 --'oracle.apps.ar.hz.import.inboundxml' which is raised by
81 -- another rule function outboundxml_rule.
82 --
83 -- This function rule will process the inbound xml doc and update
84 -- the hz_imp_addresses_int table with validated address components.
85 ------------------------------------------------------------------------
86 FUNCTION inboundxml_rule(p_subscription_guid IN RAW,
87 p_event in out nocopy wf_event_t
88 ) RETURN VARCHAR2;
89 end;