PACKAGE: APPS.GMICDEP

Source

1 PACKAGE GMICDEP AS
2 /* $Header: gmicdeps.pls 120.0 2005/05/25 16:07:23 appldev noship $ */
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 DEP_COST_FISCAL_POLICY_ERR CONSTANT INTEGER := -251;
26 DEP_COST_UPDATE_ERR        CONSTANT INTEGER := -252;
27 
28 /* Functions and Procedures
29 ========================*/
30 FUNCTION calc_costs(pwhse_code     VARCHAR2,
31                     pprd_end_date  DATE,
32                     pperiod        NUMBER,
33                     pfiscal_year   VARCHAR2,
34                     pop_code       NUMBER) RETURN NUMBER;
35 
36 END;