PACKAGE: APPS.GMP_PLNG_DTL_REPORT_PKG

Source

1 PACKAGE GMP_PLNG_DTL_REPORT_PKG AUTHID CURRENT_USER AS
2 /* $Header: GMPPLDRS.pls 120.7 2011/05/06 12:55:18 vkinduri 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,  Bug: 8363786 Vpedarla
15    p_plan_day_bckt_cutoff_dt    IN VARCHAR2,
16    p_week_bucket                IN NUMBER,
17  --  p_week_bckt_cutoff_dt        IN VARCHAR2,   Bug: 8363786 Vpedarla
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_incl_items_no_activity     IN VARCHAR2, --  Bug: 8486531 Vpedarla
37    p_comb_pdr                   IN NUMBER,
38    p_comb_pdr_place             IN VARCHAR2,  -- Added
39    p_comb_comm_pdr              IN VARCHAR2,  -- Added
40    p_comb_pdr_temp              IN VARCHAR2,
41    p_comb_pdr_locale            IN VARCHAR2,
42    p_horiz_pdr                  IN NUMBER,
43    p_horiz_pdr_place            IN VARCHAR2,  -- Added
44    p_horiz_pdr_temp             IN VARCHAR2,
45    p_horiz_pdr_locale           IN VARCHAR2,
46    p_vert_pdr                   IN NUMBER,
47    p_vert_pdr_place             IN VARCHAR2,  -- Added
48    p_vert_pdr_temp              IN VARCHAR2,
49    p_vert_pdr_locale            IN VARCHAR2,
50    p_excep_pdr                  IN NUMBER,
51    p_excep_pdr_place            IN VARCHAR2,  -- Added
52    p_excep_pdr_temp             IN VARCHAR2,
53    p_excep_pdr_locale           IN VARCHAR2,
54    p_act_pdr                    IN NUMBER,
55    p_act_pdr_place              IN VARCHAR2,  -- Added
56    p_act_pdr_temp               IN VARCHAR2,
57    p_act_pdr_locale             IN VARCHAR2
58 );
59 
60 PROCEDURE insert_items ;
61 
62 PROCEDURE validate_parameters;
63 
64 PROCEDURE horiz_plan_stmt;
65 
66 PROCEDURE vert_plan_stmt;
67 
68 PROCEDURE item_exception_stmt;
69 
70 PROCEDURE item_action_stmt;
71 
72 PROCEDURE generate_xml;
73 
74 FUNCTION plan_name RETURN VARCHAR2;
75 
76 FUNCTION plan_org ( org_id IN NUMBER) RETURN VARCHAR2;
77 
78 FUNCTION category_set_name ( cat_set_id IN NUMBER) RETURN VARCHAR2;
79 
80 FUNCTION lookup_meaning(l_lookup_type IN VARCHAR2, l_lookup_code IN NUMBER) RETURN VARCHAR2;
81 
82 PROCEDURE ps_generate_output (p_sequence_num IN NUMBER,p_pdr_type IN NUMBER);
83 
84 PROCEDURE xml_transfer (errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY VARCHAR2, p_sequence_num IN NUMBER);
85 
86 PROCEDURE gmp_debug_message(pBUFF IN VARCHAR2);  -- Bug: 9366921 Vpedarla
87 
88 END GMP_PLNG_DTL_REPORT_PKG;