[Home] [Help]
PACKAGE: APPS.ITG_SYNCSUPPLIERINBOUND_PVT
Source
1 PACKAGE ITG_SyncSupplierInbound_PVT AUTHID CURRENT_USER AS
2 /* ARCS: $Header: itgvssis.pls 120.6 2006/08/25 06:40:28 pvaddana noship $
3 * CVS: itgvssis.pls,v 1.12 2002/12/23 21:20:30 ecoe Exp
4 */
5
6 TYPE vinfo_rec_type IS RECORD(
7 syncind VARCHAR2(1),
8 vendor_id NUMBER,
9 currency VARCHAR2(15),
10 paymethod VARCHAR2(25),
11 terms_id NUMBER,
12 terms_name varchar2(50),
13 vat_num VARCHAR2(20),
14 ctl_date DATE,
15 addr_style VARCHAR2(30)
16 );
17
18 G_MISS_VINFO_REC vinfo_rec_type;
19
20 PROCEDURE Sync_Vendor(
21 x_return_status OUT NOCOPY VARCHAR2, /* VARCHAR2(1) */
22 x_msg_count OUT NOCOPY NUMBER,
23 x_msg_data OUT NOCOPY VARCHAR2, /* VARCHAR2(2000) */
24
25 p_syncind IN VARCHAR2, /* 'A', 'C', 'D' */
26 p_name IN VARCHAR2, /* name1 */
27 p_onetime IN VARCHAR2 := NULL, /* onetime */
28 p_partnerid IN VARCHAR2 := NULL, /* partnrid */
29 p_active IN NUMBER := NULL, /* active */
30 p_currency IN VARCHAR2 := NULL, /* currency */
31 p_dunsnumber IN VARCHAR2 := NULL, /* dunsnumber */
32 p_parentid IN NUMBER := NULL, /* parentid */
33 p_paymethod IN VARCHAR2 := NULL, /* paymethod */
34 p_taxid IN VARCHAR2 := NULL, /* taxid */
35 p_termid IN VARCHAR2 := NULL, /* termid */
36 p_us_flag IN VARCHAR2 := 'Y', /* userarea.ref_usflag */
37 p_date IN DATE := NULL, /* controlarea.datetime */
38 p_org IN VARCHAR2, /* MOAC */
39 x_vinfo_rec OUT NOCOPY vinfo_rec_type
40 );
41
42
43 PROCEDURE Sync_VendorSite(
44
45 x_return_status OUT NOCOPY VARCHAR2, /* VARCHAR2(1) */
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2, /* VARCHAR2(2000) */
48
49 /* TAG: address */
50 p_addrline1 IN VARCHAR2 := NULL, /* addrline index=1 */
51 p_addrline2 IN VARCHAR2 := NULL, /* addrline index=2 */
52 p_addrline3 IN VARCHAR2 := NULL, /* addrline index=3 */
53 p_addrline4 IN VARCHAR2 := NULL, /* addrline index=4 */
54 p_city IN VARCHAR2 := NULL, /* city */
55 p_country IN VARCHAR2 := NULL, /* country */
56 p_county IN VARCHAR2 := NULL, /* county */
57 p_site_code IN VARCHAR2, /* descriptn (key) */
58 p_fax IN VARCHAR2 := NULL, /* fax index=1 */
59 p_zip IN VARCHAR2 := NULL, /* postalcode */
60 p_state IN VARCHAR2 := NULL, /* stateprovn */
61 p_phone IN VARCHAR2 := NULL, /* telephone index=1 */
62 p_org IN VARCHAR2 := NULL,
63 p_purch_site IN VARCHAR2 := NULL, /* userarea.ref_pursite */
64 p_pay_site IN VARCHAR2 := NULL, /* userarea.ref_paysite */
65 p_rfq_site IN VARCHAR2 := NULL, /* userarea.ref_rfqsite */
66 p_pc_site IN VARCHAR2 := NULL, /* userarea.ref_pcsite */
67 p_vat_code IN VARCHAR2 := NULL, /* userarea.ref_vatcode */
68
69 p_vinfo_rec IN vinfo_rec_type
70 );
71
72
73 PROCEDURE Sync_VendorContact(
74 x_return_status OUT NOCOPY VARCHAR2, /* VARCHAR2(1) */
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2, /* VARCHAR2(2000) */
77
78 /* TAG: contact */
79 p_title IN VARCHAR2 := NULL, /* contcttype */
80 p_first_name IN VARCHAR2 := NULL, /* name index=1 */
81 p_middle_name IN VARCHAR2 := NULL, /* name index=2 */
82 p_last_name IN VARCHAR2 := NULL, /* name index=3 */
83 p_phone IN VARCHAR2 := NULL, /* telephone index=1 */
84 p_site_code IN VARCHAR2, /* userarea.ref_sitecode */
85 p_vinfo_rec IN vinfo_rec_type
86 );
87 END ITG_SyncSupplierInbound_PVT;