PACKAGE: APPS.PV_PARTNER_TREND_PVT

Source

1 PACKAGE PV_PARTNER_TREND_PVT AUTHID CURRENT_USER 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;