PACKAGE: APPS.AMS_LIST_RUNNING_TOTAL_PVT

Source

1 PACKAGE AMS_List_running_total_pvt AS
2 /* $Header: amslruts.pls 120.1 2005/06/27 05:38:42 appldev 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 
72 END AMS_List_running_total_pvt;