[Home] [Help]
PACKAGE: APPS.IEX_UWQ_POP_SUM_TBL_PVT
Source
1 PACKAGE IEX_UWQ_POP_SUM_TBL_PVT AUTHID CURRENT_USER as
2 /* $Header: iexvuwps.pls 120.6.12020000.2 2012/07/24 19:19:06 schekuri ship $ */
3
4
5 /*-------------------------------------------------------------------------*
6 | PUBLIC CONSTANTS
7 *-------------------------------------------------------------------------*/
8
9 /*-------------------------------------------------------------------------*
10 | PUBLIC DATATYPES
11 *-------------------------------------------------------------------------*/
12
13 /*-------------------------------------------------------------------------*
14 | PUBLIC VARIABLES
15 *-------------------------------------------------------------------------*/
16
17 /*-------------------------------------------------------------------------*
18 | PUBLIC ROUTINES
19 *-------------------------------------------------------------------------*/
20
21 PROCEDURE populate_uwq_sum_concur(
22 x_errbuf OUT nocopy VARCHAR2,
23 x_retcode OUT nocopy VARCHAR2,
24 FROM_DATE IN VARCHAR2,
25 --Begin Bug 8707932 27-Jul-2009 barathsr
26 p_ou_lvl_enb in varchar2 default null,
27 p_org_id in number,
28 p_truncate_table in varchar2 default 'N',
29 p_update_contact in varchar2 default 'Y' -- Added p_update_contact for bug13713264 bibeura 15-Feb-2012
30 );
31 --End Bug 8707932 27-Jul-2009 barathsr
32
33 PROCEDURE Insert_Summary(
34 x_errbuf OUT nocopy VARCHAR2,
35 x_retcode OUT nocopy VARCHAR2,
36 FROM_DATE IN VARCHAR2,
37 --Begin Bug 8707932 27-Jul-2009 barathsr
38 p_org_id in number,
39 p_level in varchar2,
40 --End Bug 8707932 27-Jul-2009 barathsr
41 P_MODE IN VARCHAR2 DEFAULT 'CP',
42 p_update_contact in varchar2 default 'Y'); -- Added p_update_contact for bug13713264 bibeura 15-Feb-2012
43 PROCEDURE refresh_summary_incr(
44 x_errbuf OUT nocopy VARCHAR2,
45 x_retcode OUT nocopy VARCHAR2,
46 FROM_DATE IN VARCHAR2,
47 P_MODE IN VARCHAR2 DEFAULT 'CP');
48
49
50 --Begin Bug 9596144 28-Apr-2010 barathsr
51 Procedure update_trx_bal_summ_concur( x_errbuf OUT nocopy VARCHAR2,
52 x_retcode OUT nocopy VARCHAR2);
53
54 --End Bug 9596144 28-Apr-2010 barathsr
55
56 procedure calculate_net_balance(p_fmode varchar2, p_from_date date,p_org_id number); --Added for Bug 8823567 22-Oct-2009 barathsr
57 locked_by_another_session EXCEPTION ;
58 PRAGMA EXCEPTION_INIT(locked_by_another_session,-54) ;
59 deadlock_detected EXCEPTION;
60 PRAGMA EXCEPTION_INIT(deadlock_detected, -60);
61 -- Start for the bug#7562130 by PNAVEENK
62 g_score_value number;
63 g_score_id number;
64 g_score_name varchar2(100);
65 g_object_type varchar2(100);
66 g_object_id number;
67 function cal_score(p_object_id number, p_object_type varchar2, p_select_column varchar2) return varchar2;
68 -- end for the bug#7562130
69 END;