[Home] [Help]
PACKAGE: APPS.WMS_TASK_DISPATCH_LOV
Source
1 PACKAGE WMS_Task_Dispatch_LOV AUTHID CURRENT_USER AS
2 /* $Header: WMSTSKLS.pls 120.2.12020000.2 2012/07/04 06:38:47 abasheer ship $ */
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 p_unload_receiving IN VARCHAR2 DEFAULT NULL
39
40 );
41
42
43 PROCEDURE GET_REASONS_LOV(x_reasons OUT NOCOPY t_genref,
44 p_reason_type IN NUMBER,
45 p_concat_segments IN VARCHAR2);
46
47 -- Procedure overloaded for Transaction Reason Security build.
48 -- 4505091, nsrivast
49 PROCEDURE GET_REASONS_LOV(x_reasons OUT NOCOPY t_genref,
50 p_reason_type IN NUMBER,
51 p_concat_segments IN VARCHAR2,
52 p_txn_type_id IN NUMBER );
53
54 -- Overloaded procedure for the reason LOV in the discrepancy page for APL
55 PROCEDURE GET_REASONS_LOV(x_reasons OUT NOCOPY t_genref,
56 p_reason_type IN NUMBER,
57 p_reason_contexts IN VARCHAR2,
58 p_concat_segments IN VARCHAR2);
59
60 -- Procedure overloaded for Transaction Reason Security build.
61 -- 4505091, nsrivast
62 PROCEDURE GET_REASONS_LOV(x_reasons OUT NOCOPY t_genref,
63 p_reason_type IN NUMBER,
64 p_reason_contexts IN VARCHAR2,
65 p_concat_segments IN VARCHAR2,
66 p_txn_type_id IN VARCHAR2 );
67
68
69 PROCEDURE GET_LPN_ITEMS_LOV(x_items OUT NOCOPY t_genref,
70 p_lpn_id IN NUMBER,
71 p_concat_segments IN VARCHAR2);
72
73
74 PROCEDURE get_container_items_lov
75 (x_container_items OUT NOCOPY t_genref,
76 p_org_id IN NUMBER,
77 p_concat_segments IN VARCHAR2);
78
79 PROCEDURE validate_container_items
80 (p_organization_id IN NUMBER,
81 p_concat_segments IN VARCHAR2,
82 x_is_valid_container OUT NOCOPY VARCHAR2,
83 x_container_item_id OUT NOCOPY NUMBER);
84
85
86 -- Name: GET_EQP_LOV
87 --
88 -- Input parameters:
89 -- p_Organization_Id which restricts LOV SQL to current org
90 -- p_concat_segment user input
91 -- Output parameters:
92 -- x_eqps returns LOV rows as reference cursor
93 --
94 -- Functions: This procedure returns LOV rows for a given org and
95 -- user input text
96 --
97 --
98 --
99
100 PROCEDURE get_eqp_lov
101 (x_eqps OUT NOCOPY t_genref,
102 p_Organization_Id IN NUMBER,
103 p_concat_segments IN VARCHAR2);
104
105 -- Name: GET_DEVICE_LOV
106 --
107 -- Input parameters:
108 -- p_Organization_Id which restricts LOV SQL to current org
109 -- p_concat_segment user input
110 -- Output parameters:
111 -- x_devices returns LOV rows as reference cursor
112 --
113 -- Functions: This procedure returns LOV rows for a given org and
114 -- user input text
115 --
116 --
117 --
118
119 PROCEDURE get_device_lov
120 (x_devices OUT NOCOPY t_genref,
121 p_Organization_Id IN NUMBER,
122 p_concat_segments IN VARCHAR2);
123
124 -- Name: GET_CURRENT_DEVICE_LOV
125 --
126 -- Input parameters:
127 -- p_employee_id which restricts LOV SQL to current employee
128 -- p_concat_segment user input
129 -- Output parameters:
130 -- x_devices returns LOV rows as reference cursor
131 --
132 -- Functions: This procedure returns LOV rows for a given user and
133 -- user input text
134 --
135 --
136
137 PROCEDURE get_current_device_lov
138 (x_devices OUT NOCOPY t_genref,
139 p_Employee_Id IN NUMBER,
140 p_concat_segments IN VARCHAR2);
141
142
143 FUNCTION get_locator(p_wms_task_type IN NUMBER,
144 p_locator_id IN NUMBER,
145 p_transfer_to_location_id IN NUMBER,
146 p_transaction_type_id IN NUMBER,
147 p_organization_id IN NUMBER)
148 RETURN varchar2;
149 PRAGMA RESTRICT_REFERENCES(get_locator,WNDS);
150
151
152
153 END WMS_Task_Dispatch_LOV;