[Home] [Help]
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;