1 PACKAGE JAI_AVLIST_VALIDATE_PKG AUTHID CURRENT_USER AS
2 --$Header: Jai_AvList_Validate.pls 120.0.12010000.3 2009/06/27 04:24:08 jijili noship $
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| Jai_Avlist_Validate.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Validate if there is more than one Item-UOM combination existing |
13 --| in used AV list for the Item selected in the transaction. |
14 --| |
15 --| PROCEDURE LIST |
16 --| PROCEDURE Check_AvList_Validation |
17 --| |
18 --| HISTORY |
19 --| 2009/06/08 Jia Li Created |
20 --| |
21 --+======================================================================*/
22
23 -- Declare global variable for package name
24 GV_MODULE_PREFIX VARCHAR2(50) :='jai.plsql.Jai_AvList_Validate_Pkg';
25
26 -- Public function and procedure declarations
27 --==========================================================================
28 -- PROCEDURE NAME:
29 --
30 -- Check_AvList_Validation Public
31 --
32 -- DESCRIPTION:
33 --
34 -- This is a validation procedure which will be used to check
35 -- whether there is more than one Item-UOM combination existing
36 -- in used AV list for the Item selected in the transaction.
37 --
38 -- PARAMETERS:
39 -- In: pn_party_id Identifier of Customer id or Vendor id
40 -- pn_party_site_id Identifier of Customer/Vendor site id
41 -- pn_inventory_item_id Identifier of Inventory item id
42 -- pd_ordered_date Identifier of Ordered date
43 -- pv_party_type Identifier of Party type, 'C' is mean customer, 'V' is mean vendor
44 -- pn_pricing_list_id Identifier of vat/excise assessable price id, for base form used.
45 --
46 --
47 -- DESIGN REFERENCES:
48 -- FDD_R12i_Advanced_Pricing_V1.0.doc
49 --
50 -- CHANGE HISTORY:
51 --
52 -- 08-Jun-2009 Jia Li created
53 --==========================================================================
54 PROCEDURE Check_AvList_Validation
55 ( pn_party_id IN NUMBER
56 , pn_party_site_id IN NUMBER
57 , pn_inventory_item_id IN NUMBER
58 , pd_ordered_date IN DATE
59 , pv_party_type IN VARCHAR2
60 , pn_pricing_list_id IN NUMBER
61 );
62
63 END JAI_AVLIST_VALIDATE_PKG;