[Home] [Help]
PACKAGE: APPS.GMP_DESPATCH_LOAD_RPT_PKG
Source
1 PACKAGE GMP_DESPATCH_LOAD_RPT_PKG AUTHID CURRENT_USER AS
2 /* $Header: GMPRDESS.pls 120.3 2012/03/29 08:29:43 maychen ship $ */
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 FUNCTION get_resource_inst( p_resource_inst IN NUMBER, p_resource_id IN NUMBER) RETURN VARCHAR2 ;
56
57 END GMP_DESPATCH_LOAD_RPT_PKG;