1 PACKAGE PO_ITEMS_SV1 AS
2 /* $Header: POXPISIS.pls 120.0.12000000.1 2007/01/16 23:04:39 appldev ship $ */
3
4 /*==================================================================
5 FUNCTION NAME: val_item_id()
6
7 DESCRIPTION: This API is used to validate x_item_id specified
8 is valid and active.
9
10 PARAMETERS: x_item_id IN NUMBER,
11 x_organization_id IN NUMBER,
12 x_outside_operation_flag IN VARCAHR2
13 DESIGN
14 REFERENCES: 832vlapl.doc
15
16 ALGORITHM: API returns TRUE if validation succeeds, FALSE
17 otherwise.
18
19 NOTES:
20
21 OPEN ISSUES:
22
23 CLOSE ISSUES:
24
25 CHANGE
26 HISTORY: Created 19-FEB-1996 DXYU
27
28
29 =======================================================================*/
30 FUNCTION val_item_id(x_item_id IN NUMBER,
31 x_organization_id IN NUMBER,
32 x_outside_operation_flag IN VARCHAR2) RETURN BOOLEAN;
33
34
35 /*==================================================================
36 FUNCTION NAME: derive_item_id()
37
38 DESCRIPTION: This API is used to derive inventory_item_id
39 either
40 1) Given item_number(segment values - flex
41 code = 'MSTK') and organization_id as
42 input parameters.
43 2) If item_number is not specified, it will try to
44 derive inventory_item_id using X_vendor_id and
45 X_vendor_product_num specified in the input
46 parameters.
47 This API will not check if the item is active.
48
49 PARAMETERS: x_item_number IN VARCHAR2,
50 X_vendor_product_num IN VARCHAR2,
51 X_vendor_id IN NUMBER,
52 X_organization_id IN VARCHAR2,
53 X_error_code IN OUT VARCHAR2
54
55 DESIGN
56 REFERENCES: 832dvapl.doc
57
58 ALGORITHM: API returns item_id (NUMBER) if validation succeeds,
59 NULL otherwise.
60
61 NOTES:
62
63 OPEN ISSUES:
64
65 CLOSE ISSUES:
66
67 CHANGE
68 HISTORY: Created 19-FEB-1996 SODAYAR
69 Modified 12-MAR-1996 DXYU
70
71 =======================================================================*/
72 FUNCTION derive_item_id(X_item_number IN VARCHAR2,
73 X_vendor_product_num IN VARCHAR2,
74 X_vendor_id IN NUMBER,
75 X_organization_id IN VARCHAR2,
76 X_error_code IN OUT NOCOPY VARCHAR2)
77 return NUMBER;
78
79 END PO_ITEMS_SV1;