1 PACKAGE PO_SOURCING_SV AUTHID CURRENT_USER as
2 /* $Header: POXSCS4S.pls 115.4 2003/11/12 22:14:38 jskim ship $ */
3
4 /*===========================================================================
5 PACKAGE NAME: PO_SOURCING_SV
6
7 DESCRIPTION: This package contains the server side Supplier Item
8 Catalog and Sourcing Application Program Interfaces
9 (APIs).
10
11 CLIENT/SERVER: Server
12
13 OWNER: Liza Broadbent
14
15 FUNCTION/PROCEDURE: val_order_pad_line()
16 get_approval_status()
17
18 ===========================================================================*/
19
20 /*===========================================================================
21 PROCEDURE NAME: val_order_pad_line()
22
23 DESCRIPTION: This procedure is called to validate a source document
24 line when the user adds records to the Order Pad in the
25 Supplier-Item Catalog. It also returns the List Price
26 if a predefined item has been specified.
27
28
29
30 CHANGE HISTORY: Created 09-JUL-1995 LBROADBE
31 Updated 06-APR-1996 LBROADBE
32 ===========================================================================*/
33 PROCEDURE val_order_pad_line
34 (
35 p_item_id IN NUMBER,
36 p_category_id IN NUMBER,
37 p_vendor_id IN NUMBER,
38 p_vendor_site_id IN NUMBER,
39 p_vendor_contact_id IN NUMBER,
40 p_currency_code IN VARCHAR2,
41 p_ap_terms_id IN NUMBER,
42 p_fob_lookup_code IN VARCHAR2,
43 p_ship_via_code IN VARCHAR2,
44 p_freight_terms_code IN VARCHAR2,
45 p_line_type_id IN NUMBER,
46 p_unit_of_measure IN VARCHAR2,
47 p_dest_org_id IN NUMBER,
48 p_document_type IN VARCHAR2,
49 p_structure_id IN NUMBER,
50 p_source_type IN VARCHAR2,
51 p_display_message IN VARCHAR2,
52 p_cross_ref_type IN VARCHAR2,
53 p_instance_org_id IN NUMBER,
54 p_primary_inv_cost IN NUMBER,
55 p_purchasing_org_id IN NUMBER, --< Shared Proc FPJ >
56 X_multiple_flag IN OUT NOCOPY VARCHAR2,
57 X_messages_exist IN OUT NOCOPY BOOLEAN,
58 X_message IN OUT NOCOPY VARCHAR2,
59 X_category_val IN OUT NOCOPY BOOLEAN,
60 X_vendor_val IN OUT NOCOPY BOOLEAN,
61 X_vendor_site_val IN OUT NOCOPY BOOLEAN,
62 X_vendor_contact_val IN OUT NOCOPY BOOLEAN,
63 X_currency_val IN OUT NOCOPY BOOLEAN,
64 X_ap_terms_val IN OUT NOCOPY BOOLEAN,
65 X_fob_lookup_val IN OUT NOCOPY BOOLEAN,
66 X_ship_via_val IN OUT NOCOPY BOOLEAN,
67 X_freight_terms_val IN OUT NOCOPY BOOLEAN,
68 X_line_type_val IN OUT NOCOPY BOOLEAN,
69 X_unit_of_meas_val IN OUT NOCOPY BOOLEAN,
70 X_list_price IN OUT NOCOPY NUMBER,
71 X_planned_item_flag IN OUT NOCOPY VARCHAR2,
72 X_primary_uom IN OUT NOCOPY VARCHAR2,
73 X_convert_inv_cost IN OUT NOCOPY NUMBER,
74 X_change_price IN OUT NOCOPY BOOLEAN
75 );
76
77 /*===========================================================================
78 FUNCTION NAME: vendor_sourcing_status()
79
80 DESCRIPTION: This function returns an approval status for a given
81 supplier/item combination based on whether they
82 can be found on a current (as of SYSDATE) effective
83 sourcing rule. The function call is appended to the
84 queries from the po_negotiated_sources_v and
85 po_purchase_history_v views for the Supplier-Item
86 Catalog.
87
88 PARAMETERS: X_item_id IN NUMBER,
89 X_vendor_id IN NUMBER,
90 X_vendor_site_id IN NUMBER,
91 X_organization_id IN NUMBER,
92 X_autosource_rule_id IN NUMBER,
93 X_assignment_set_id IN NUMBER
94
95 RETURN VALUE: VARCHAR2
96
97 DESIGN REFERENCES:
98
99
100 ALGORITHM:
101
102 NOTES: This function does not include standard error
103 handling as required to be called from a view.
104
105 OPEN ISSUES:
106
107 CLOSED ISSUES:
108
109 CHANGE HISTORY: Created 27-JUN-95 LBROADBE
110 ===========================================================================*/
111 FUNCTION vendor_sourcing_status(X_item_id IN NUMBER,
112 X_vendor_id IN NUMBER,
113 X_vendor_site_id IN NUMBER,
114 X_organization_id IN NUMBER,
115 X_autosource_rule_id IN NUMBER,
116 X_assignment_set_id IN NUMBER)
117 RETURN varchar2;
118
119 --PRAGMA restrict_references (vendor_sourcing_status,WNDS,RNPS,WNPS);
120
121 END PO_SOURCING_SV;