1 PACKAGE POA_CUSTOMIZATION_PKG AUTHID CURRENT_USER AS
2 /* $Header: poacusts.pls 115.4 2002/02/14 22:02:12 rshahi ship $ */
3
4
5 -- ========================================================================
6 -- Purchase_Classification_Code
7 --
8 -- This API can be customized for classification of purchases,
9 -- for example: for Production or Non-Production items.
10 -- It serves as a gateway where customers can define their own
11 -- purchase classifications to meet their business needs.
12 --
13 -- A new user updateable lookup, Purchase Classification, has been
14 -- defined for this purpose. It currently is seeded with the lookup
15 -- codes for Production, and Non-Production.
16 -- Users can define new lookup codes for their purchase classification
17 -- through the application.
18 -- The lookup codes reside in the PO_LOOKUP_CODES table.
19 --
20 -- Parameters: p_primary_key_id
21 -- p_primary_key_type
22 --
23 -- where p_primary_key_type refers to the base table of the entity
24 -- and p_primary_key_id refers to the primary key id of the base table
25 -- entity.
26 --
27 -- Called by:
28
29 -- Facts p_primary_key_type p_primary_key_id
30 -- -------------------- --------------------- ---------------------
31 -- Supplier Performance PO_LINE_LOCATIONS_ALL line_location_id
32 -- PO Distributions PO_DISTRIBUTIONS_ALL po_distribution_id
33 -- Receiving RCV_TRANSACTIONS transaction_id
34 --
35 -- Return: the lookup_code in the PO_LOOKUP_CODES table
36 -- corresponding to the purchase classification type,
37 -- where the lookup_type is 'PURCHASE CLASSIFICATION.
38 --
39 -- select lookup_code
40 -- from po_lookup_codes
41 -- where lookup_type = 'PURCHASE CLASSIFICATION'
42 -- ========================================================================
43
44 Function Purchase_Classification_Code (
45 p_primary_key_id in NUMBER,
46 p_primary_key_type in VARCHAR2) return VARCHAR2;
47
48
49
50 -- ========================================================================
51 -- Get_Target_Price
52 --
53 -- This API can be customized for calculating the unit target price for the
54 -- item in the purchase shipment line.
55 --
56 -- The target price measure is normally used for calculating
57 -- a supplier' price score.
58 --
59 -- Parameters: p_line_location_id
60 --
61 -- where p_line_location_id refers to the line_location_id of the record
62 -- in PO_LINE_LOCATIONS_ALL table
63 --
64 -- Called by: Supplier Performance fact source view for its
65 -- target price measure.
66 --
67 -- Return: target price expressed in the purchase transaction
68 -- currency
69 -- ========================================================================
70
71 FUNCTION Get_Target_Price(
72 p_line_location_id IN NUMBER) RETURN NUMBER;
73
74
75
76 /* PRAGMAS */
77
78 PRAGMA RESTRICT_REFERENCES (Purchase_Classification_Code,
79 WNDS, WNPS, RNPS);
80
81 PRAGMA RESTRICT_REFERENCES (Get_Target_Price, WNDS);
82
83
84 END POA_CUSTOMIZATION_PKG;