1 PACKAGE PO_VENDOR_CONTACTS_SV AUTHID CURRENT_USER AS
2 /* $Header: POXVDVCS.pls 120.0.12020000.3 2013/02/10 12:05:25 vegajula ship $*/
3
4 /*===========================================================================
5 FUNCTION NAME: val_vendor_contact()
6
7 DESCRIPTION: This function checks whether a given Supplier
8 Contact is still valid.
9
10
11 PARAMETERS: p_vendor_contact_id IN NUMBER
12 p_vendor_site_id IN NUMBER
13
14 RETURN TYPE: BOOLEAN
15
16 DESIGN REFERENCES:
17
18 ALGORITHM:
19
20 NOTES:
21
22 OPEN ISSUES:
23
24 CLOSED ISSUES:
25
26 CHANGE HISTORY: Created 09-JUL-1995 LBROADBE
27 Changed to 14-AUG-1995 LBROADBE
28 Function
29 ===========================================================================*/
30 FUNCTION val_vendor_contact(p_vendor_contact_id IN NUMBER,
31 p_vendor_site_id in NUMBER) return BOOLEAN;
32
33 /*===========================================================================
34 PROCEDURE NAME: get_vendor_contact()
35
36 DESCRIPTION:
37 o DEF - If there is only one active contact for this site and the contact name
38 is not filled in yet, default the contact name.
39 PARAMETERS:
40
41 DESIGN REFERENCES: ../POXPOMPO.doc
42
43 ALGORITHM:
44
45 NOTES:
46
47 OPEN ISSUES:
48
49 CLOSED ISSUES:
50
51 CHANGE HISTORY:
52 ===========================================================================*/
53
54 PROCEDURE get_vendor_contact(X_vendor_site_id IN NUMBER, X_vendor_contact_id IN OUT NOCOPY number,
55 X_vendor_contact_name IN OUT NOCOPY varchar2 );
56
57
58 /*===========================================================================
59 PROCEDURE NAME: get_contact_info()
60
61 DESCRIPTION: Obtain the name of the vendor contact and phone
62 using the vendor contact id.
63
64 PARAMETERS: x_vendor_contact_id IN NUMBER
65 x_vendor_contact_name OUT VARCHAR2
66 x_vendor_phone OUT VARCHAR2
67
68 DESIGN REFERENCES: ../POXRQERQ.doc
69
70 ALGORITHM:
71
72 NOTES:
73
74 OPEN ISSUES:
75
76 CLOSED ISSUES:
77
78 CHANGE HISTORY: Created 10/21 Ramana Mulpury
79 ===========================================================================*/
80
81 PROCEDURE get_contact_info (x_vendor_contact_id IN NUMBER,
82 x_vendor_site_id IN NUMBER,
83 x_vendor_contact_name IN OUT NOCOPY VARCHAR2,
84 x_vendor_phone IN OUT NOCOPY VARCHAR2);
85
86 FUNCTION get_vendor_contact_id -- <Bug 3692519>
87 ( p_po_header_id IN NUMBER
88 ) RETURN NUMBER;
89
90 END PO_VENDOR_CONTACTS_SV;