1 PACKAGE BODY pmi_common_pkg as
2 /* $Header: PMICOMMB.pls 120.1 2011/09/14 18:16:37 sisankar ship $ */
3
4 FUNCTION PMICO_GET_COST( p_Item_id IN ic_item_mst.item_id%TYPE,
5 p_Whse_code IN ic_whse_mst.whse_code%TYPE,
6 p_Cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,
7 p_Transaction_date IN DATE)
8 RETURN NUMBER
9 IS
10 l_total_cost NUMBER;
11 BEGIN
12 return null;
13 END PMICO_GET_COST;
14
15 FUNCTION PMICO_GET_MULCURR_AMT( p_From_Curr IN gl_curr_mst.currency_code%TYPE,
16 p_To_Curr IN gl_curr_mst.currency_code%TYPE,
17 p_Rate_date IN DATE,
18 p_amount IN NUMBER)
19 RETURN NUMBER IS
20 l_converted_amount number;
21 BEGIN
22 return null;
23 END PMICO_GET_MULCURR_AMT;
24
25 FUNCTION PMICO_CURRCONV_ERROR( p_From_Curr IN gl_curr_mst.currency_code%TYPE,
26 p_To_Curr IN gl_curr_mst.currency_code%TYPE,
27 p_Rate_date IN DATE)
28 RETURN NUMBER IS
29 l_exchange_rate NUMBER;
30 BEGIN
31 return null;
32 END PMICO_CURRCONV_ERROR;
33
34 FUNCTION PMICO_GET_TARGET(p_target_shortname VARCHAR2,
35 p_ORG_LVL_ID VARCHAR2,
36 p_DIM1_LVL_ID VARCHAR2,
37 p_period_type VARCHAR2,
38 P_period_set_name VARCHAR2,
39 p_plan_id NUMBER,
40 p_from_date DATE,
41 p_to_date DATE,
42 p_param_view_by NUMBER,
43 p_period_num NUMBER)
44 RETURN NUMBER IS
45 l_exchange_rate NUMBER;
46 BEGIN
47 return null;
48 END PMICO_GET_TARGET;
49 END pmi_common_pkg;