PACKAGE: APPS.QRM_PA_CALCULATION_P

Source

1 PACKAGE QRM_PA_CALCULATION_P AUTHID CURRENT_USER AS
2 /* $Header: qrmpacas.pls 115.11 2003/11/22 00:36:13 prafiuly ship $ */
3 
4 e_no_setting_found EXCEPTION;
5 e_analysis_in_progress EXCEPTION;
6 e_invalid_date EXCEPTION;
7 
8 --bug 3236479
9 g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
10 g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
11 g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
12 g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
13 g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
14 
15 PROCEDURE run_analysis_cp (errbuf		OUT NOCOPY	VARCHAR2,
16 			   retcode		OUT NOCOPY	VARCHAR2,
17 			   p_source		IN	VARCHAR2,
18 			   p_analysis_name	IN	VARCHAR2,
19 			   p_date		IN	VARCHAR2);
20 
21 
22 PROCEDURE run_analysis_am (p_analysis_names IN	SYSTEM.QRM_VARCHAR_TABLE,
23 			   p_ref_datetime   IN	DATE DEFAULT SYSDATE);
24 
25 
26 PROCEDURE run_analysis (retcode		OUT NOCOPY	VARCHAR2,
27 			p_source	IN	VARCHAR2,
28 			p_analysis_name IN	VARCHAR2,
29 			p_ref_datetime	IN	DATE DEFAULT SYSDATE);
30 
31 
32 PROCEDURE remove_expired_deals(p_ref_date DATE DEFAULT SYSDATE);
33 
34 
35 
36 FUNCTION get_threshold_date (p_ref_datetime DATE,
37 		   p_threshold_num NUMBER,
38 		   p_threshold_type VARCHAR2)
39 	RETURN DATE;
40 
41 FUNCTION get_gap_date 	(p_deal_no		IN	NUMBER,
42 			 p_deal_type		IN	VARCHAR2,
43 			 p_initial_basis	IN	VARCHAR2,
44 			 p_ref_date		IN	DATE)
45 	RETURN DATE;
46 
47 FUNCTION get_signed_amount  (p_amount	NUMBER,
48 			     p_deal_type VARCHAR2,
49 			     p_deal_subtype VARCHAR2,
50 			     p_action VARCHAR2)
51 	RETURN NUMBER;
52 
53 PROCEDURE convert_amounts(p_mds		IN	VARCHAR2,
54 			  p_ref_date	IN	DATE,
55 			  p_from_ccy	IN	VARCHAR2,
56 			  p_to_ccy	IN	VARCHAR2,
57 			  p_from_amount	IN	NUMBER,
58 			  p_to_amount	OUT NOCOPY	NUMBER);
59 
60 
61 FUNCTION filter_measure(p_style VARCHAR2,
62 			p_analysis_name VARCHAR2,
63 			p_market_type_table_alias VARCHAR2)
64 	RETURN VARCHAR2;
65 
66 
67 
68 END QRM_PA_CALCULATION_P;