1 PACKAGE PO_VMI_GRP AUTHID CURRENT_USER as
2 --$Header: POXGVMIS.pls 115.4 2002/11/23 03:29:20 sbull noship $
3
4 --===============+============================================================+
5 --| Copyright (c) 2002 Oracle Corporation |
6 --| Redwood Shores, California, USA |
7 --| All rights reserved. |
8 --============================================================================+
9 --| |
10 --| FILENAME : POXGVMIS.pls |
11 --| |
12 --| DESCRIPTION: This package contains the function that return TRUE|
13 --| if there exist a VMI ASL within the Operating Unit |
14 --| |
15 --| FUNCTION/PROCEDURE: exist_vmi_asl |
16 --| |
17 --| HISTORY: 26-FEB-2002 : fdubois - Empty Stubb created |
18 --| 13-MAR-2002 : fdubois - Modified dbdrv command |
19 --| 15-APR-2002 : Fdubois - Added function for Global |
20 --| VMI ASL validation |
21 --|===========================================================================+
22
23
24 /*===========================================================================
25 FUNCTION NAME: exist_vmi_asl
26
27 DESCRIPTION: the function retunrs TRUE if there exist a VMI ASL
28 within the Operating Unit. If there are none it
29 returns FALSE
30
31 PARAMETERS: In:
32
33 RETURN: TRUE if exists VMI ASL
34
35 DESIGN REFERENCES: APXSSFSO_VMI_DLD.doc
36
37
38 CHANGE HISTORY: Created 26-FEB-02 FDUBOIS
39 ===========================================================================*/
40 FUNCTION exist_vmi_asl RETURN BOOLEAN;
41
42
43
44 /*===========================================================================
45 FUNCTION NAME: validate_global_vmi_asl
46
47 DESCRIPTION: the function retunrs TRUE if the Global ASL can be
48 VMI for the IN parameters (define the ASL). False
49 otherwize. It then also return the Validation Error
50 Message name
51
52 PARAMETERS: In: INVENTORY_ITEM_ID :Item identifier
53 SUPPLIER_SITE_ID : supplier site identifier
54
55 Out:VALIDATION_ERROR_NAME : Error message name
56
57 Return: TRUE if OK to have Global VMI ASL
58
59 DESIGN REFERENCES: MGD_VMI_ASL_DLD.rtf
60
61
62 CHANGE HISTORY: Created 15-APR-02 FDUBOIS
63 ===========================================================================*/
64 FUNCTION validate_global_vmi_asl ( x_inventory_item_id IN number ,
65 x_supplier_site_id IN number ,
66 x_validation_error_name OUT NOCOPY varchar2 )
67
68 RETURN BOOLEAN;
69
70
71 END PO_VMI_GRP;