[Home] [Help]
PACKAGE: APPS.GMIGUTL
Source
1 PACKAGE GMIGUTL AUTHID CURRENT_USER AS
2 /* $Header: GMIGUTLS.pls 115.8 2002/11/11 21:07:25 jdiiorio ship $
3 +==========================================================================+
4 | Copyright (c) 1998 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +==========================================================================+
8 | FILE NAME |
9 | GMIGUTLB.pls |
10 | |
11 | PACKAGE NAME |
12 | GMIGUTL |
13 | |
14 | DESCRIPTION |
15 | This Package contains global inventory utility procedures and |
16 | and variables. |
17 | |
18 | HISTORY |
19 | Joe DiIorio 10/23/2001 11.5.1H BUG#1989860 |
20 | Removed SY$INTRASTAT. |
21 | Tony Cataldo 11/07/2002/2002 11.5.1J Bug #2343411 |
22 | Added IC$DEFAULT_LOT_DESC |
23 | Joe DiIorio 11/11/2002 11.5.1J BUG#2643440 - added nocopy. |
24 +==========================================================================+
25 */
26 DEFAULT_USER fnd_user.user_name%TYPE;
27 API_VERSION NUMBER;
28 DEFAULT_USER_ID fnd_user.user_id%TYPE;
29 DEFAULT_LOGIN NUMBER;
30 IC$DEFAULT_LOT VARCHAR2(32);
31 IC$DEFAULT_LOT_DESC NUMBER; -- Bug 2343411
32 IC$DEFAULT_LOCT VARCHAR2(32);
33 IC$ALLOWNEGINV VARCHAR2(32);
34 IC$API_ALLOW_INACTIVE VARCHAR2(32);
35 IC$MOVEDIFFSTAT VARCHAR2(32);
36 SY$CPG_INSTALL VARCHAR2(32);
37 DB_ERRNUM NUMBER;
38 DB_ERRMSG VARCHAR2(2000);
39
40 FUNCTION Setup (p_user_name VARCHAR2) RETURN BOOLEAN;
41
42 FUNCTION v_expaction_code
43 ( p_action_code IN qc_actn_mst.action_code%TYPE
44 , x_qc_actn_mst_row OUT NOCOPY qc_actn_mst%ROWTYPE
45 )
46 RETURN BOOLEAN;
47
48 FUNCTION v_qc_grade
49 ( p_qc_grade IN qc_grad_mst.qc_grade%TYPE
50 , x_qc_grad_mst_row OUT NOCOPY qc_grad_mst%ROWTYPE
51 )
52 RETURN BOOLEAN;
53
54 FUNCTION v_reason_code
55 ( p_reason_code IN sy_reas_cds.reason_code%TYPE
56 , x_sy_reas_cds_row OUT NOCOPY sy_reas_cds%ROWTYPE
57 )
58 RETURN BOOLEAN;
59
60 FUNCTION v_ship_vendor
61 ( p_vendor_no IN po_vend_mst.vendor_no%TYPE
62 , x_po_vend_mst_row OUT NOCOPY po_vend_mst%ROWTYPE
63 )
64 RETURN BOOLEAN;
65
66 PROCEDURE Get_Item
67 ( p_item_no IN ic_item_mst.item_no%TYPE
68 , x_ic_item_mst_row OUT NOCOPY ic_item_mst%ROWTYPE
69 , x_ic_item_cpg_row OUT NOCOPY ic_item_cpg%ROWTYPE
70 );
71
72 PROCEDURE Get_Lot
73 ( p_item_id IN ic_lots_mst.item_id%TYPE
74 , p_lot_no IN ic_lots_mst.lot_no%TYPE
75 , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
76 , x_ic_lots_mst_row OUT NOCOPY ic_lots_mst%ROWTYPE
77 , x_ic_lots_cpg_row OUT NOCOPY ic_lots_cpg%ROWTYPE
78 );
79
80 PROCEDURE Get_Warehouse
81 ( p_whse_code IN ic_whse_mst.whse_code%TYPE
82 , x_ic_whse_mst_row OUT NOCOPY ic_whse_mst%ROWTYPE
83 );
84
85 PROCEDURE Get_Loct_inv
86 ( p_item_id IN ic_loct_inv.item_id%TYPE
87 , p_whse_code IN ic_loct_inv.whse_code%TYPE
88 , p_lot_id IN ic_loct_inv.lot_id%TYPE
89 , p_location IN ic_loct_inv.location%TYPE
90 , x_ic_loct_inv_row OUT NOCOPY ic_loct_inv%ROWTYPE
91 );
92
93 PROCEDURE Get_Um
94 ( p_um_code IN sy_uoms_mst.um_code%TYPE
95 , x_sy_uoms_mst_row OUT NOCOPY sy_uoms_mst%ROWTYPE
96 , x_sy_uoms_typ_row OUT NOCOPY sy_uoms_typ%ROWTYPE
97 );
98
99 /*
100 PROCEDURE Get_Transfer
101 ( p_orgn_code IN ic_xfer_mst.orgn_code%TYPE
102 , p_transfer_no IN ic_xfer_mst.transfer_no%TYPE
103 , x_ic_xfer_mst_row OUT NOCOPY ic_xfer_mst%ROWTYPE
104 );
105
106 */
107
108 FUNCTION v_Lot_status
109 ( p_lot_status IN ic_lots_sts.lot_status%TYPE
110 , x_ic_lots_sts_row OUT NOCOPY ic_lots_sts%ROWTYPE
111 )
112 RETURN BOOLEAN;
113
114 END GMIGUTL;