[Home] [Help]
PACKAGE: APPS.FLM_KANBAN_PLANNING_UTIL
Source
1 PACKAGE FLM_KANBAN_PLANNING_UTIL AUTHID CURRENT_USER AS
2 /* $Header: flmkputs.pls 120.1 2011/03/24 08:39:17 sisankar noship $ */
3
4 p_attr1_prompt Varchar2(80) ;
5 p_attr2_prompt Varchar2(80) ;
6 p_attr3_prompt Varchar2(80) ;
7 p_attr4_prompt Varchar2(80) ;
8 p_attr5_prompt Varchar2(80) ;
9 p_attr6_prompt Varchar2(80) ;
10 p_attr7_prompt Varchar2(80) ;
11 p_attr8_prompt Varchar2(80) ;
12 p_attr9_prompt Varchar2(80) ;
13 p_attr10_prompt Varchar2(80) ;
14 p_attr11_prompt Varchar2(80) ;
15 p_attr12_prompt Varchar2(80) ;
16 p_attr13_prompt Varchar2(80) ;
17 p_attr14_prompt Varchar2(80) ;
18 p_attr15_prompt Varchar2(80) ;
19
20 PENDING CONSTANT NUMBER := 1;
21 RUNNING CONSTANT NUMBER := 2;
22 ERROR CONSTANT NUMBER := 3;
23 COMPLETED CONSTANT NUMBER := 4;
24 WARNING CONSTANT NUMBER := 5;
25
26 type t_flm_kanban_demand_intf is table of FLM_EKB_DEMAND_INTERFACE%rowtype index by binary_integer;
27
28 Function GET_CALCULATED_CARDS(P_PULL_SEQUENCE_ID IN NUMBER,
29 P_CALCULATE_KANBAN_FLAG IN NUMBER,
30 P_KANBAN_SIZE IN NUMBER,
31 P_AVG_DEMAND IN NUMBER,
32 P_ALLOCATION_PERCENT IN NUMBER,
33 P_REPLENISHMENT_LEAD_TIME IN NUMBER,
34 P_SAFETY_STOCK_DAYS IN NUMBER,
35 P_MINIMUM_ORDER_QUANTITY IN NUMBER,
36 P_FIXED_LOT_MULTIPLIER IN NUMBER)
37 RETURN NUMBER;
38
39 Function GET_CALCULATED_SIZE(P_PULL_SEQUENCE_ID IN NUMBER,
40 P_CALCULATE_KANBAN_FLAG IN NUMBER,
41 P_NUMBER_OF_CARDS IN NUMBER,
42 P_AVG_DEMAND IN NUMBER,
43 P_ALLOCATION_PERCENT IN NUMBER,
44 P_REPLENISHMENT_LEAD_TIME IN NUMBER,
45 P_SAFETY_STOCK_DAYS IN NUMBER,
46 P_MINIMUM_ORDER_QUANTITY IN NUMBER,
47 P_FIXED_LOT_MULTIPLIER IN NUMBER)
48 RETURN NUMBER;
49
50 procedure replan(p_request_id IN Number);
51
52 procedure process(p_flm_kanban_demand_int_tbl in t_flm_kanban_demand_intf,
53 x_ret_status out nocopy number);
54
55 procedure process_interface_records(retcode out nocopy number,
56 errbuf out nocopy varchar2,
57 p_organization_id in number);
58
59 procedure regen_sys_plan_pullseq(p_pull_sequence_id IN Number,
60 p_org_id IN Number,
61 p_item_id IN NUMBER,
62 p_subinv IN VARCHAR2,
63 p_locator IN NUMBER,
64 p_kanban_plan IN NUMBER,
65 p_set_prmopts IN VARCHAR2);
66
67 Function get_next_pull_seq_id RETURN NUMBER;
68
69 Function get_temp_cards_count(p_pull_sequence_id IN Number)
70 RETURN NUMBER;
71
72 procedure set_flexfields_prompt;
73
74 Function set_dff return Number;
75
76 procedure generate_plan_data(p_pull_seq_ids IN VARCHAR2);
77
78 procedure generate_plan_data(p_pull_sequence_id IN Number,
79 p_org_id IN Number,
80 p_kanban_plan_id IN Number,
81 p_item_id IN Number,
82 p_subinv IN Number,
83 p_locator IN Number,
84 p_safety_stock IN Number,
85 p_kanban_size IN Number,
86 p_kanban_cards IN Number,
87 p_avg_demand IN Number);
88
89 FUNCTION GET_ATTR_1_PROMPT RETURN VARCHAR2;
90 FUNCTION GET_ATTR_2_PROMPT RETURN VARCHAR2;
91 FUNCTION GET_ATTR_3_PROMPT RETURN VARCHAR2;
92 FUNCTION GET_ATTR_4_PROMPT RETURN VARCHAR2;
93 FUNCTION GET_ATTR_5_PROMPT RETURN VARCHAR2;
94 FUNCTION GET_ATTR_6_PROMPT RETURN VARCHAR2;
95 FUNCTION GET_ATTR_7_PROMPT RETURN VARCHAR2;
96 FUNCTION GET_ATTR_8_PROMPT RETURN VARCHAR2;
97 FUNCTION GET_ATTR_9_PROMPT RETURN VARCHAR2;
98 FUNCTION GET_ATTR_10_PROMPT RETURN VARCHAR2;
99 FUNCTION GET_ATTR_11_PROMPT RETURN VARCHAR2;
100 FUNCTION GET_ATTR_12_PROMPT RETURN VARCHAR2;
101 FUNCTION GET_ATTR_13_PROMPT RETURN VARCHAR2;
102 FUNCTION GET_ATTR_14_PROMPT RETURN VARCHAR2;
103 FUNCTION GET_ATTR_15_PROMPT RETURN VARCHAR2;
104
105 procedure generate_plan_data(p_pull_seq_ids IN VARCHAR2,
106 p_kanban_plan_id IN Number,
107 p_request_id out nocopy Number);
108
109 Function get_actual_lead_time(p_org_id IN Number,
110 p_pull_sequence_id IN Number)
111 RETURN NUMBER;
112
113 Function get_actual_demand(p_org_id IN Number,
114 p_pull_sequence_id IN Number)
115 RETURN NUMBER;
116
117 Function get_average_demand(p_org_id IN Number,
118 p_kanban_plan_id IN Number,
119 p_item_id IN Number,
120 p_subinv IN varchar2,
121 p_locator IN Number)
122 RETURN NUMBER;
123
124 procedure update_production(p_plan_pull_seq_id IN Number,
125 x_ret_status OUT NOCOPY Number);
126
127 procedure update_production(p_plan_pull_seq_ids IN VARCHAR2,
128 p_effective_date IN DATE,
129 x_ret_status OUT NOCOPY Number);
130
131 PROCEDURE launch_request(p_user_id IN NUMBER,
132 p_responsibility_id IN NUMBER,
133 p_resp_appl_id IN NUMBER,
134 p_organization_id IN NUMBER,
135 p_kanban_plan_id IN NUMBER,
136 p_from_item IN VARCHAR2,
137 p_to_item IN VARCHAR2,
138 p_category_set IN VARCHAR2,
139 p_from_category IN VARCHAR2,
140 p_to_category IN VARCHAR2,
141 p_bom_effectivity IN DATE,
142 p_start_date IN DATE,
143 p_cutoff_date IN DATE);
144
145 END FLM_KANBAN_PLANNING_UTIL;