1 PACKAGE flm_seq_ui AS
2 /* $Header: FLMSQUIS.pls 120.3 2006/08/23 22:19:54 paho noship $ */
3
4 TYPE NUMBER_TABLE_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5
6 G_DEMAND_QTY NUMBER_TABLE_TYPE;
7
8 /******************************************************************
9 * To delete a task and its details in FLM_SEQ_* tables *
10 ******************************************************************/
11 PROCEDURE delete_tasks(p_seq_task_id IN NUMBER,
12 p_init_msg_list IN VARCHAR2,
13 x_return_status OUT NOCOPY VARCHAR2,
14 x_msg_count OUT NOCOPY NUMBER,
15 x_msg_data OUT NOCOPY VARCHAR2
16 );
17
18 /*****************************************************************************************
19 * To delete a task and its details in FLM_SEQ_* tables. After that it commits *
20 *****************************************************************************************/
21 PROCEDURE delete_tasks_commit(p_seq_task_id IN NUMBER,
22 p_init_msg_list IN VARCHAR2,
23 x_return_status OUT NOCOPY VARCHAR2,
24 x_msg_count OUT NOCOPY NUMBER,
25 x_msg_data OUT NOCOPY VARCHAR2);
26
27 /******************************************************************
28 * To calculate available capacity of a given line for a given *
29 * period of time (p_start_date, p_end_date) inclusively *
30 * the line is represented by (start, stop, hourly_rate) *
31 ******************************************************************/
32 PROCEDURE line_available_capacity(p_organization_id IN NUMBER,
33 p_start_time IN NUMBER,
34 p_stop_time IN NUMBER,
35 p_hourly_rate IN NUMBER,
36 p_start_date IN DATE,
37 p_end_date IN DATE,
38 p_init_msg_list IN VARCHAR2,
39 x_capacity OUT NOCOPY NUMBER,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2
43 );
44
45 /**********************************************************************************
46 * To insert demand from MRP_UNSCHEDULED_ORDERS_V to FLM_SEQ_TASK_DEMANDS table. *
47 * It also populates G_DEMAND_QTY PL/SQL table for the quantity per line *
48 **********************************************************************************/
49 PROCEDURE insert_demands(p_seq_task_id IN NUMBER,
50 p_max_rows IN NUMBER,
51 p_init_msg_list IN VARCHAR2,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2
55 );
56
57 /*****************************************************
58 * To get demand qty from G_DEMAND_QTY PL/SQL table. *
59 *****************************************************/
60 PROCEDURE get_demand_qty(p_line_id IN NUMBER,
61 p_init_msg_list IN VARCHAR2,
62 x_demand_qty OUT NOCOPY NUMBER,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2
66 );
67
68
69 /*******************************************************
70 * To delete demands from FLM_SEQ_TASK_DEMANDS table. *
71 *******************************************************/
72 PROCEDURE delete_demands(p_seq_task_id IN NUMBER,
73 p_init_msg_list IN VARCHAR2,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2
77 );
78
79 /*******************************************************
80 * To delete criteria from FLM_FILTER_CRITERIA table. *
81 *******************************************************/
82 PROCEDURE delete_criteria(p_seq_task_id IN NUMBER,
83 p_init_msg_list IN VARCHAR2,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2
87 );
88
89 /***************************************************************************************
90 * To insert lines from WIP_LINES into FLM_SEQ_TASK_LINES and all constraints on the *
91 * line default rule from FLM_SEQ_TASK_CONSTRAINTS into FLM_SEQ_TASK_CONSTRAINTS. *
92 ***************************************************************************************/
93 PROCEDURE insert_line_constraints(p_seq_task_id IN NUMBER,
94 p_line_id IN NUMBER,
95 p_org_id IN NUMBER,
96 p_init_msg_list IN VARCHAR2,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2
100 );
101 /*****************************************************************************************************
102 * To delete lines from FLM_SEQ_TASK_LINES and line contraints from FLM_SEQ_TASK_CONSTRAINTS table. *
103 *****************************************************************************************************/
104 PROCEDURE delete_line_constraints(p_seq_task_id IN NUMBER,
105 p_init_msg_list IN VARCHAR2,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2
109 );
110
111 /******************************************************************
112 * To get min wip_entity_id from WIP_FLOW_SCHEDULES PL/SQL table. *
113 ******************************************************************/
114 PROCEDURE get_min_wip_entity_id(p_start_date IN DATE,
115 p_org_id IN NUMBER,
116 p_init_msg_list IN VARCHAR2,
117 x_wip_entity_id OUT NOCOPY NUMBER,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2
121 );
122
123 /********************************
124 * To clean up the raw UI data *
125 ********************************/
126 PROCEDURE data_cleanup( p_init_msg_list IN VARCHAR2,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2
130 );
131
132 /*****
133 * Get the flag that indicates whether Flow Sequencing
134 * is enabled, which is defined by the 'FLM_ENABLE_FLMSEQ'
135 * profile.
136 *****/
137 FUNCTION Get_FlmSeq_Enabled_Flag RETURN VARCHAR2;
138
139 /*****
140 * Determines whether Flow Sequencing is licensed. Flow Sequencing
141 * is 'licensed' if:
142 * (1) Flow Manufacturing installed; and
143 * (2) Flow Sequencing is enabled.
144 *****/
145 FUNCTION Get_FlmSeq_Licensed RETURN VARCHAR2;
146
147
148 END flm_seq_ui;