PACKAGE: APPS.POS_SEARCH_DUP_PARTY_PKG

Source

1 PACKAGE POS_SEARCH_DUP_PARTY_PKG AUTHID CURRENT_USER AS
2 /* $Header: POSDQMS.pls 120.1 2010/11/25 12:26:08 puppulur noship $ */
3 
4 PROCEDURE find_duplicate_parties
5        (p_init_msg_list  IN VARCHAR2  := fnd_api.g_true,
6         p_supp_name      IN VARCHAR2,
7         p_supp_name_alt  IN VARCHAR2,
8         p_tax_payer_id   IN VARCHAR2,
9         p_tax_reg_no     IN VARCHAR2,
10         p_duns_no        IN VARCHAR2,
11         p_sic_code       IN VARCHAR2,
12         p_sup_reg_id     IN VARCHAR2,
13         x_search_ctx_id  OUT NOCOPY NUMBER,
14         x_return_status  OUT NOCOPY VARCHAR2,
15         x_msg_count      OUT NOCOPY NUMBER,
16         x_msg_data       OUT NOCOPY VARCHAR2);
17 
18 
19 PROCEDURE pos_create_organization(
20     p_supp_name         IN     VARCHAR2,
21     p_supp_name_alt     IN     VARCHAR2,
22     p_tax_payer_id      IN     VARCHAR2,
23     p_tax_reg_no        IN     VARCHAR2,
24     p_duns_number       IN     VARCHAR2,
25     p_sic_code          IN     VARCHAR2,
26     p_url               IN     VARCHAR2,
27     p_org_name_phonetic IN     VARCHAR2,
28     x_return_status     OUT    NOCOPY VARCHAR2,
29     x_msg_count         OUT    NOCOPY NUMBER,
30     x_msg_data          OUT    NOCOPY VARCHAR2,
31     x_org_party_id      OUT    NOCOPY NUMBER,
32     x_org_party_number  OUT    NOCOPY VARCHAR2,
33     x_org_profile_id    OUT    NOCOPY NUMBER
34 );
35 
36 PROCEDURE update_supp_party_id(
37 	p_supp_reg_id       IN NUMBER,
38 	p_party_id          IN NUMBER,
39 	x_return_status     OUT NOCOPY VARCHAR2
40 );
41 
42 PROCEDURE pos_update_organization(
43     p_supp_name			IN     VARCHAR2,
44     p_supp_name_alt		IN     VARCHAR2,
45     p_tax_payer_id		IN     VARCHAR2,
46     p_tax_reg_no		IN     VARCHAR2,
47     p_duns_number		IN     VARCHAR2,
48     p_sic_code			IN     VARCHAR2,
49     p_party_id			IN     NUMBER,
50 --    p_party_obj_version   	IN     NUMBER,
51     x_profile_id		OUT    NOCOPY NUMBER,
52     x_return_status		OUT    NOCOPY VARCHAR2,
53     x_msg_count			OUT    NOCOPY NUMBER,
54     x_msg_data			OUT    NOCOPY VARCHAR2
55 );
56 
57 
58 PROCEDURE search_duplicate_parties(
59     p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
60     p_party_name    IN VARCHAR2,
61     p_party_number  IN VARCHAR2,
62     p_status        IN VARCHAR2,
63     p_sic_code      IN VARCHAR2,
64     p_address       IN VARCHAR2,
65     p_city          IN VARCHAR2,
66     p_state         IN VARCHAR2,
67     p_country       IN VARCHAR2,
68     x_search_ctx_id OUT NOCOPY NUMBER,
69     x_return_status OUT NOCOPY VARCHAR2,
70     x_msg_count     OUT NOCOPY NUMBER,
71     x_msg_data      OUT NOCOPY VARCHAR2
72 );
73 
74 
75 PROCEDURE enable_party_as_supplier(p_party_id       IN NUMBER,
76                                    p_vendor_num     IN VARCHAR2,
77                                    x_vendor_id      OUT NOCOPY NUMBER,
78                                    x_return_status  OUT NOCOPY VARCHAR2,
79                                    x_msg_count      OUT NOCOPY NUMBER,
80                                    x_msg_data       OUT NOCOPY VARCHAR2);
81 
82 
83 PROCEDURE  assign_party_usage( p_contact_party_id  IN NUMBER,
84                                x_return_status     OUT nocopy VARCHAR2,
85                                x_msg_count    	   OUT nocopy NUMBER,
86                                x_msg_data      	   OUT nocopy VARCHAR2
87                               );
88 
89 END POS_SEARCH_DUP_PARTY_PKG;