1 PACKAGE PO_LINE_TYPES_SV AUTHID CURRENT_USER as
2 /* $Header: POXSTLTS.pls 115.7 2003/10/03 22:14:31 jmcfadde ship $ */
3 /*===========================================================================
4 PACKAGE NAME: PO_LINE_TYPES_SV
5
6 DESCRIPTION: This package contains the Line Type server side
7 Application Program Interfaces (APIs).
8
9 CLIENT/SERVER: Server
10
11 OWNER: Melissa Snyder
12
13 PROCEDURE NAMES: test_get_line_type_def()
14 get_line_type_def()
15 get_line_type()
16 val_line_type()
17 is_outside_processing
18 ===========================================================================*/
19
20
21 /*===========================================================================
22 FUNCTION NAME: val_line_type()
23
24 DESCRIPTION: This function checks whether a given Line Type is
25 still active.
26
27
28 PARAMETERS: X_line_type_id IN NUMBER
29
30 RETURN TYPE: BOOLEAN
31
32 DESIGN REFERENCES:
33
34 ALGORITHM:
35
36 NOTES:
37
38 OPEN ISSUES:
39
40 CLOSED ISSUES:
41
42 CHANGE HISTORY: Created 09-JUL-1995 LBROADBE
43 Changed to 14-AUG-1995 LBROADBE
44 Function
45 ===========================================================================*/
46 FUNCTION val_line_type(X_line_type_id IN NUMBER) return BOOLEAN;
47
48 /*===========================================================================
49 PROCEDURE NAME: get_line_type_def()
50
51 DESCRIPTION: Gets the following line type dependant defaults:
52 o order_type_lookup_code (Amount, Quantity)
53 o category_id
54 o unit_of_measure
55 o unit_price
56 o outside operation flag
57 o receiving_flag (PO)
58 o receive close tolerance (PO)
59
60 PARAMETERS: X_Line_Type_Id IN NUMBER
61 X_Order_Type_Lookup_Code IN OUT VARCHAR2
62 X_Category_Id IN OUT NUMBER
63 X_Unit_Meas_Lookup_Code IN OUT VARCHAR2
64 X_Unit_Price IN OUT NUMBER
65 X_Outside_Operations_Flag IN OUT VARCHAR2
66 X_Receiving_Flag IN OUT VARCHAR2
67 -- Bug: 1157232 Added receive close tolerance to the list of parameters
68 X_Receive_close_tolerance IN OUT NUMBER
69
70 DESIGN REFERENCES: ../POXPOMPO.doc
71 ../POXRQERQ.doc
72 ../POXSCERQ.dd
73
74 ALGORITHM:
75
76 NOTES:
77
78 OPEN ISSUES:
79
80 CLOSED ISSUES:
81
82 CHANGE HISTORY: Created 03-MAY-95 MSNYDER
83 ===========================================================================*/
84
85 PROCEDURE test_get_line_type_def
86 (X_Line_Type_Id IN NUMBER);
87
88 PROCEDURE get_line_type_def -- <SERVICES FPJ>
89 ( p_line_type_id IN NUMBER
90 , x_order_type_lookup_code OUT NOCOPY VARCHAR2
91 , x_purchase_basis OUT NOCOPY VARCHAR2
92 , x_matching_basis OUT NOCOPY VARCHAR2
93 , x_category_id OUT NOCOPY NUMBER
94 , x_unit_meas_lookup_code OUT NOCOPY VARCHAR2
95 , x_unit_price OUT NOCOPY NUMBER
96 , x_outside_operations_flag OUT NOCOPY VARCHAR2
97 , x_receiving_flag OUT NOCOPY VARCHAR2
98 , x_receive_close_tolerance OUT NOCOPY NUMBER
99 );
100
101 PROCEDURE get_line_type_def -- <SERVICES FPJ>
102 ( p_line_type_id IN NUMBER
103 , x_order_type_lookup_code OUT NOCOPY VARCHAR2
104 , x_purchase_basis OUT NOCOPY VARCHAR2
105 , x_category_id OUT NOCOPY NUMBER
106 , x_unit_meas_lookup_code OUT NOCOPY VARCHAR2
107 , x_unit_price OUT NOCOPY NUMBER
108 , x_outside_operations_flag OUT NOCOPY VARCHAR2
109 , x_receiving_flag OUT NOCOPY VARCHAR2
110 , x_receive_close_tolerance OUT NOCOPY NUMBER
111 );
112
113 PROCEDURE get_line_type_def -- <SERVICES FPJ>
114 ( p_line_type_id IN NUMBER
115 , x_order_type_lookup_code OUT NOCOPY VARCHAR2
116 , x_purchase_basis OUT NOCOPY VARCHAR2
117 , x_matching_basis OUT NOCOPY VARCHAR2
118 , x_outside_operation_flag OUT NOCOPY VARCHAR2
119 );
120
121 PROCEDURE get_line_type_def
122 (X_Line_Type_Id IN NUMBER,
123 X_Order_Type_Lookup_Code IN OUT NOCOPY VARCHAR2,
124 X_Category_Id IN OUT NOCOPY NUMBER,
125 X_Unit_Meas_Lookup_Code IN OUT NOCOPY VARCHAR2,
126 X_Unit_Price IN OUT NOCOPY NUMBER,
127 X_Outside_Operations_Flag IN OUT NOCOPY VARCHAR2,
128 X_Receiving_Flag IN OUT NOCOPY VARCHAR2 ,
129 X_Receive_close_tolerance IN OUT NOCOPY NUMBER);
130
131
132 /*===========================================================================
133 FUNCTION NAME: get_line_type
134
135 DESCRIPTION: This function returns the line type for
136 a specific line type id.
137
138 PARAMETERS: X_Line_Type_Id IN NUMBER
139
140
141 DESIGN REFERENCES:
142
143 ALGORITHM:
144
145 NOTES:
146
147 OPEN ISSUES:
148
149 CLOSED ISSUES:
150
151 CHANGE HISTORY: Created 18-MAY-95 RMULPURY
152 ===========================================================================*/
153
154 FUNCTION get_line_type (x_line_type_id IN NUMBER)
155 return varchar2;
156
157
158
159 FUNCTION outside_processing_items_exist ( p_po_header_id NUMBER ) -- <GA FPI>
160 RETURN BOOLEAN;
161
162 FUNCTION is_outside_processing_item ( p_item_id NUMBER -- <GA FPI>
163 , p_org_id NUMBER )
164 RETURN BOOLEAN;
165
166 FUNCTION is_outside_processing ( p_line_type_id NUMBER ) -- <GA FPI>
167 RETURN BOOLEAN;
168
169 FUNCTION transactions_exist ( p_line_type_id NUMBER ) -- <SERVICES FPJ>
170 RETURN VARCHAR2;
171
172
173 END PO_LINE_TYPES_SV;