PACKAGE: APPS.PMI_COST_ANALZ_PACK

Source

1 PACKAGE pmi_cost_analz_pack as
2 /* $Header: PMICTANS.pls 120.0 2005/05/24 16:55:19 appldev noship $ */
3         Pkg_var_Batch_id gme_batch_header.batch_id%TYPE:=0;
4         Pkg_var_Scale_factor_v NUMBER;
5         Pkg_var_b NUMBER;
6         Pkg_var_fm_qty_v		fm_matl_dtl.qty%TYPE := 0;
7 	Pkg_var_fm_qty_um_v		sy_uoms_mst.um_code%TYPE := ' ';
8 	Pkg_var_pm_qty_v		gme_material_details.plan_qty%TYPE := 0;
9 	pkg_var_pm_qty_um_v		sy_uoms_mst.um_code%TYPE := ' ';
10 	Pkg_var_all_linear              boolean;
11 
12 
13 	FUNCTION gmca_get_cost( item_id_vi		IN ic_item_mst.item_id%TYPE,
14 		inv_whse_code_vi	IN cm_cmpt_dtl.whse_code%TYPE,
15 		cost_mthd_code_vi	IN cm_cmpt_dtl.cost_mthd_code%TYPE,
16 		cost_date_vi		IN DATE)
17 	RETURN NUMBER;
18 
19 	FUNCTION gmca_get_perbal(
20 		tr_date_vi IN DATE,
21             co_code_vi IN sy_orgn_mst.co_code%TYPE,
22 		whse_code_vi IN ic_perd_bal.whse_code%TYPE,
23 		item_id_vi IN ic_perd_bal.item_id%TYPE)
24 	RETURN NUMBER;
25 
26 	FUNCTION gmca_get_line_type(
27 		item_id_vi IN ic_perd_bal.item_id%TYPE)
28 	RETURN NUMBER;
29 
30 	FUNCTION gmca_inv_perend(
31 		orgn_code_vi IN ic_cldr_dtl.orgn_code%TYPE,
32 		fiscal_year_vi IN ic_cldr_dtl.fiscal_year%TYPE,
33 		period_vi IN ic_cldr_dtl.period%TYPE)
34 	RETURN DATE;
35 
36 	FUNCTION gmca_variance(
37 	batch_id_vi		IN gme_batch_header.batch_id%TYPE,
38 	formula_id_vi		IN fm_form_mst.formula_id%TYPE,
39 	batch_line_id_vi	IN gme_material_details.material_detail_id%TYPE,
40 	cost_mthd_vi		IN cm_cmpt_dtl.cost_mthd_code%TYPE,
41         plan_qty_vi             IN gme_material_details.plan_qty%TYPE,
42         item_um_vi              IN gme_material_details.item_um%TYPE,
43         line_type_vi            IN gme_material_details.line_type%TYPE,
44         line_no_vi              IN gme_material_details.line_no%TYPE,
45         batch_status_vi         IN gme_batch_header.batch_status%TYPE,
46         actual_cmplt_date_vi    IN gme_batch_header.actual_cmplt_date%TYPE,
47         batch_close_date_vi     IN gme_batch_header.batch_close_date%TYPE,
48         wip_whse_code_vi        IN gme_batch_header.wip_whse_code%TYPE,
49         item_id_vi              IN gme_material_details.item_id%TYPE,
50         formulaline_id_vi       IN gme_material_details.formulaline_id%TYPE,
51         actual_qty_vi           IN gme_material_details.actual_qty%TYPE)
52 	RETURN NUMBER;
53 
54 
55 	FUNCTION gmca_get_onhandqty(p_whse_code IN ic_loct_inv.whse_code%TYPE,
56                             p_item_id   IN ic_loct_inv.item_id%TYPE,
57                             P_Location  IN ic_loct_inv.location%TYPE,
58                             p_lot_id    IN ic_loct_inv.lot_id%TYPE )  RETURN NUMBER;
59 
60       FUNCTION gmca_get_meaning(p_lookup_typ  IN gem_lookups.lookup_type%TYPE,
61                           p_lookup_cd   IN gem_lookups.lookup_code%TYPE )  RETURN VARCHAR2;
62 
63 	FUNCTION gmca_iuomcv(item_id_vi Number ,
64 			lot_id_vi Number ,
65 			from_uom_vi Varchar2,
66 			from_qty_vi number)
67 	RETURN NUMBER ;
68 
69 	FUNCTION gmca_uomcv(item_id_vi Number ,
70 			lot_id_vi Number ,
71 			from_uom_vi Varchar2,
72 			from_qty_vi number,
73 			to_uom_vi varchar2 )
74 	RETURN NUMBER;
75 
76 	FUNCTION gmca_cost_whse(
77 		inv_whse_vi		IN cm_whse_asc.whse_code%TYPE,
78 		asc_date_vi		IN DATE)
79 	RETURN VARCHAR;
80 
81 	FUNCTION gmca_whse_currency(
82 		whse_code_vi IN ic_whse_mst.whse_code%TYPE)
83 	RETURN VARCHAR2;
84 
85 END;