PACKAGE: APPS.FLM_KANBAN_CONFIG_PARAMS

Source

1 package flm_kanban_config_params AUTHID CURRENT_USER as
2 /* $Header: flmekprs.pls 120.3 2011/07/25 21:54:59 ankohli noship $ */
3 
4 TYPE flm_unmovecard_rec IS RECORD (
5 status FLM_EKB_PREFERENCE_VALUES.attribute_name%TYPE, /*varchar2(10),*/
6 leadtime FLM_EKB_PREFERENCE_VALUES.attribute_value_code%TYPE /*varchar2(10)*/
7 );
8 
9 TYPE flm_unmovecard_table IS TABLE OF flm_unmovecard_rec;
10 
11 TYPE flm_unmovecard_enb_status_r IS RECORD (
12 status FLM_EKB_PREFERENCE_VALUES.attribute_name%TYPE /*varchar2(10),*/
13 );
14 
15 TYPE flm_unmovecard_enb_status_t IS TABLE OF flm_unmovecard_enb_status_r;
16 
17 function get_preference_level_id(p_pref_id number, p_org_id number) return number;
18 function get_kanban_tol_fs_prod(p_org_id number) return number;
19 function get_kanban_tol_fs_inter(p_org_id number) return number;
20 function get_kanban_tol_fs_intra(p_org_id number) return number;
21 function get_kanban_tol_fs_supplier(p_org_id number) return number;
22 function get_tol_kanban_transfer(p_org_id number) return varchar;
23 function get_dj_status_replenish(p_org_id number) return varchar;
24 function get_source_staging_subinv(p_org_id number) return varchar;
25 
26 function get_demand_range_days(p_org_id number) return number;
27 function get_demand_tolerance(p_org_id number) return number;
28 function get_lt_range_days(p_org_id number) return number;
29 function get_lt_tolerance(p_org_id number) return number;
30 
31 function get_good_inv_health_per(p_org_id number) return number;
32 function get_bad_inv_health_per(p_org_id number) return number;
33 
34 function get_dist_deployment return number;
35 
36 function get_unmovedcard_leadtime(p_org_id number) return flm_unmovecard_table;
37 function get_unmovedcard_enb_status(p_org_id number) return flm_unmovecard_enb_status_t;
38 
39 --
40 -- This function returns attribute_code from wip_preference_values
41 -- for single value preferences based on resp_key, org_id, dept_id.
42 -- For multiple value preferences, it returns "ENTERED" or "INHERIT" based on setup.
43 --
44 function get_preference_value_code
45 (p_preference_id number,
46  p_org_id number default null) return varchar2;
47 
48 --
49 -- This function returns attribute_value based on attribute_code.
50 --
51 function get_preference_value
52 (p_preference_id number,
53  p_org_id number default null) return varchar2;
54 
55 --
56 -- The function calculates the result preference value
57 --
58 function get_result_value_code
59 (p_preference_id number,
60  p_org_id number default null) return varchar2;
61 
62 --
63 -- The function calculates the result preference value
64 --
65 function get_result_value
66 (p_preference_id number,
67  p_org_id number default null) return varchar2;
68 
69 function get_level_id(p_org_id number) return number;
70 
71 procedure insertRow(p_preference_id number,
72 					p_level_id number,
73 					p_sequence_number number,
74 					p_attribute_name varchar2,
75 					p_attribute_value_code varchar2,
76 					p_enable_flag number,
77 					p_user_id number);
78 
79 function insertRowLevels
80 (p_org_id number, p_module_id number, p_user_id number) return number;
81 
82 procedure insertRowsPrefValues(p_preference_id number, p_org_id number, p_user_id number);
83 
84 procedure delete_disabled_card_status(p_org_id number);
85 procedure delete_preference_values(p_preference_id number, p_org_id number);
86 
87 function get_preference_value_label(p_preference_id number, p_label_code varchar2) return varchar2;
88 function get_lookup_meaning(p_lookup_type varchar2, p_lookup_code varchar2) return varchar2;
89 function get_lookup_type(p_preference_id number) return varchar2;
90 function is_function_accessible(p_function_name varchar2) return varchar2;
91 function get_new_enabled_status(p_org_id number) return varchar2;
92 function get_new_disabled_status(p_org_id number) return varchar2;
93 
94 end flm_kanban_config_params;