1 PACKAGE ITG_BOAPI_Wrappers AS
2 /* ARCS: $Header: itgwraps.pls 120.2 2006/01/23 03:49:03 bsaratna noship $
3 * CVS: itgwraps.pls,v 1.31 2003/05/30 00:49:39 klai Exp
4 */
5
6 g_active NUMBER;
7
8 PROCEDURE Begin_Wrapper(
9 p_refid IN VARCHAR2,
10 p_org IN NUMBER,
11 p_xmlg_xtype IN VARCHAR2,
12 p_xmlg_xstyp IN VARCHAR2,
13 p_xmlg_docid IN VARCHAR2,
14 p_doctyp IN VARCHAR2,
15 p_clntyp IN VARCHAR2,
16 p_doc IN VARCHAR2,
17 p_rel IN VARCHAR2,
18 p_cdate IN DATE
19 );
20
21 PROCEDURE End_Wrapper(
22 p_refid IN VARCHAR2 := NULL,
23 p_doc IN VARCHAR2 := NULL,
24 p_cdate IN DATE := SYSDATE,
25 x_cln_id OUT NOCOPY NUMBER,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_return_message OUT NOCOPY VARCHAR2
28 );
29
30 PROCEDURE Reap_Messages(
31 p_refid IN VARCHAR2 := NULL,
32 p_doc IN VARCHAR2 := NULL,
33 p_cdate IN DATE := SYSDATE
34 );
35
36 /* Wrap ITG_SyncCOAInbound_PVT from itgvsci?.pls */
37 PROCEDURE Sync_FlexValue(
38 p_syncind IN VARCHAR2,
39 p_flex_value IN VARCHAR2,
40 p_vset_id IN NUMBER,
41 p_flex_desc IN VARCHAR2,
42 p_action_date IN DATE,
43 p_effective_date IN DATE,
44 p_expiration_date IN DATE,
45 p_acct_type IN VARCHAR2,
46 p_enabled_flag IN VARCHAR2
47 );
48
49 /* Wrap ITG_SyncExchInbound_PVT from itgvsei?.pls */
50 PROCEDURE Process_ExchangeRate(
51 p_syncind IN VARCHAR2,
52 p_quantity IN NUMBER,
53 p_currency_from IN VARCHAR2,
54 p_currency_to IN VARCHAR2,
55 p_factor IN VARCHAR2,
56 p_sob IN VARCHAR2,
57 p_ratetype IN VARCHAR2,
58 p_creation_date IN DATE,
59 p_effective_date IN DATE
60 );
61
62 PROCEDURE Update_PoLine(
63 p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2,
65 p_commit IN VARCHAR2,
66 p_validation_level IN NUMBER,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2,
70 p_po_code IN VARCHAR2,
71 p_org_id IN VARCHAR2,
72 p_release_id IN VARCHAR2,
73 p_line_num IN NUMBER,
74 p_doc_type IN VARCHAR2,
75 p_quantity IN NUMBER,
76 p_amount IN NUMBER
77 );
78
79 /* Wrap ITG_SyncSupplierInbound_PVT from itgvssi?.pls (3 procs) */
80 PROCEDURE Sync_Vendor(
81 p_syncind IN VARCHAR2,
82 p_name IN VARCHAR2,
83 p_onetime IN VARCHAR2,
84 p_partnerid IN VARCHAR2,
85 p_active IN NUMBER,
86 p_currency IN VARCHAR2,
87 p_dunsnumber IN VARCHAR2,
88 p_parentid IN NUMBER,
89 p_paymethod IN VARCHAR2,
90 p_taxid IN VARCHAR2,
91 p_termid IN VARCHAR2,
92 p_us_flag IN VARCHAR2,
93 p_date IN DATE,
94 p_org IN VARCHAR2 -- MOAC
95 );
96
97 PROCEDURE Sync_VendorSite(
98 p_addrline1 IN VARCHAR2,
99 p_addrline2 IN VARCHAR2,
100 p_addrline3 IN VARCHAR2,
101 p_addrline4 IN VARCHAR2,
102 p_city IN VARCHAR2,
103 p_country IN VARCHAR2,
104 p_county IN VARCHAR2,
105 p_site_code IN VARCHAR2,
106 p_fax IN VARCHAR2,
107 p_zip IN VARCHAR2,
108 p_state IN VARCHAR2,
109 p_phone IN VARCHAR2,
110 p_org IN VARCHAR2,
111 p_purch_site IN VARCHAR2,
112 p_pay_site IN VARCHAR2,
113 p_rfq_site IN VARCHAR2,
114 p_pc_site IN VARCHAR2,
115 p_vat_code IN VARCHAR2
116 );
117
118 PROCEDURE Sync_VendorContact(
119 p_title IN VARCHAR2,
120 p_first_name IN VARCHAR2,
121 p_middle_name IN VARCHAR2,
122 p_last_name IN VARCHAR2,
123 p_phone IN VARCHAR2,
124 p_site_code IN VARCHAR2
125 );
126
127 /* Wrap ITG_SyncItemInbound_PVT from itgvsii?.pls */
128 PROCEDURE Sync_Item(
129 p_syncind IN VARCHAR2,
130 p_org_id IN NUMBER,
131 p_hazrdmatl IN VARCHAR2,
132 p_create_date IN DATE,
133 p_item IN VARCHAR2,
134 p_uom IN VARCHAR2,
135 p_itemdesc IN VARCHAR2,
136 p_itemstatus IN VARCHAR2,
137 p_itemtype IN VARCHAR2,
138 p_rctrout IN VARCHAR2,
139 p_commodity1 IN VARCHAR2,
140 p_commodity2 IN VARCHAR2
141 );
142
143 PROCEDURE Process_PoNumber(
144 p_reqid IN NUMBER,
145 p_reqlinenum IN NUMBER,
146 p_poid IN NUMBER,
147 p_org IN NUMBER
148 );
149
150 /* Wrap ITG_SyncUOMInbound_PVT from itgvsui?.pls */
151 PROCEDURE Sync_UOM_ALL(
152 p_task IN VARCHAR2,
153 p_syncind IN VARCHAR2,
154 p_uom IN VARCHAR2,
155 p_uomcode IN VARCHAR2,
156 p_uomclass IN VARCHAR2,
157 p_buomflag IN VARCHAR2,
158 p_description IN VARCHAR2,
159 p_defconflg IN VARCHAR2,
160 p_fromcode IN VARCHAR2,
161 p_touomcode IN VARCHAR2,
162 p_itemid IN NUMBER,
163 p_fromfactor IN VARCHAR2,
164 p_tofactor IN VARCHAR2,
165 p_dt_creation IN DATE,
166 p_dt_expiration IN DATE
167 );
168
169
170 END ITG_BOAPI_Wrappers;