1 PACKAGE gme_gantt_lov_pkg AS
2 /* $Header: GMEGNTLS.pls 120.2 2005/06/10 13:57:03 appldev $ */
3 TYPE batchlovdetailrectype IS RECORD (
4 batch_id NUMBER (10)
5 ,batch_no VARCHAR2 (32)
6 ,organization_id NUMBER (10)
7 ,batch_status NUMBER (5)
8 ,concatenated_segments VARCHAR2 (2000)
9 ,description VARCHAR2 (2000)
10 );
11
12 TYPE batchlovdetailtabletype IS TABLE OF batchlovdetailrectype
13 INDEX BY BINARY_INTEGER;
14
15 /**
16 * Select the appropriate batches and send them one by one to the gantt
17 */
18 PROCEDURE select_batches_lov (
19 p_input_field IN VARCHAR2
20 ,p_current_start_row IN INTEGER
21 ,p_num_row_to_get IN INTEGER
22 ,p_pending_status IN VARCHAR2
23 ,p_released_status IN VARCHAR2
24 ,p_certified_status IN VARCHAR2
25 ,p_organization_id IN INTEGER
26 ,p_batch_type IN INTEGER
27 ,p_fpo_type IN INTEGER
28 ,p_from_date IN DATE
29 ,p_to_date IN DATE
30 ,x_total_rows OUT NOCOPY NUMBER
31 ,x_batch_lov_tbl OUT NOCOPY batchlovdetailtabletype);
32
33 TYPE itemlovdetailrectype IS RECORD (
34 inventory_item_id NUMBER (10)
35 ,concatenated_segments VARCHAR2 (2000)
36 ,description VARCHAR2 (2000)
37 );
38
39 TYPE itemlovdetailtabletype IS TABLE OF itemlovdetailrectype
40 INDEX BY BINARY_INTEGER;
41
42 PROCEDURE select_items_lov (
43 p_input_field IN VARCHAR2
44 ,p_current_start_row IN INTEGER
45 ,p_num_row_to_get IN INTEGER
46 ,p_line_type IN INTEGER
47 ,p_organization_id IN INTEGER
48 ,x_total_rows OUT NOCOPY NUMBER
49 ,x_item_lov_tbl OUT NOCOPY itemlovdetailtabletype);
50
51 TYPE resourcelovdetailrectype IS RECORD (
52 resources VARCHAR2 (32)
53 ,resource_desc VARCHAR2 (70)
54 );
55
56 TYPE resourcelovdetailtabletype IS TABLE OF resourcelovdetailrectype
57 INDEX BY BINARY_INTEGER;
58
59 /**
60 * Select the appropriate resources and send them one by one to the gantt
61 */
62 PROCEDURE select_resources_lov (
63 p_input_field IN VARCHAR2
64 ,p_current_start_row IN INTEGER
65 ,p_num_row_to_get IN INTEGER
66 ,p_organization_id IN INTEGER
67 ,x_total_rows OUT NOCOPY NUMBER
68 ,x_rsrc_lov_tbl OUT NOCOPY resourcelovdetailtabletype);
69
70 TYPE orgnlovdetailrectype IS RECORD (
71 organization_code VARCHAR2 (3)
72 ,organization_name VARCHAR2 (240)
73 );
74
75 TYPE orgnlovdetailtabletype IS TABLE OF orgnlovdetailrectype
76 INDEX BY BINARY_INTEGER;
77
78 /**
79 * Select the vaild organizations for the current operator
80 */
81 PROCEDURE select_organizations_lov (
82 p_input_field IN VARCHAR2
83 ,p_current_start_row IN INTEGER
84 ,p_num_row_to_get IN INTEGER
85 ,p_user_id IN NUMBER
86 ,x_total_rows OUT NOCOPY NUMBER
87 ,x_orgn_lov_tbl OUT NOCOPY orgnlovdetailtabletype);
88 END;