1 PACKAGE ICX_CAT_POPULATE_ITEM_GRP AS
2 /* $Header: ICXGPPIS.pls 120.1 2005/10/19 10:54:37 sbgeorge noship $*/
3
4 -- Start of comments
5 -- API name : populateVendorNameChanges
6 -- * Type : Group
7 -- * Pre-reqs : None.
8 -- * Function : Takes care of re-populating the vendor name changes in
9 -- intermedia index for ip catalog search. This procedure is
10 -- called by purchasing when a vendor name is changed in
11 -- PO_VENDORS
12 -- * Parameters :
13 -- IN : p_api_version IN NUMBER Required
14 -- p_init_msg_list IN VARCHAR2 Optional
15 -- Default = FND_API.G_FALSE
16 -- p_commit IN VARCHAR2 Optional
17 -- Default = FND_API.G_FALSE
18 -- p_validation_level IN NUMBER Optional
19 -- Default = FND_API.G_VALID_LEVEL_FULL
20 -- p_vendor_id IN NUMBER Required
21 -- Corresponds to the column VENDOR_ID in
22 -- the table PO_VENDORS, and identifies the
23 -- vendor whose name has changed.
24 -- p_vendor_name IN VARCHAR2 Required
25 -- Corresponds to the column VENDOR_NAME in
26 -- the table PO_VENDORS. This is the changed
27 -- vendor name.
28 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
29 -- * Version : Current version 1.0
30 -- Previous version 1.0
31 -- Initial version 1.0
32 --
33 -- Notes : None.
34 --
35 -- End of comments
36 PROCEDURE populateVendorNameChanges
37 ( p_api_version IN NUMBER ,
38 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
39 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
40 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
41 x_return_status OUT NOCOPY VARCHAR2 ,
42 p_vendor_id IN NUMBER ,
43 p_vendor_name IN VARCHAR2
44 );
45
46 -- Start of comments
47 -- API name : populateVendorMerge
48 -- * Type : Group
49 -- * Pre-reqs : None.
50 -- * Function : Takes care of re-populating the vendor merge changes in
51 -- intermedia index for ip catalog search. This procedure is
52 -- called by purchasing when a vendors are merged.
53 -- * Parameters :
54 -- IN : p_api_version IN NUMBER Required
55 -- p_init_msg_list IN VARCHAR2 Optional
56 -- Default = FND_API.G_FALSE
57 -- p_commit IN VARCHAR2 Optional
58 -- Default = FND_API.G_FALSE
59 -- p_validation_level IN NUMBER Optional
60 -- Default = FND_API.G_VALID_LEVEL_FULL
61 -- p_from_vendor_id IN NUMBER Required
62 -- Corresponds to the VENDOR_ID of the vendor that has
63 -- been merged
64 -- p_from_site_id IN NUMBER Required
65 -- Corresponds to the VENDOR_SITE_ID of the vendor
66 -- that has been merged
67 -- p_to_vendor_id IN NUMBER Required
68 -- Corresponds to the VENDOR_ID of the vendor that has
69 -- been merged to
70 -- p_to_site_id IN NUMBER Required
71 -- Corresponds to the VENDOR_SITE_ID of the vendor
72 -- that has been merged to
73 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
74 -- * Version : Current version 1.0
75 -- Previous version 1.0
76 -- Initial version 1.0
77 --
78 -- Notes : None.
79 --
80 -- End of comments
81 PROCEDURE populateVendorMerge
82 ( p_api_version IN NUMBER ,
83 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
84 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
85 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
86 x_return_status OUT NOCOPY VARCHAR2 ,
87 p_from_vendor_id IN NUMBER ,
88 p_from_site_id IN NUMBER ,
89 p_to_vendor_id IN NUMBER ,
90 p_to_site_id IN NUMBER
91 );
92
93 -- Start of comments
94 -- API name : rebuildIPIntermediaIndex
95 -- * Type : Group
96 -- * Pre-reqs : None.
97 -- * Function : Takes care of re-building the intermedia index for ip catalog search.
98 -- This procedure is called by Inventory, iSP and Purchasing teams
99 -- in addition to the main ip APIs, if the main APIs are called
100 -- with p_commit = false. This API will be called after teh commit is done
101 -- * Parameters :
102 -- IN : p_api_version IN NUMBER Required
103 -- p_commit IN VARCHAR2 Optional
104 -- Default = FND_API.G_TRUE
105 -- p_init_msg_list IN VARCHAR2 Optional
106 -- Default = FND_API.G_FALSE
107 -- p_validation_level IN NUMBER Optional
108 -- Default = FND_API.G_VALID_LEVEL_FULL
109 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
110 -- * Version : Current version 1.0
111 -- Previous version 1.0
112 -- Initial version 1.0
113 --
114 -- Notes : None.
115 --
116 -- End of comments
117 PROCEDURE rebuildIPIntermediaIndex
118 ( p_api_version IN NUMBER ,
119 p_commit IN VARCHAR2 := FND_API.G_TRUE ,
120 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
121 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
122 x_return_status OUT NOCOPY VARCHAR2
123 );
124
125 END ICX_CAT_POPULATE_ITEM_GRP;