1 PACKAGE PO_VENDORS_SV1 AUTHID CURRENT_USER AS
2 /* $Header: POXPIVDS.pls 115.2 2002/11/23 02:50:14 sbull ship $ */
3
4 /*==================================================================
5 FUNCTION NAME: val_vendor_info()
6
7 DESCRIPTION: This API is used to validate vendor info.
8 1). If only X_vendor_id is supplied, the remaining
9 two parameter are NULL.
10 API will validate vendor_id only.
11 2). If X_vendor_id and X_vendor_site_id are
12 specified, do step (1) and validation vendor_site
13 as well.
14 3). If all the parameters are specified, do step
15 (1) and (2) and validate vendor contact.
16
17 PARAMETERS: X_vendor_id IN NUMBER
18 X_vendor_site_type IN VARCHAR2
19 X_vendor_site_id IN NUMBER
20 X_vendor_contact_id IN NUMBER
21 X_error_code IN OUT VARCHAR2
22
23 DESIGN
24 REFERENCES: 832vlapi.doc
25
26 ALGORITHM: API returns TRUE if validation succeeds, FALSE
27 otherwise.
28
29 NOTES:
30
31 OPEN ISSUES:
32
33 CLOSE ISSUES:
34
35 CHANGE
36 HISTORY: Created 03-Mar-1996 Rajan
37 Modified 14-MAR-1996 Daisy Yu
38
39 =======================================================================*/
40 FUNCTION val_vendor_info(X_vendor_id IN NUMBER,
41 X_vendor_site_type IN VARCHAR2,
42 X_vendor_site_id IN NUMBER,
43 X_vendor_contact_id IN NUMBER,
44 X_error_code IN OUT NOCOPY VARCHAR2)
45 RETURN BOOLEAN;
46
47 /*==================================================================
48 FUNCTION NAME: derive_vendor_id()
49
50 DESCRIPTION: API used to derive vendor_id with vendor_name and/or
51 vendor_num as input arameters.
52
53 PARAMETERS: X_vendor_name IN VARCHAR2,
54 X_vendor_num IN VARCHAR2
55
56 DESIGN
57 REFERENCES: 832dvapi.dd
58
59 ALGORITHM: API returns vendor_id (NUMBER) if found, NULL
60 otherwise.
61
62 NOTES:
63
64 OPEN ISSUES:
65
66 CLOSE ISSUES:
67
68 CHANGE
69 HISTORY: Created 03-Mar-1996 Rajan Odayar
70 Modified 12-MAR-1996 Mike Schifano
71
72 =======================================================================*/
73 FUNCTION derive_vendor_id(X_vendor_name IN VARCHAR2,
74 X_vendor_num IN VARCHAR2)
75 return NUMBER;
76
77
78 END PO_VENDORS_SV1;
[Home] [Help]