[Home] [Help]
Skip to content
PACKAGE: APPS.IEX_STRATEGY_CNT_PUB
Source
1 PACKAGE IEX_STRATEGY_CNT_PUB AUTHID CURRENT_USER AS
2 /* $Header: iexpstcs.pls 120.9 2011/11/29 09:46:12 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 p_strategy_mode IN VARCHAR2 DEFAULT 'FINAL',
12 p_show_output IN VARCHAR2 DEFAULT 'N'); -- added by gnramasa for bug 8630852 13-July-09
13 -- End - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
14
15 PROCEDURE Close_strategies (
16 ERRBUF OUT NOCOPY VARCHAR2,
17 RETCODE OUT NOCOPY VARCHAR2,
18 p_strategy_mode IN VARCHAR2 DEFAULT 'FINAL',
19 p_show_output IN VARCHAR2 DEFAULT 'N'); -- added by gnramasa for bug 8630852 13-July-09
20
21
22 --Begin Bug#7248296 28/07/2008 barathsr
23 PROCEDURE process_onhold_strategies(p_strategy_mode IN VARCHAR2 DEFAULT 'FINAL', p_show_output IN VARCHAR2 DEFAULT 'N'); -- added by gnramasa for bug 8630852 13-July-09
24 --End Bug#7248296 28/07/2008 barathsr
25
26 PROCEDURE Close_All_stry (
27 ERRBUF OUT NOCOPY VARCHAR2,
28 RETCODE OUT NOCOPY VARCHAR2);
29
30 -- Begin - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
31 --PROCEDURE MAIN (
32 -- ERRBUF OUT NOCOPY VARCHAR2,
33 -- RETCODE OUT NOCOPY VARCHAR2,
34 -- p_trace_mode IN VARCHAR2);
35 PROCEDURE MAIN (
36 ERRBUF OUT NOCOPY VARCHAR2,
37 RETCODE OUT NOCOPY VARCHAR2,
38 --p_trace_mode IN VARCHAR2,Bug5022607. Fix By LKKUMAR. Removed this parameter.
39 p_org_id IN number,
40 p_ignore_switch IN VARCHAR2,
41 p_strategy_mode IN VARCHAR2 DEFAULT 'FINAL', -- added by gnramasa for bug 8630852 13-July-09
42 p_show_output IN VARCHAR2 DEFAULT 'N', -- added for bug 13377466 pnaveenk
43 p_coll_bus_level_dummy IN VARCHAR2 DEFAULT NULL, -- added by gnramasa for bug 8630852 13-July-09
44 p_customer_name_low IN VARCHAR2 DEFAULT NULL, -- added by gnramasa for bug 8630852 13-July-09
45 p_customer_name_high IN VARCHAR2 DEFAULT NULL, -- added by gnramasa for bug 8630852 13-July-09
46 p_account_number_low IN VARCHAR2 DEFAULT NULL, -- added by gnramasa for bug 8630852 13-July-09
47 p_account_number_high IN VARCHAR2 DEFAULT NULL, -- added by gnramasa for bug 8630852 13-July-09
48 p_billto_location_dummy IN VARCHAR2 DEFAULT NULL, -- added by gnramasa for bug 8630852 13-July-09
49 p_billto_location_low IN VARCHAR2 DEFAULT NULL, -- added by gnramasa for bug 8630852 13-July-09
50 p_billto_location_high IN VARCHAR2 DEFAULT NULL -- added by gnramasa for bug 8630852 13-July-09
51 );
52 -- End - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
53
54 PROCEDURE GetStrategyTempID(
55 p_stry_cnt_rec in IEX_STRATEGY_TYPE_PUB.STRY_CNT_REC_TYPE,
56 x_return_status out NOCOPY varchar2,
57 x_strategy_template_id out NOCOPY number);
58
59 PROCEDURE write_log(mesg_level IN NUMBER, mesg IN VARCHAR2);
60
61 l_MsgLevel NUMBER;
62 l_DefaultTempID NUMBER;
63 l_DefaultStrategyLevel NUMBER := 50;
64 -- Start for bug # 5487449 on 28/08/2006 by gnramasa
65 l_StrategyLevelName varchar2(255);
66 l_DefaultTempName varchar2(255);
67 l_EnabledFlag varchar2(15);
68 l_default_rs_id number;
69 l_UserName varchar2(100);
70 l_SourceName varchar2(360);
71 -- End for bug # 5487449 on 28/08/2006 by gnramasa
72
73 END IEX_STRATEGY_CNT_PUB;