PACKAGE: APPS.GMF_SUBLED_REP_PKG

Source

1 PACKAGE gmf_subled_rep_pkg AUTHID CURRENT_USER AS
2 /* $Header: GMFDSURS.pls 120.1.12010000.2 2008/11/11 16:26:42 rpatangy ship $ */
3 
4  FUNCTION BeforeReportTrigger RETURN BOOLEAN;
5   /* Report parameters */
6         P_REFERENCE_NO    gmf_xla_extract_headers.reference_no%TYPE;
7         P_LEGAL_ENTITY    gmf_xla_extract_headers.legal_entity_id%TYPE;
8         P_LEDGER          gmf_xla_extract_headers.ledger_id%TYPE;
9         P_COST_TYPE       gmf_xla_extract_headers.valuation_cost_type_id%TYPE;
10         P_FISCAL_YEAR     NUMBER;
11         P_PERIOD          NUMBER;
12         P_START_DATE      gmf_xla_extract_headers.transaction_date%TYPE;
13         P_END_DATE        gmf_xla_extract_headers.transaction_date%TYPE;
14         P_ENTITY_CODE     gmf_xla_extract_headers.entity_code%TYPE;
15         P_EVENT_CLASS     gmf_xla_extract_headers.event_class_code%TYPE;
16         P_EVENT_TYPE      gmf_xla_extract_headers.event_type_code%TYPE;
17 
18         p_where_clause  VARCHAR2(2000);
19 /*
20  FUNCTION BeforeReportTrigger(P_REFERENCE_NO  IN NUMBER,
21                                 P_LEGAL_ENTITY  IN NUMBER,
22                                 P_LEDGER        IN NUMBER,
23                                 P_COST_TYPE     IN NUMBER,
24                                 P_FISCAL_YEAR   IN NUMBER,
25                                 P_PERIOD        IN NUMBER,
26                                 P_START_DATE    IN DATE,
27                                 P_END_DATE      IN DATE,
28                                 P_ENTITY_CODE   IN VARCHAR2,
29                                 P_EVENT_CLASS   IN VARCHAR2,
30                                 P_EVENT_TYPE    IN VARCHAR2) RETURN VARCHAR2;
31 */
32 
33 
34  FUNCTION get_le_name(p_le_id IN NUMBER) RETURN VARCHAR2;
35 
36  FUNCTION get_ledger_name(p_led_id IN NUMBER) RETURN VARCHAR2;
37 
38  FUNCTION get_cost_type(p_ct_id IN NUMBER) RETURN VARCHAR2;
39 
40  FUNCTION get_organization_code (p_org_id IN NUMBER,p_ref_no IN NUMBER) RETURN VARCHAR2;
41 
42  FUNCTION get_item_desc( p_item_id IN NUMBER, p_org_id IN NUMBER) RETURN  VARCHAR2;
43 
44  FUNCTION get_org_name( p_org_id IN NUMBER) RETURN  VARCHAR2;
45 
46  FUNCTION get_entity_code_desc(p_entity_cd IN VARCHAR2) RETURN VARCHAR2;
47 
48  FUNCTION get_event_class_desc(p_entity_cd IN VARCHAR2, p_event_class_cd IN VARCHAR2) RETURN VARCHAR2;
49 
50  FUNCTION get_event_type_desc(p_entity_cd IN VARCHAR2, p_event_class_cd IN VARCHAR2,p_event_type_cd IN VARCHAR2) RETURN VARCHAR2;
51 
52  FUNCTION get_where_clause  RETURN VARCHAR2;
53 
54 END gmf_subled_rep_pkg;