PACKAGE: APPS.GMI_INVENTORY_CLOSE_CONC

Source

1 PACKAGE GMI_INVENTORY_CLOSE_CONC AUTHID CURRENT_USER AS
2 /* $Header: gmisubrs.pls 115.2 2002/10/25 18:21:42 jdiiorio noship $ */
3 
4 X_msg                       VARCHAR2(2000);
5 X_errmsg                    VARCHAR2(160);
6 x_close_err                 NUMBER := 0;
7 PROCEDURE RUN(
8 	errbuf     OUT NOCOPY VARCHAR2,
9 	retcode    OUT NOCOPY VARCHAR2,
10 	P_sequence    IN	VARCHAR2,
11 	P_fiscal_year IN	VARCHAR2,
12 	P_period      IN	VARCHAR2,
13 	P_period_id   IN	VARCHAR2,
14 	P_start_date  IN	VARCHAR2,
15 	P_end_date    IN	VARCHAR2,
16 	P_op_code     IN	VARCHAR2,
17 	P_orgn_code   IN	VARCHAR2,
18 	P_close_ind   IN	VARCHAR2);
19 
20 PROCEDURE inventory_close(pfiscal_year VARCHAR2,
21                               pprd_id      NUMBER,
22                               pperiod      NUMBER,
23                               pwhse_code   VARCHAR2,
24                               pop_code     NUMBER,
25                               pprd_start_date DATE,
26                               pprd_end_date   DATE);
27 
28 
29 /* Subtypes
30     ======== */
31 SUBTYPE enddate_type    IS ic_cldr_dtl.period_end_date%TYPE;
32 SUBTYPE orgn_type       IS ic_cldr_dtl.orgn_code%TYPE;
33 SUBTYPE whse_type       IS ic_whse_mst.whse_code%TYPE;
34 --SUBTYPE period_type     IS ic_whse_sts.period%TYPE;
35 SUBTYPE item_srg_type   IS ic_item_mst.item_id%TYPE;
36 SUBTYPE lot_srg_type    IS ic_lots_mst.lot_id%TYPE;
37 SUBTYPE location_type   IS ic_loct_mst.location%TYPE;
38 SUBTYPE doc_type        IS ic_tran_pnd.doc_type%TYPE;
39 SUBTYPE ln_type         IS ic_tran_pnd.line_type%TYPE;
40 SUBTYPE reasoncode_type IS ic_tran_pnd.reason_code%TYPE;
41 SUBTYPE trans_srg_type  IS ic_tran_pnd.trans_id%TYPE;
42 SUBTYPE quantity_type   IS ic_loct_inv.loct_onhand%TYPE;
43 
44 /* Constants
45    ========= */
46 ss_debug CONSTANT INTEGER := 1;
47 
48 /* Constant Return Error Codes:
49 =============================== */
50 INVCAL_FISCALYR_ERR       CONSTANT INTEGER := -21;
51 INVCAL_PERIOD_ERR         CONSTANT INTEGER := -22;
52 INVCAL_PERIOD_CLOSED      CONSTANT INTEGER := -23;
53 INVCAL_CO_ERR             CONSTANT INTEGER := -24;
54 INVCAL_WHSE_CLOSED        CONSTANT INTEGER := -25;
55 INVCAL_DATE_PARM_ERR      CONSTANT INTEGER := -26;
56 INVCAL_ORGN_PARM_ERR      CONSTANT INTEGER := -27;
57 INVCAL_WHSE_PARM_ERR      CONSTANT INTEGER := -28;
58 INVCAL_WHSE_ERR           CONSTANT INTEGER := -29;
59 INVCAL_WHSESTS_UPDATE_ERR CONSTANT INTEGER := -30;
60 INVCAL_PRDSTS_UPDATE_ERR  CONSTANT INTEGER := -31;
61 
62 ORGN_CO_ERR               CONSTANT INTEGER := -41;
63 ORGN_VAL_ERR              CONSTANT INTEGER := -42;
64 
65 END;