1 PACKAGE PO_LINE_LOCATIONS_SV1 AUTHID CURRENT_USER AS
2 /* $Header: POXPILLS.pls 120.0.12010000.1 2008/09/18 12:20:47 appldev noship $ */
3
4
5 /*==================================================================
6 FUNCTION NAME: val_shipment_num()
7
8 DESCRIPTION: This API is used to validate the uniqueness of
9 shipment num in po_lines table.
10
11 PARAMETERS: x_shipment_num IN NUMBER,
12 x_shipment_type IN VARCHAR2,
13 x_po_header_id IN NUMBER,
14 x_po_line_id IN NUMBER,
15 x_rowid IN VARCHAR2
16
17
18 DESIGN
19 REFERENCES: 832vlapl.doc
20
21 ALGORITHM: API returns TRUE if validation succeeds, FALSE
22 otherwise.
23
24 NOTES:
25
26 OPEN ISSUES:
27
28 CLOSE ISSUES:
29
30 CHANGE
31 HISTORY: Created 19-FEB-1996 DXYU
32
33
34 =======================================================================*/
35 FUNCTION val_shipment_num(x_shipment_num IN NUMBER,
36 x_shipment_type IN VARCHAR2,
37 x_po_header_id IN NUMBER,
38 x_po_line_id IN NUMBER,
39 x_rowid IN VARCHAR2) RETURN BOOLEAN;
40
41
42 /*======================================================================
43 FUNCTION NAME: val_shipment_type()
44
45 DESCRIPTION: This API is used to validate shipment type and
46 make sure it is valid and active.
47
48 PARAMETERS: x_shipmetn_type IN VARCHAR2
49
50 DESIGN REFERENCES: 832vlapl.doc
51
52 ALGORITHM: API returns TRUE if validation succeeds, FALSE
53 otherwise.
54
55 NOTES:
56
57 OPEN ISSUES:
58
59 CLOSE ISSUES:
60
61 CHANGE HISTORY: Created 19-FEB-1996 DXYU
62
63 =======================================================================*/
64 FUNCTION val_shipment_type(x_shipment_type IN VARCHAR2,
65 x_lookup_code IN VARCHAR2) RETURN BOOLEAN;
66
67
68 /*======================================================================
69 FUNCTION NAME: derive_line_location_id()
70
71 DESCRIPTION: This API is used to derive lin_locaiton_id.
72
73 PARAMETERS: x_po_header_id IN NUMBER,
74 x_po_line_id IN NUMBER
75
76 DESIGN REFERENCES: 832dvapi.doc
77
78 ALGORITHM: API returns line_location_id (NUMBER) if found,
79 NULL otherwise.
80
81 NOTES:
82
83 OPEN ISSUES:
84
85 CLOSE ISSUES:
86
87 CHANGE HISTORY: Created 19-FEB-1996 SODAYAR
88
89 =======================================================================*/
90 FUNCTION derive_line_location_id(X_po_header_id IN NUMBER,
91 X_po_line_id IN NUMBER,
92 X_shipment_num IN NUMBER) return NUMBER;
93
94 /*==================================================================
95 FUNCTION NAME: derive_location_id()
96
97 DESCRIPTION: This API is used to derive location_id given
98 location_code and location_usage as the input
99 parameter.
100
101 PARAMETERS: X_location_code IN VARCHAR2
102 X_location_usage IN VARCHAR2
103
104 DESIGN
105 REFERENCES: 832dvapi.dd
106
107 ALGORITHM: API returns location_id (NUMBER) if found, NULL
108 otherwise.
109
110 NOTES: Valid value for X_locaiton_usage are :
111 'SHIP_TO'
112 'BILL_TO'
113 'RECEIVING'
114 'OFFICE'
115
116 OPEN ISSUES:
117
118 CLOSE ISSUES:
119
120 CHANGE
121 HISTORY: Created 03-Mar-1996 Rajan
122 modified 13-MAR-1996 Daisy Yu
123
124 =======================================================================*/
125
126 FUNCTION derive_location_id(X_location_code IN VARCHAR2,
127 X_location_usage IN VARCHAR2) return NUMBER;
128
129 /*==================================================================
130 FUNCTION NAME: val_location_id()
131
132 DESCRIPTION: This API is used to validate whether the location
133 specified in x_location_id is an active and valid
134 location for a specific vendor site. It also checks
135 whether the location is the correct bill_to/ship_to/
136 receiving/office site (depend on x_location_usage)
137
138 PARAMETERS: x_location_id IN NUMBER
139 x_location_type IN VARCHAR2
140
141 DESIGN
142 REFERENCES: 832vlapi.doc
143
144 ALGORITHM: API returns TRUE if validation succeeds, FALSE
145 otherwise.
146
147 NOTES: Valid value for X_locaiton_type are :
148 'SHIP_TO'
149 'BILL_TO'
150 'RECEIVING'
151 'OFFICE'
152
153 OPEN ISSUES:
154
155 CLOSE ISSUES:
156
157 CHANGE
158 HISTORY: Created 03-Mar-1996 Rajan
159
160
161 =======================================================================*/
162 FUNCTION val_location_id(X_location_id IN NUMBER,
163 X_location_type IN VARCHAR2)
164 RETURN BOOLEAN;
165
166 END PO_LINE_LOCATIONS_SV1;