[Home] [Help]
PACKAGE: APPS.INV_UI_PROJECT_LOVS
Source
1 PACKAGE INV_UI_PROJECT_LOVS AUTHID CURRENT_USER AS
2 /* $Header: INVUIPRS.pls 120.2.12010000.1 2008/07/24 01:50:33 appldev ship $ */
3
4 TYPE t_genref IS REF CURSOR;
5 --
6 -- Name: GET_PROJECTS
7 --
8 -- Input parameters:
9 -- p_restrict_projects
10 --
11 -- Output parameters:
12 -- x_projects returns LOV rows as reference cursor
13 --
14 -- Functions: This API is to return all valid projects
15 --
16
17 PROCEDURE GET_PROJECTS(
18 x_projects OUT NOCOPY /* file.sql.39 change */ t_genref,
19 p_restrict_projects IN VARCHAR
20 );
21
22 PROCEDURE GET_RCV_PROJECTS(
23 X_PROJECTS OUT NOCOPY /* file.sql.39 change */ t_genref,
24 document_type IN VARCHAR2,
25 p_po_header_id IN NUMBER,
26 p_po_line_id IN NUMBER,
27 p_order_header_id IN NUMBER,
28 p_req_header_id IN NUMBER,
29 p_shipment_header_id IN NUMBER,
30 p_project_number IN VARCHAR2,
31 p_item_id IN NUMBER DEFAULT NULL,
32 p_lpn_id IN NUMBER DEFAULT NULL,
33 p_po_release_id IN NUMBER DEFAULT NULL,--BUG 4201013
34 p_is_deliver IN VARCHAR2 DEFAULT 'F' --bug6785303
35 );
36
37 PROCEDURE GET_CC_PROJECTS (
38 x_projects OUT NOCOPY /* file.sql.39 change */ t_genref,
39 p_organization_id IN NUMBER,
40 p_cycle_count_id IN NUMBER,
41 p_unscheduled_flag IN NUMBER,
42 p_project_number IN VARCHAR2
43 );
44
45 PROCEDURE GET_PHY_PROJECTS (
46 x_projects OUT NOCOPY /* file.sql.39 change */ t_genref,
47 p_organization_id IN NUMBER,
48 p_dynamic_entry_flag IN NUMBER,
49 p_physical_inventory_id IN NUMBER,
50 p_project_number IN varchar2
51 ) ;
52 PROCEDURE GET_MO_PROJECTS(
53 x_projects OUT NOCOPY /* file.sql.39 change */ t_genref,
54 p_restrict_projects IN VARCHAR2,
55 p_organization_id IN NUMBER,
56 p_mo_header_id IN NUMBER
57 );
58 END INV_UI_PROJECT_LOVS;