[Home] [Help]
PACKAGE: APPS.WMS_TASK_DISPATCH_LOV
Source
1 PACKAGE WMS_Task_Dispatch_LOV AS
2 /* $Header: WMSTSKLS.pls 120.2 2005/12/14 06:24:41 nsrivast noship $ */
3
4 TYPE t_genref IS REF CURSOR;
5
6 -- Name: GET_TASKS_LOV
7 --
8 -- Input parameters:
9 -- p_Organization_Id which restricts LOV SQL to current org
10 -- p_user_Id restrict LOV to a given user
11 -- p_lpn_id This will be passed only for patchset I
12 --
13 -- Output parameters:
14 -- x_tasks returns LOV rows as reference cursor
15 --
16 -- Functions: This procedure returns LOV rows for a given org, item and
17 -- user input text
18 --
19 -- HISTORY
20 --
21
22
23 PROCEDURE get_item_lov
24 (x_Items OUT NOCOPY t_genref,
25 p_Organization_Id IN NUMBER,
26 p_Concatenated_Segments IN VARCHAR2,
27 p_where_clause IN VARCHAR2,
28 p_lpn_id IN NUMBER DEFAULT NULL
29 );
30
31
32 PROCEDURE get_tasks_lov
33 (x_tasks OUT NOCOPY t_genref,
34 p_Organization_Id IN NUMBER,
35 p_User_Id IN NUMBER,
36 p_concat_segments IN VARCHAR2,
37 p_page_type IN VARCHAR2 DEFAULT NULL
38 );
39
40
41 PROCEDURE GET_REASONS_LOV(x_reasons OUT NOCOPY t_genref,
42 p_reason_type IN NUMBER,
43 p_concat_segments IN VARCHAR2);
44
45 -- Procedure overloaded for Transaction Reason Security build.
46 -- 4505091, nsrivast
47 PROCEDURE GET_REASONS_LOV(x_reasons OUT NOCOPY t_genref,
48 p_reason_type IN NUMBER,
49 p_concat_segments IN VARCHAR2,
50 p_txn_type_id IN NUMBER );
51
52 -- Overloaded procedure for the reason LOV in the discrepancy page for APL
53 PROCEDURE GET_REASONS_LOV(x_reasons OUT NOCOPY t_genref,
54 p_reason_type IN NUMBER,
55 p_reason_contexts IN VARCHAR2,
56 p_concat_segments IN VARCHAR2);
57
58 -- Procedure overloaded for Transaction Reason Security build.
59 -- 4505091, nsrivast
60 PROCEDURE GET_REASONS_LOV(x_reasons OUT NOCOPY t_genref,
61 p_reason_type IN NUMBER,
62 p_reason_contexts IN VARCHAR2,
63 p_concat_segments IN VARCHAR2,
64 p_txn_type_id IN VARCHAR2 );
65
66
67 PROCEDURE GET_LPN_ITEMS_LOV(x_items OUT NOCOPY t_genref,
68 p_lpn_id IN NUMBER,
69 p_concat_segments IN VARCHAR2);
70
71
72 PROCEDURE get_container_items_lov
73 (x_container_items OUT NOCOPY t_genref,
74 p_org_id IN NUMBER,
75 p_concat_segments IN VARCHAR2);
76
77 PROCEDURE validate_container_items
78 (p_organization_id IN NUMBER,
79 p_concat_segments IN VARCHAR2,
80 x_is_valid_container OUT NOCOPY VARCHAR2,
81 x_container_item_id OUT NOCOPY NUMBER);
82
83
84 -- Name: GET_EQP_LOV
85 --
86 -- Input parameters:
87 -- p_Organization_Id which restricts LOV SQL to current org
88 -- p_concat_segment user input
89 -- Output parameters:
90 -- x_eqps returns LOV rows as reference cursor
91 --
92 -- Functions: This procedure returns LOV rows for a given org and
93 -- user input text
94 --
95 --
96 --
97
98 PROCEDURE get_eqp_lov
99 (x_eqps OUT NOCOPY t_genref,
100 p_Organization_Id IN NUMBER,
101 p_concat_segments IN VARCHAR2);
102
103 -- Name: GET_DEVICE_LOV
104 --
105 -- Input parameters:
106 -- p_Organization_Id which restricts LOV SQL to current org
107 -- p_concat_segment user input
108 -- Output parameters:
109 -- x_devices returns LOV rows as reference cursor
110 --
111 -- Functions: This procedure returns LOV rows for a given org and
112 -- user input text
113 --
114 --
115 --
116
117 PROCEDURE get_device_lov
118 (x_devices OUT NOCOPY t_genref,
119 p_Organization_Id IN NUMBER,
120 p_concat_segments IN VARCHAR2);
121
122 -- Name: GET_CURRENT_DEVICE_LOV
123 --
124 -- Input parameters:
125 -- p_employee_id which restricts LOV SQL to current employee
126 -- p_concat_segment user input
127 -- Output parameters:
128 -- x_devices returns LOV rows as reference cursor
129 --
130 -- Functions: This procedure returns LOV rows for a given user and
131 -- user input text
132 --
133 --
134
135 PROCEDURE get_current_device_lov
136 (x_devices OUT NOCOPY t_genref,
137 p_Employee_Id IN NUMBER,
138 p_concat_segments IN VARCHAR2);
139
140
141 FUNCTION get_locator(p_wms_task_type IN NUMBER,
142 p_locator_id IN NUMBER,
143 p_transfer_to_location_id IN NUMBER,
144 p_transaction_type_id IN NUMBER,
145 p_organization_id IN NUMBER)
146 RETURN varchar2;
147 PRAGMA RESTRICT_REFERENCES(get_locator,WNDS);
148
149
150
151 END WMS_Task_Dispatch_LOV;