DBA Data[Home] [Help]

PACKAGE: APPS.GMP_DESPATCH_LOAD_RPT_PKG

Source


1 PACKAGE GMP_DESPATCH_LOAD_RPT_PKG AS
2 /* $Header: GMPRDESS.pls 120.1 2005/07/29 04:42:56 sowsubra noship $ */
3 
4 PROCEDURE print_res_desp
5                         (	errbuf              OUT NOCOPY VARCHAR2,
6  				retcode             OUT NOCOPY VARCHAR2,
7                                 V_forg              IN NUMBER,
8                                 V_torg              IN NUMBER,
9                                 V_fres              IN VARCHAR2,
10                                 V_tores             IN VARCHAR2,
11                                 V_fres_instance     IN NUMBER,
12                                 V_tores_instance    IN NUMBER,
13                                 V_start_date        IN VARCHAR2,
14                                 V_to_date           IN VARCHAR2,
15                                 V_template          IN VARCHAR2,
16                                 V_template_locale   IN VARCHAR2
17  			      );
18 PROCEDURE gme_res_generate_xml;
19 
20 FUNCTION get_orgn_code( p_orgn_id  IN NUMBER) RETURN VARCHAR2 ;
21 
22 PROCEDURE resdl_generate_output ( p_sequence_num IN NUMBER);
23 
24 PROCEDURE rd_xml_transfer (     errbuf              OUT NOCOPY VARCHAR2,
25                                 retcode             OUT NOCOPY VARCHAR2,
26                                 p_sequence_num      IN  NUMBER
27                           );
28 
29 PROCEDURE print_res_load
30                         (	errbuf              OUT NOCOPY VARCHAR2,
31  				retcode             OUT NOCOPY VARCHAR2,
32                                 V_inst_id           IN NUMBER,
33                                 V_orgid             IN NUMBER,
34                                 V_plan_id           IN NUMBER,
35                                 V_forg              IN NUMBER,
36                                 V_torg              IN NUMBER,
37                                 V_fres              IN NUMBER,
38                                 V_tores             IN NUMBER,
39                                 V_fres_instance     IN NUMBER,
40                                 V_tores_instance    IN NUMBER,
41                                 V_start_date        IN VARCHAR2,
42                                 V_to_date           IN VARCHAR2,
43                                 V_template          IN VARCHAR2,
44                                 V_template_locale   IN VARCHAR2
45  			      );
46 
47 PROCEDURE aps_res_generate_xml;
48 
49 FUNCTION get_inst_code( p_inst_id IN NUMBER) RETURN VARCHAR2 ;
50 
51 FUNCTION get_plan_code( p_plan_id IN NUMBER) RETURN VARCHAR2 ;
52 
53 FUNCTION get_resource_desc( p_resource_id IN NUMBER) RETURN VARCHAR2 ;
54 
55 END GMP_DESPATCH_LOAD_RPT_PKG;