[Home] [Help]
PACKAGE: APPS.INV_UI_TASK_LOVS
Source
1 PACKAGE INV_UI_TASK_LOVS AS
2 /* $Header: INVUITAS.pls 120.2 2008/02/15 10:37:58 mporecha ship $ */
3
4 TYPE t_genref IS REF CURSOR;
5
6 -- Name: GET_SUB_LOV_RCV
7 --
8 -- Input parameters:
9 -- p_project_id which restricts LOV SQL to specified project
10 -- p_restrict_tasks
11 --
12 -- Output parameters:
13 -- x_tasks returns LOV rows as reference cursor
14 --
15 --
16
17 PROCEDURE GET_TASKS(
18 x_tasks OUT NOCOPY /* file.sql.39 change */ t_genref,
19 p_restrict_tasks IN VARCHAR,
20 p_project_id IN VARCHAR
21 );
22
23 PROCEDURE GET_MO_TASKS(
24 x_tasks OUT NOCOPY /* file.sql.39 change */ t_genref,
25 p_restrict_tasks IN VARCHAR2,
26 p_project_id IN NUMBER,
27 p_organization_id IN NUMBER,
28 p_mo_header_id IN NUMBER
29 );
30
31 PROCEDURE GET_CC_TASKS (
32 x_tasks OUT NOCOPY /* file.sql.39 change */ t_genref,
33 p_restrict_tasks IN VARCHAR2,
34 p_project_id IN NUMBER,
35 p_organization_id IN NUMBER,
36 p_cycle_count_id IN NUMBER,
37 p_unscheduled_flag IN NUMBER
38 );
39
40 PROCEDURE GET_PHY_TASKS (
41 x_tasks OUT NOCOPY /* file.sql.39 change */ t_genref,
42 p_restrict_tasks IN VARCHAR2,
43 p_project_id IN NUMBER,
44 p_organization_id IN NUMBER,
45 p_dynamic_entry_flag IN NUMBER,
46 p_physical_inventory_id IN NUMBER
47 );
48 PROCEDURE GET_RCV_TASKS(
49 X_TASKS OUT NOCOPY /* file.sql.39 change */ t_genref,
50 p_document_type IN VARCHAR2,
51 p_po_header_id IN NUMBER,
52 p_po_line_id IN NUMBER,
53 p_oe_header_id IN NUMBER,
54 p_req_header_id IN NUMBER,
55 p_shipment_id IN NUMBER,
56 p_project_id IN NUMBER,
57 p_task_number IN VARCHAR2,
58 p_item_id IN NUMBER DEFAULT NULL,
59 p_lpn_id IN NUMBER DEFAULT NULL, -- ASN
60 p_po_release_id IN NUMBER DEFAULT NULL,
61 p_is_deliver IN VARCHAR2 DEFAULT 'F' --bug 6785303
62 );
63
64 END INV_UI_TASK_LOVS;