1 PACKAGE M4U_SETUP_PACKAGE AUTHID CURRENT_USER AS
2 /* $Header: M4USETPS.pls 120.0 2005/08/01 03:49:46 rkrishan noship $ */
3
4 -- Name
5 -- add_or_update_tp_detail
6 -- Purpose
7 -- This procedure sets up the XMLGateway Trading Partner Setup detail
8 -- for a single transaction based on the params
9 -- If detail record is present it updates else inserts
10 -- Arguments
11 -- x_err_buf => API param for concurrent program calls
12 -- x_retcode => API param for concurrent program calls
13 -- <paramlist> => corresponds to the ecx_tp_api, nothing to talk abt
14 -- Notes
15 -- none
16 PROCEDURE add_or_update_tp_detail(
17 x_errbuf OUT NOCOPY VARCHAR2,
18 x_retcode OUT NOCOPY VARCHAR2,
19 p_txn_subtype VARCHAR2,
20 p_map VARCHAR2,
21 p_direction VARCHAR2,
22 p_tp_hdr_id NUMBER
23 );
24
25 -- Name
26 -- SETUP
27 -- Purpose
28 -- This procedure is called from a concurrent program(can be called from anywhere actually).
29 -- This procedure does the setup required for m4u
30 -- i) Setup default TP location in HR_LOCATIONS
31 -- ii) Setup XMLGateway trading partner definition
32 -- Arguments
33 -- x_err_buf => API out result param for concurrent program calls
34 -- x_retcode => API out result param for concurrent program calls
35 -- p_location_code => Should have value 'OIPC Default TP'
36 -- p_description => Some description
37 -- p_addr_line_1 => Some address line 1
38 -- p_region_1 => Some region 1 (province)
39 -- p_region_2 => Some region 2 (State)
40 -- p_town_or_city => Some city
41 -- p_postal_code => Some postal code
42 -- Notes
43 -- All the input arguments are used in the call to setup_hr_locations
44 -- The concurrent program will be failed in case of any error
45 -- All arguments are moved into the code
46 PROCEDURE SETUP(
47 x_errbuf OUT NOCOPY VARCHAR2,
48 x_retcode OUT NOCOPY NUMBER
49
50 );
51
52 END M4U_SETUP_PACKAGE;