[Home] [Help]
PACKAGE: APPS.PO_HEADERS_SV4
Source
1 PACKAGE PO_HEADERS_SV4 AUTHID CURRENT_USER AS
2 /* $Header: POXPOH4S.pls 115.7 2003/06/18 19:28:34 bao ship $*/
3
4
5
6 FUNCTION is_quotation -- <GA FPI>
7 ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
8 ) RETURN BOOLEAN;
9
10 /*===========================================================================
11 PROCEDURE NAME: get_doc_type_lookup_code ()
12
13 DESCRIPTION: This procedure returns the PO document type name and
14 type lookup code for a given document_type_code and
15 document_subtype.
16
17 PARAMETERS:
18
19 DESIGN REFERENCES: ../POXPOMPO.doc
20
21 ALGORITHM:
22
23 NOTES:
24
25 OPEN ISSUES:
26
27 CLOSED ISSUES:
28
29 CHANGE HISTORY:
30 ===========================================================================*/
31
32
33
34
35 procedure get_doc_type_lookup_code (X_doc_type_code IN VARCHAR2,
36 X_doc_subtype IN VARCHAR2,
37 X_def_doc_type_name IN OUT NOCOPY VARCHAR2,
38 X_def_type_lookup_code IN OUT NOCOPY VARCHAR2);
39
40
41
42 /*===========================================================================
43 PROCEDURE NAME: get_lookup_code_dsp ()
44
45 DESCRIPTION: This procedure gets the po lookup codes displayed value.
46
47 PARAMETERS: X_lookup_type IN VARCHAR2,
48 X_lookup_code IN VARCHAR2,
49 X_displayed_field IN OUT VARCHAR2
50
51
52 DESIGN REFERENCES:
53
54 ALGORITHM:
55
56 NOTES:
57
58 OPEN ISSUES:
59
60 CLOSED ISSUES:
61
62 CHANGE HISTORY: WLAU 11/06/95 Created
63 ===========================================================================*/
64 procedure get_lookup_code_dsp (X_lookup_type IN VARCHAR2,
65 X_lookup_code IN VARCHAR2,
66 X_lookup_code_dsp IN OUT NOCOPY VARCHAR2);
67
68
69 FUNCTION get_type_name -- <GA FPI>
70 ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
71 ) RETURN PO_DOCUMENT_TYPES_ALL.type_name%TYPE;
72
73 FUNCTION get_doc_num -- <GA FPI>
74 ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
75 ) RETURN PO_HEADERS_ALL.segment1%TYPE;
76
77 FUNCTION get_vendor_quote_num -- <GA FPI>
78 ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
79 ) RETURN PO_HEADERS_ALL.quote_vendor_quote_number%TYPE;
80
81
82 /*===========================================================================
83 FUNCTION NAME: val_vendor_has_contracts()
84
85 DESCRIPTION: This procedure gets the number of contracts
86 associated with the vendor on the Standard/Planned
87 PO.
88
89 PARAMETERS: X_Vendor_id IN number
90
91 RETURN VALUE: X_vendor_has_contracts boolean
92
93 DESIGN REFERENCES:
94
95 ALGORITHM:
96
97 NOTES:
98
99 OPEN ISSUES:
100
101 CLOSED ISSUES:
102
103 CHANGE HISTORY: SIYER 07/02/96 Created
104 ===========================================================================*/
105 function val_vendor_has_contracts (X_vendor_id IN NUMBER)
106 return varchar2;
107 -- pragma restrict_references (val_vendor_has_contracts, WNDS,RNPS,WNPS);
108
109
110 /*===========================================================================
111 PROCEDURE NAME: get_preparer_approve_flag ()
112
113 DESCRIPTION: This procedure gets the can_prepare_approve_flag from
114 the po_document_types table.
115
116 PARAMETERS: X_document_type IN VARCHAR2,
117 X_document_subtype IN VARCHAR2,
118 X_can_preparer_approve_flag IN OUT VARCHAR2
119
120
121 DESIGN REFERENCES:
122
123 ALGORITHM:
124
125 NOTES:
126
127 OPEN ISSUES:
128
129 CLOSED ISSUES:
130
131 CHANGE HISTORY: WLAU 07/12/96 Created
132 ===========================================================================*/
133
134 PROCEDURE get_preparer_approve_flag
135 (X_document_type IN VARCHAR2,
136 X_document_subtype IN VARCHAR2,
137 X_can_preparer_approve_flag IN OUT NOCOPY VARCHAR2);
138
139
140 FUNCTION cumulative_lines_exist -- <2706225>
141 ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
142 ) RETURN BOOLEAN;
143
144 /*
145 FUNCTION references_exist -- <GA FPI>
146 ( p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE
147 ) RETURN BOOLEAN;
148 */
149
150 -- <GC FPJ START>
151
152 PROCEDURE is_contract_valid
153 ( p_po_header_id IN NUMBER,
154 x_result OUT NOCOPY VARCHAR2
155 );
156
157 -- <GC FPJ END>
158
159 END PO_HEADERS_SV4;