[Home] [Help]
PACKAGE: APPS.BIL_TX_UTIL_RPT_PKG
Source
1 PACKAGE BIL_TX_UTIL_RPT_PKG AUTHID CURRENT_USER AS
2 /* $Header: biltxuts.pls 120.9 2005/12/09 10:11 sgharago noship $ */
3
4
5
6 PROCEDURE GET_PAGE_PARAMS (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
7 p_region_id IN VARCHAR2,
8 x_period_type OUT NOCOPY VARCHAR2,
9 x_to_currency OUT NOCOPY VARCHAR2,
10 x_to_period_name OUT NOCOPY VARCHAR2,
11 x_sg_id OUT NOCOPY VARCHAR2,
12 x_resource_id OUT NOCOPY VARCHAR2,
13 x_frcst_owner OUT NOCOPY VARCHAR2,
14 x_prodcat_id OUT NOCOPY VARCHAR2,
15 x_item_id OUT NOCOPY VARCHAR2,
16 x_parameter_valid OUT NOCOPY BOOLEAN,
17 x_viewby OUT NOCOPY VARCHAR2,
18 x_order OUT NOCOPY VARCHAR2, -- Column on which data is sorted
19 x_rptby OUT NOCOPY VARCHAR2,
20 x_sls_chnl OUT NOCOPY VARCHAR2,
21 x_sls_stge OUT NOCOPY VARCHAR2,
22 x_opp_status OUT NOCOPY VARCHAR2,
23 x_source OUT NOCOPY VARCHAR2,
24 x_sls_methodology OUT NOCOPY VARCHAR2,
25 x_win_probability OUT NOCOPY VARCHAR2,
26 x_win_probability_opr OUT NOCOPY VARCHAR2,
27 x_close_reason OUT NOCOPY VARCHAR2,
28 x_competitor OUT NOCOPY VARCHAR2,
29 x_opty_number OUT NOCOPY VARCHAR2,
30 x_total_opp_amount OUT NOCOPY VARCHAR2,
31 x_total_opp_amt_opr OUT NOCOPY VARCHAR2,
32 x_opty_name OUT NOCOPY VARCHAR2,
33 x_customer OUT NOCOPY VARCHAR2,
34 x_partner OUT NOCOPY VARCHAR2,
35 x_from_date OUT NOCOPY DATE,
36 x_to_date OUT NOCOPY DATE);
37
38 PROCEDURE GET_DETAIL_PAGE_PARAMS
39 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
40 p_region_id IN VARCHAR2,
41 x_parameter_valid OUT NOCOPY BOOLEAN,
42 x_viewby OUT NOCOPY VARCHAR2,
43 x_lead_id OUT NOCOPY VARCHAR2,
44 x_cust_id OUT NOCOPY VARCHAR2,
45 x_credit_type_id OUT NOCOPY VARCHAR2 ) ;
46
47 /*
48 -- Removed , not used in ASN reports. Caused SQL Repository Shared Memory issues.
49 PROCEDURE GET_DEFAULT_QUERY(p_RegionName IN VARCHAR2,
50 x_SqlStr OUT NOCOPY VARCHAR2);
51 */
52
53
54
55 PROCEDURE GET_OTHER_PROFILES(x_DebugMode OUT NOCOPY VARCHAR2);
56
57 FUNCTION get_sales_group_id RETURN NUMBER;
58
59
60 FUNCTION chkLogLevel (p_log_level IN NUMBER) RETURN BOOLEAN;
61
62
63
64 PROCEDURE writeLog (p_log_level IN NUMBER,
65 p_module IN VARCHAR2,
66 p_msg IN VARCHAR2);
67
68
69 PROCEDURE writeQuery (p_pkg IN VARCHAR2,
70 p_proc IN VARCHAR2,
71 p_query IN VARCHAR2);
72
73
74
75 PROCEDURE PARSE_PRODCAT_ITEM_ID( p_prodcat_id IN OUT NOCOPY VARCHAR2,
76 p_item_id OUT NOCOPY VARCHAR2);
77
78 PROCEDURE PARSE_MULTI_SELECT(p_multi_select_string IN OUT NOCOPY VARCHAR,
79 p_single_select_flag OUT NOCOPY VARCHAR);
80
81 FUNCTION GET_DEF_PRD_TYPE RETURN VARCHAR2;
82
83 FUNCTION GET_DEFAULT_PERIOD RETURN VARCHAR2;
84
85 FUNCTION GET_DEFAULT_CURRENCY RETURN VARCHAR2;
86
87 FUNCTION GET_DEFAULT_RPT_BY RETURN NUMBER;
88
89 FUNCTION GET_FROM_DATE (p_from_period_name IN VARCHAR2) RETURN DATE;
90
91 FUNCTION GET_TO_DATE (p_to_period_name IN VARCHAR2) RETURN DATE;
92
93 FUNCTION GET_RESOURCE_ID RETURN NUMBER;
94
95 PROCEDURE days_in_status (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
96 asn_Table OUT NOCOPY BIS_MAP_TBL);
97
98 FUNCTION DEF_STRT_PRD RETURN NUMBER;
99
100 FUNCTION DEF_END_PRD RETURN NUMBER;
101
102 FUNCTION GET_DEF_FORCST_TYPE RETURN NUMBER;
103
104 FUNCTION get_prod_cat_id RETURN NUMBER;
105
106 FUNCTION GET_STATS_CODS_OPTY_FLGS(p_flgs IN VARCHAR2) RETURN VARCHAR2;
107
108 FUNCTION GET_WIN_PROB RETURN VARCHAR2;
109
110 FUNCTION IS_NUMBER (p_param_in IN VARCHAR2) RETURN BOOLEAN;
111
112 FUNCTION WP_IS_NUMBER (p_param_in IN VARCHAR2) RETURN BOOLEAN;
113
114 FUNCTION GET_OPTY_SMRY_INF_TIP RETURN VARCHAR2;
115
116 PROCEDURE hide_parameter(p_param in bis_pmv_page_parameter_tbl,
117 hideParameter OUT NOCOPY VARCHAR2);
118
119 END BIL_TX_UTIL_RPT_PKG;