PACKAGE: APPS.PO_HEADERS_SV3

Source

1 PACKAGE PO_HEADERS_SV3 AUTHID CURRENT_USER AS
2 /* $Header: POXPOH3S.pls 115.4 2002/12/11 23:39:37 anhuang ship $*/
3 
4 /*===========================================================================
5   PROCEDURE NAME:	get_security_level_code()
6 
7   DESCRIPTION:   This procedure gets the security level code for a given
8                  document sub type.
9 
10   PARAMETERS:
11 
12   DESIGN REFERENCES:	../POXPOMPO.doc
13 
14   ALGORITHM:
15 
16   NOTES:
17 
18   OPEN ISSUES:
19 
20   CLOSED ISSUES:
21 
22   CHANGE HISTORY:
23 ===========================================================================*/
24 procedure get_security_level_code(X_po_type     IN varchar2,
25                                    X_po_sub_type IN varchar2,
26                                    X_security_level_code IN OUT NOCOPY varchar2);
27 
28 
29 procedure test_get_security_level_code;
30 /*===========================================================================
31   FUNCTION NAME:	get_currency_code()
32 
33   DESCRIPTION:   This procedure returns the currency code for a given PO.
34                  For instance, this is used in the PO_LINE_LOCATIONS_RELEASE_V
35                  view.
36 
37   PARAMETERS:
38 
39   DESIGN REFERENCES:	../POXPOMPO.doc
40 
41   ALGORITHM:
42 
43   NOTES:
44 
45   OPEN ISSUES:
46 
47   CLOSED ISSUES:
48 
49   CHANGE HISTORY:
50 ===========================================================================*/
51 
52  function get_currency_code(X_po_header_id IN NUMBER)
53           return varchar2;
54 
55 PROCEDURE get_currency_info                              -- <2694908>
56 (   p_po_header_id      IN         PO_HEADERS_ALL.po_header_id%TYPE ,
57     x_currency_code     OUT NOCOPY PO_HEADERS_ALL.currency_code%TYPE ,
58     x_rate_type         OUT NOCOPY PO_HEADERS_ALL.rate_type%TYPE,
59     x_rate_date         OUT NOCOPY PO_HEADERS_ALL.rate_date%TYPE,
60     x_rate              OUT NOCOPY PO_HEADERS_ALL.rate%TYPE
61 );
62  -- pragma restrict_references (get_currency_code, WNDS,RNPS,WNPS);
63 
64 
65 
66 /*===========================================================================
67   PROCEDURE NAME:	get_doc_num()
68 
69   DESCRIPTION:   	This procedure obtains the document number
70 			given the po_header_id.
71 
72   PARAMETERS:		x_doc_num	IN OUT VARCHAR2
73 			x_header_id	IN     NUMBER
74 
75   DESIGN REFERENCES:	../POXRQERQ.doc
76 
77   ALGORITHM:
78 
79   NOTES:
80 
81   OPEN ISSUES:
82 
83   CLOSED ISSUES:
84 
85   CHANGE HISTORY:	Ramana Mulpury	 08/09  Created
86 ===========================================================================*/
87 procedure get_doc_num (X_doc_num	IN OUT NOCOPY VARCHAR2,
88                        X_header_id	IN     NUMBER);
89 
90 /*===========================================================================
91   PROCEDURE NAME:	get_po_header_id ()
92 
93   DESCRIPTION:   	This procedure obtains the po_header_id
94 			given the document number.
95 
96   PARAMETERS:		x_doc_num	IN OUT VARCHAR2
97 			x_header_id	IN     NUMBER
98 
99   DESIGN REFERENCES:
100 
101   ALGORITHM:
102 
103   NOTES:
104 
105   OPEN ISSUES:
106 
107   CLOSED ISSUES:
108 
109   CHANGE HISTORY:	DFONG		 12/6/96  Created
110 ===========================================================================*/
111 
112 -- Moved this into RCVTISVS.pls due to compatibility issues with globalization
113 /* procedure get_po_header_id (X_po_header_id_record	IN OUT	rcv_shipment_line_sv.document_num_record_type); */
114 
115 
116 /*===========================================================================
117   FUNCTION NAME:	get_po_status()
118 
119   DESCRIPTION:   This function returns the status for a given PO.
120                  The document statuses are concatenated into one field
121                  that is returned.
122 
123   PARAMETERS:
124 
125   DESIGN REFERENCES:	../POXPOMPO.doc
126 
127   ALGORITHM:
128 
129   NOTES:
130 
131   OPEN ISSUES:
132 
133   CLOSED ISSUES:
134 
135   CHANGE HISTORY:
136 ===========================================================================*/
137 
138  function get_po_status  (X_po_header_id IN NUMBER)
139                           return varchar2;
140 
141  -- pragma restrict_references (get_po_status, WNDS,RNPS,WNPS);
142 
143 
144 
145 END PO_HEADERS_SV3;