[Home] [Help]
PACKAGE: APPS.OKI_UTL_PUB
Source
1 PACKAGE oki_utl_pub AUTHID CURRENT_USER AS
2 /* $Header: OKIPUTLS.pls 115.7 2002/12/19 20:14:23 brrao noship $ */
3
4 --------------------------------------------------------------------------------
5 -- Start of comments
6 --
7 -- API Name : OKI_UTL_PUB
8 -- Type : Public
9 -- Purpose : This package contains procedure and functions that are common
10 -- to other packages
11 -- Modification History
12 -- 16-July-2001 mezra Created
13 -- 26-Dec-2001 mezra Added variables used across packages.
14 -- 04-Jan-2002 mezra Remove all functions and procedures for the bin.
15 -- 03-Apr-2002 mezra Added set verify off and whenever sqlerror
16 -- 26-NOV-2002 rpotnuru NOCOPY Changes
17 -- 19-Dec-2002 brrao UTF-8 Changes to Org Name
18 --
19 -- Notes :
20 --
21 -- End of comments
22 --------------------------------------------------------------------------------
23
24 --------------------------------------------------------------------------------
25 -- Global constant declaration
26 --------------------------------------------------------------------------------
27 g_all_organization_id CONSTANT NUMBER := -1 ;
28 g_all_organization_name CONSTANT VARCHAR2(240) := 'All Organizations' ;
29 g_all_customer_id CONSTANT NUMBER := -1 ;
30 g_all_customer_name CONSTANT VARCHAR2(60) := 'All Customers' ;
31 g_all_salesrep_id CONSTANT NUMBER := -1 ;
32 g_all_salesrep_name CONSTANT VARCHAR2(60) := 'All Sales Representatives' ;
33 g_all_k_category_code CONSTANT VARCHAR2(30) := '-1' ;
34 g_all_k_category_meaning CONSTANT VARCHAR2(30) := 'All Contract Categories' ;
35 g_all_prod_category_code CONSTANT VARCHAR2(30) := '-1' ;
36 g_all_time_id CONSTANT VARCHAR2(30) := -1 ;
37 g_all_time_name CONSTANT VARCHAR2(30) := 'All Years' ;
38 g_contract_limit CONSTANT NUMBER :=
39 fnd_profile.value('OKI_PROBLEM_K_THRESHOLD') ;
40
41 g_oki_app_name CONSTANT VARCHAR2(3) := 'OKI' ;
42 g_oki_tab_owner_name CONSTANT VARCHAR2(3) := 'OKI' ;
43
44 g_msg_name_table_load_fail CONSTANT VARCHAR(30) := 'OKI_TABLE_LOAD_FAILURE' ;
45 g_msg_name_loc_in_prog_fail CONSTANT VARCHAR(30) := 'OKI_LOC_IN_PROG_FAILURE' ;
46 g_msg_name_no_seq_fail CONSTANT VARCHAR(30) := 'OKI_NO_SEQUENCE_FAILURE' ;
47 g_msg_name_unexpected_fail CONSTANT VARCHAR(30) := 'OKI_UNEXPECTED_FAILURE' ;
48 g_msg_name_no_hrc_id_fail CONSTANT VARCHAR(30) := 'OKI_NO_HRC_ID_FAILURE' ;
49
50 g_msg_name_table_load_succ CONSTANT VARCHAR(30) := 'OKI_TABLE_LOAD_SUCCESS' ;
51
52 g_msg_tkn_table_load_succ CONSTANT VARCHAR(30) := 'TABLE_NAME' ;
53
54 -- Holds the current year start / end date information from GL periods
55 g_summary_build_date DATE := NULL ;
56 g_glpr_start_date DATE := NULL ;
57 g_glpr_end_date DATE := NULL ;
58 g_glpr_qtr_start_date DATE := NULL ;
59 g_glpr_qtr_end_date DATE := NULL ;
60 g_glpr_qtr_num NUMBER := NULL ;
61 g_glpr_year_start_date DATE := NULL ;
62 g_glpr_year_end_date DATE := NULL ;
63 g_period_year NUMBER := NULL ;
64 g_week_start_date DATE := NULL ;
65
66 -- Holds the prior year start / end date information from GL periods
67 g_py_summary_build_date DATE := NULL ;
68 g_py_glpr_start_date DATE := NULL ;
69 g_py_glpr_end_date DATE := NULL ;
70 g_py_glpr_qtr_start_date DATE := NULL ;
71 g_py_glpr_qtr_end_date DATE := NULL ;
72 g_py_glpr_qtr_num NUMBER := NULL ;
73 g_py_glpr_year_start_date DATE := NULL ;
74 g_py_glpr_year_end_date DATE := NULL ;
75 g_py_period_year NUMBER := NULL ;
76 g_py_week_start_date DATE := NULL ;
77
78 g_not_available CONSTANT VARCHAR2(4) := 'n.a.' ;
79
80 -- Amount to be displayed in the bins (In Millions)
81 g_display_divisor CONSTANT NUMBER := 1000000 ;
82 --------------------------------------------------------------------------------
83 -- Global exception declaration
84 --------------------------------------------------------------------------------
85 -- Exception to immediately exit the procedure
86 g_excp_exit_immediate EXCEPTION ;
87 -- Exception when there are problems retrieving a sequence number
88 g_excp_no_seq EXCEPTION ;
89
90 --------------------------------------------------------------------------------
91 -- Place holder function
92
93 --------------------------------------------------------------------------------
94 FUNCTION place_holder
95 RETURN VARCHAR2 ;
96
97 END oki_utl_pub ;