PACKAGE: APPS.GMF_CBOM_REP_PKG

Source

1 PACKAGE gmf_cbom_rep_pkg AS
2 /* $Header: GMFIBOMS.pls 120.2 2007/12/17 10:22:49 pmarada noship $ */
3 
4        p_where_clause  VARCHAR2(2000);
5 FUNCTION BeforeReportTrigger RETURN BOOLEAN ;
6 
7 FUNCTION Get_Quantity (
8  p_invy_item_id        IN NUMBER,
9  p_prod_invy_item_id   IN NUMBER,
10  p_prod_ingr_ind       IN VARCHAR2,  -- values 'P', 'I', or 'B'
11  p_organization_id     IN NUMBER ,
12  p_cost_type_id        IN NUMBER ,
13  p_period_id           IN NUMBER
14 ) RETURN VARCHAR2 ;
15 
16 FUNCTION get_le_name(p_le_id IN NUMBER) RETURN VARCHAR2;
17 
18 FUNCTION get_currency(p_le_id IN NUMBER) RETURN VARCHAR2;
19 
20 FUNCTION get_cost_type(p_ct_id IN NUMBER) RETURN VARCHAR2;
21 
22 FUNCTION get_OrderBy (p_sort_by IN NUMBER) RETURN VARCHAR2;
23 
24 FUNCTION get_Period_Id(p_legal_entity_id IN NUMBER, p_calendar_code IN VARCHAR2, p_period_code IN VARCHAR2, p_cost_type_id IN NUMBER) RETURN NUMBER ;
25 
26 FUNCTION get_item_name(v_item_id IN NUMBER) RETURN VARCHAR2 ;
27 
28 FUNCTION get_category_name(v_cat_id IN NUMBER) RETURN VARCHAR2 ;
29 
30 FUNCTION get_Category (p_from_cat IN VARCHAR2,p_to_cat IN VARCHAR2) RETURN VARCHAR2 ;
31 
32 END gmf_cbom_rep_pkg;