PACKAGE: APPS.GMICCAL

Source

1 PACKAGE GMICCAL AUTHID CURRENT_USER AS
2 /* $Header: gmiccals.pls 115.2 2002/12/03 22:07:51 jdiiorio ship $ */
3 
4 /* Subtypes
5     ======== */
6 SUBTYPE enddate_type    IS ic_cldr_dtl.period_end_date%TYPE;
7 SUBTYPE orgn_type       IS ic_cldr_dtl.orgn_code%TYPE;
8 SUBTYPE whse_type       IS ic_whse_mst.whse_code%TYPE;
9 SUBTYPE period_type     IS ic_whse_sts.period%TYPE;
10 SUBTYPE item_srg_type   IS ic_item_mst.item_id%TYPE;
11 SUBTYPE lot_srg_type    IS ic_lots_mst.lot_id%TYPE;
12 SUBTYPE location_type   IS ic_loct_mst.location%TYPE;
13 SUBTYPE doc_type        IS ic_tran_pnd.doc_type%TYPE;
14 SUBTYPE ln_type         IS ic_tran_pnd.line_type%TYPE;
15 SUBTYPE reasoncode_type IS ic_tran_pnd.reason_code%TYPE;
16 SUBTYPE trans_srg_type  IS ic_tran_pnd.trans_id%TYPE;
17 SUBTYPE quantity_type   IS ic_loct_inv.loct_onhand%TYPE;
18 
19 /* Constants
20    ========= */
21 ss_debug CONSTANT INTEGER := 1;
22 
23 /* Constant Return Error Codes:
24 =============================== */
25 INVCAL_FISCALYR_ERR       CONSTANT INTEGER := -21;
26 INVCAL_PERIOD_ERR         CONSTANT INTEGER := -22;
27 INVCAL_PERIOD_CLOSED      CONSTANT INTEGER := -23;
28 INVCAL_CO_ERR             CONSTANT INTEGER := -24;
29 INVCAL_WHSE_CLOSED        CONSTANT INTEGER := -25;
30 INVCAL_DATE_PARM_ERR      CONSTANT INTEGER := -26;
31 INVCAL_ORGN_PARM_ERR      CONSTANT INTEGER := -27;
32 INVCAL_WHSE_PARM_ERR      CONSTANT INTEGER := -28;
33 INVCAL_WHSE_ERR           CONSTANT INTEGER := -29;
34 INVCAL_WHSESTS_UPDATE_ERR CONSTANT INTEGER := -30;
35 INVCAL_PRDSTS_UPDATE_ERR  CONSTANT INTEGER := -31;
36 
37 ORGN_CO_ERR               CONSTANT INTEGER := -41;
38 ORGN_VAL_ERR              CONSTANT INTEGER := -42;
39 
40 /* Functions and Procedures
41    ======================== */
42 FUNCTION trans_date_validate(trans_date DATE,
43                              porgn_code VARCHAR2,
44                              pwhse_code VARCHAR2) RETURN NUMBER;
45 
46 FUNCTION delete_ic_perd_bal(pfiscal_year VARCHAR2,
47                             pperiod      NUMBER,
48                             pwhse_code   VARCHAR2) RETURN NUMBER;
49 
50 FUNCTION insert_ic_perd_bal(pfiscal_year VARCHAR2,
51                             pper_id      NUMBER,
52                             pperiod      NUMBER,
53                             pwhse_code   VARCHAR2,
54                             pop_code     NUMBER) RETURN NUMBER;
55 
56 FUNCTION calc_usage_yield(pwhse_code VARCHAR2,
57                           pprd_start_date DATE,
58                           pprd_end_date   DATE,
59                           plog_end_date   DATE,
60                           pperiod         NUMBER,
61                           pprd_id         NUMBER,
62                           pfiscal_year    VARCHAR2,
63                           pop_code        NUMBER) RETURN NUMBER;
64 
65 FUNCTION whse_status_update(pwhse_code   VARCHAR2,
66                             pfiscal_year VARCHAR2,
67                             pperiod      NUMBER,
68                             pclose_type  NUMBER) RETURN NUMBER;
69 
70 FUNCTION period_status_update(pco_code     VARCHAR2,
71                               pfiscal_year VARCHAR2,
72                               pperiod      NUMBER) RETURN NUMBER;
73 
74 FUNCTION determine_company(porgn_code VARCHAR2,
75                            pout_co_code IN OUT NOCOPY VARCHAR2)
76                            RETURN NUMBER;
77 
78 END;