PACKAGE: APPS.GMP_PLNG_DTL_REPORT_PKG

Source

1 PACKAGE GMP_PLNG_DTL_REPORT_PKG AS
2 /* $Header: GMPPLDRS.pls 120.2.12010000.2 2008/11/01 21:32:32 rpatangy ship $ */
3 
4 PROCEDURE create_pdr
5 (
6    errbuf                       OUT NOCOPY VARCHAR2,
7    retcode                      OUT NOCOPY VARCHAR2,
8    p_inst_id                    IN NUMBER,
9    p_org_id                     IN NUMBER,
10    p_plan_id                    IN NUMBER,
11    p_plan_org                   IN NUMBER,
12    p_start_date                 IN VARCHAR2,
13    p_day_bucket                 IN NUMBER,
14    p_day_bckt_cutoff_dt         IN VARCHAR2,
15    p_plan_day_bckt_cutoff_dt    IN VARCHAR2,
16    p_week_bucket                IN NUMBER,
17    p_week_bckt_cutoff_dt        IN VARCHAR2,
18    p_plan_week_bckt_cutoff_dt   IN VARCHAR2,
19    p_period_bucket              IN NUMBER,
20    p_fsort                      IN NUMBER,
21    p_ssort                      IN NUMBER,
22    p_tsort                      IN NUMBER,
23    p_ex_typ                     IN NUMBER,
24    p_plnr_low                   IN VARCHAR2,
25    p_plnr_high                  IN VARCHAR2,
26    p_byr_low                    IN VARCHAR2,
27    p_byr_high                   IN VARCHAR2,
28    p_itm_low                    IN VARCHAR2,
29    p_itm_high                   IN VARCHAR2,
30    p_cat_set_id                 IN NUMBER,
31    p_category_low               IN VARCHAR2,
32    p_category_high              IN VARCHAR2,
33    p_abc_class_low              IN VARCHAR2,
34    p_abc_class_high             IN VARCHAR2,
35    p_cutoff_date                IN VARCHAR2,
36    p_comb_pdr                   IN NUMBER,
37    p_comb_pdr_place             IN VARCHAR2,  -- Added
38    p_comb_comm_pdr              IN VARCHAR2,  -- Added
39    p_comb_pdr_temp              IN VARCHAR2,
40    p_comb_pdr_locale            IN VARCHAR2,
41    p_horiz_pdr                  IN NUMBER,
42    p_horiz_pdr_place            IN VARCHAR2,  -- Added
43    p_horiz_pdr_temp             IN VARCHAR2,
44    p_horiz_pdr_locale           IN VARCHAR2,
45    p_vert_pdr                   IN NUMBER,
46    p_vert_pdr_place             IN VARCHAR2,  -- Added
47    p_vert_pdr_temp              IN VARCHAR2,
48    p_vert_pdr_locale            IN VARCHAR2,
49    p_excep_pdr                  IN NUMBER,
50    p_excep_pdr_place            IN VARCHAR2,  -- Added
51    p_excep_pdr_temp             IN VARCHAR2,
52    p_excep_pdr_locale           IN VARCHAR2,
53    p_act_pdr                    IN NUMBER,
54    p_act_pdr_place              IN VARCHAR2,  -- Added
55    p_act_pdr_temp               IN VARCHAR2,
56    p_act_pdr_locale             IN VARCHAR2
57 );
58 
59 PROCEDURE insert_items ;
60 
61 PROCEDURE validate_parameters;
62 
63 PROCEDURE horiz_plan_stmt;
64 
65 PROCEDURE vert_plan_stmt;
66 
67 PROCEDURE item_exception_stmt;
68 
69 PROCEDURE item_action_stmt;
70 
71 PROCEDURE generate_xml;
72 
73 FUNCTION plan_name RETURN VARCHAR2;
74 
75 FUNCTION plan_org ( org_id IN NUMBER) RETURN VARCHAR2;
76 
77 FUNCTION category_set_name ( cat_set_id IN NUMBER) RETURN VARCHAR2;
78 
79 FUNCTION lookup_meaning(l_lookup_type IN VARCHAR2, l_lookup_code IN NUMBER) RETURN VARCHAR2;
80 
81 PROCEDURE ps_generate_output (p_sequence_num IN NUMBER,p_pdr_type IN NUMBER);
82 
83 PROCEDURE xml_transfer (errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY VARCHAR2, p_sequence_num IN NUMBER);
84 
85 END GMP_PLNG_DTL_REPORT_PKG;