[Home] [Help]
PACKAGE: APPS.AMS_LIST_RUNNING_TOTAL_PVT
Source
1 PACKAGE AMS_List_running_total_pvt AUTHID CURRENT_USER AS
2 /* $Header: amslruts.pls 120.1.12010000.2 2009/03/05 05:43:48 hbandi ship $*/
3 -- Start of Comments
4 --
5 -- NAME
6 -- AMS_List_running_total_pvt
7 --
8 -- PURPOSE
9 -- This package calculates the running totals
10 --
11 -- Procedures:
12 --
13 --
14 -- NOTES
15 --
16 --
17 -- HISTORY
18 -- 10/29/2003 usingh created
19 -- End of Comments
20 TYPE sql_string_4k IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
21 TYPE t_number is TABLE OF NUMBER INDEX BY BINARY_INTEGER;
22 /*
23 PROCEDURE sample_ds_for_templ (
24 p_template_id NUMBER
25 );
26 */
27 PROCEDURE gen_lov_filter_for_templmv (
28 x_filter_sql OUT NOCOPY VARCHAR2,
29 x_string_params OUT NOCOPY sql_string_4k,
30 x_num_params OUT NOCOPY NUMBER,
31 p_template_id IN NUMBER
32 );
33 /*
34 PROCEDURE get_total_count_for_templmv (
35 x_count OUT NOCOPY NUMBER,
36 p_sql IN VARCHAR2,
37 p_string_params IN sql_string_4k,
38 p_num_params IN NUMBER
39 );
40 */
41
42
43 PROCEDURE calculate_running_totals (
44 Errbuf OUT NOCOPY VARCHAR2,
45 Retcode OUT NOCOPY VARCHAR2,
46 p_template_id NUMBER
47 );
48
49 PROCEDURE generate_mv_for_template (
50 Errbuf OUT NOCOPY VARCHAR2,
51 Retcode OUT NOCOPY VARCHAR2,
52 p_template_id NUMBER
53 );
54
55 PROCEDURE calc_tot_for_all_templates (
56 Errbuf OUT NOCOPY VARCHAR2,
57 Retcode OUT NOCOPY VARCHAR2
58 );
59
60
61 PROCEDURE process_query (
62 p_sql_string IN sql_string_4k,
63 p_total_parameters IN t_number,
64 p_string_parameters IN sql_string_4k,
65 p_template_id IN NUMBER,
66 p_parameters IN sql_string_4k,
67 p_parameters_value IN t_number,
68 p_sql_results OUT NOCOPY t_number
69 );
70
71 --hbandi added this procedure for resolving the bug #8221231(DB VERSION)
72 PROCEDURE parse_db_version(
73 db_version_major OUT NOCOPY NUMBER,
74 db_version_minor OUT NOCOPY NUMBER
75 );
76
77 END AMS_List_running_total_pvt;