PACKAGE: APPS.IEX_STRATEGY_CNT_PUB

Source

1 PACKAGE IEX_STRATEGY_CNT_PUB AS
2 /* $Header: iexpstcs.pls 120.4.12010000.4 2008/08/27 05:59:51 pnaveenk ship $ */
3 -- Begin - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
4 --PROCEDURE open_strategies (
5 --	ERRBUF      OUT NOCOPY     VARCHAR2,
6 --	RETCODE     OUT NOCOPY     VARCHAR2);
7 PROCEDURE open_strategies (
8 	ERRBUF      	OUT NOCOPY     VARCHAR2,
9 	RETCODE     	OUT NOCOPY     VARCHAR2,
10 	p_ignore_switch	IN 	       VARCHAR2);
11 -- End - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
12 
13 PROCEDURE Close_strategies (
14 		ERRBUF      OUT NOCOPY     VARCHAR2,
15 		RETCODE     OUT NOCOPY     VARCHAR2);
16 
17 
18 --Begin Bug#7248296 28/07/2008 barathsr
19 PROCEDURE process_onhold_strategies;
20 --End Bug#7248296 28/07/2008 barathsr
21 
22 PROCEDURE Close_All_stry (
23 		ERRBUF      OUT NOCOPY     VARCHAR2,
24 		RETCODE     OUT NOCOPY     VARCHAR2);
25 
26 -- Begin - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
27 --PROCEDURE MAIN (
28 --		ERRBUF      OUT NOCOPY     VARCHAR2,
29 --		RETCODE     OUT NOCOPY     VARCHAR2,
30 --                p_trace_mode          IN  VARCHAR2);
31 PROCEDURE MAIN (
32 		ERRBUF          OUT NOCOPY     VARCHAR2,
33 		RETCODE     	OUT NOCOPY     VARCHAR2,
34                 --p_trace_mode    IN  	       VARCHAR2,Bug5022607. Fix By LKKUMAR. Removed this parameter.
35                 p_org_id IN number,
36 		p_ignore_switch	IN             VARCHAR2
37 		 );
38 -- End - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
39 
40 PROCEDURE GetStrategyTempID(
41 		p_stry_cnt_rec in	IEX_STRATEGY_TYPE_PUB.STRY_CNT_REC_TYPE,
42 		x_return_status out NOCOPY varchar2,
43 		x_strategy_template_id out NOCOPY number);
44 
45 PROCEDURE write_log(mesg_level IN NUMBER, mesg IN VARCHAR2);
46 
47 l_MsgLevel  NUMBER;
48 l_DefaultTempID NUMBER;
49 l_DefaultStrategyLevel NUMBER := 50;
50 -- Start for bug # 5487449 on 28/08/2006 by gnramasa
51 l_StrategyLevelName varchar2(255);
52 l_DefaultTempName varchar2(255);
53 l_EnabledFlag varchar2(15);
54 l_default_rs_id number;
55 l_UserName  varchar2(100);
56 l_SourceName  varchar2(360);
57 -- End for bug # 5487449 on 28/08/2006 by gnramasa
58 
59 END IEX_STRATEGY_CNT_PUB;