[Home] [Help]
PACKAGE: APPS.PV_PARTNER_TREND_PVT
Source
1 PACKAGE PV_PARTNER_TREND_PVT AS
2 /* $Header: pvptrnds.pls 120.1 2005/09/01 10:46:40 appldev ship $ */
3
4 g_RETCODE VARCHAR2(10) := '0';
5 g_common_currency VARCHAR2(15);
6 g_period_set_name VARCHAR2(15);
7 g_log_to_file VARCHAR2(5) := 'Y';
8 g_module_name VARCHAR2(60);
9
10 PROCEDURE Debug(
11 p_msg_string IN VARCHAR2,
12 p_msg_type IN VARCHAR2 := 'PV_DEBUG_MESSAGE'
13 );
14
15 PROCEDURE refresh_partner_trend ( ERRBUF OUT NOCOPY VARCHAR2,
16 RETCODE OUT NOCOPY VARCHAR2,
17 p_from_date IN VARCHAR2,
18 p_to_date IN VARCHAR2,
19 p_new_partners_flag IN VARCHAR2 := 'N',
20 p_ignore_refresh_interval IN VARCHAR2 DEFAULT 'N',
21 p_partner_id IN NUMBER DEFAULT NULL,
22 p_log_to_file IN VARCHAR2 := 'Y');
23
24 FUNCTION kpi_oppty_cnt_offset(p_salesforce_id number) return number;
25
26 FUNCTION kpi_oppty_amt_offset(p_salesforce_id number, p_currency_code varchar2) return number;
27
28 END;