PACKAGE: APPS.QP_ITEM_RANGE_PVT

Source

1 PACKAGE QP_ITEM_RANGE_PVT AUTHID CURRENT_USER AS
2 /* $Header: QPXITRGS.pls 120.1 2005/06/14 05:22:02 appldev  $ */
3 
4 l_tbl_type  DBMS_SQL.VARCHAR2_TABLE;
5 l_tbl  l_tbl_type%TYPE;
6 
7 PROCEDURE ITEMS_IN_RANGE
8 (
9  p_segment1_lohi        IN	VARCHAR2,
10  p_segment2_lohi        IN	VARCHAR2,
11  p_segment3_lohi        IN	VARCHAR2,
12  p_segment4_lohi        IN	VARCHAR2,
13  p_segment5_lohi        IN	VARCHAR2,
14  p_segment6_lohi        IN	VARCHAR2,
15  p_segment7_lohi        IN	VARCHAR2,
16  p_segment8_lohi        IN	VARCHAR2,
17  p_segment9_lohi        IN	VARCHAR2,
18  p_segment10_lohi       IN	VARCHAR2,
19  p_segment11_lohi       IN	VARCHAR2,
20  p_segment12_lohi       IN	VARCHAR2,
21  p_segment13_lohi       IN	VARCHAR2,
22  p_segment14_lohi       IN	VARCHAR2,
23  p_segment15_lohi       IN	VARCHAR2,
24  p_segment16_lohi       IN	VARCHAR2,
25  p_segment17_lohi       IN	VARCHAR2,
26  p_segment18_lohi       IN	VARCHAR2,
27  p_segment19_lohi       IN	VARCHAR2,
28  p_segment20_lohi       IN	VARCHAR2,
29  p_org_id	              IN	NUMBER,
30  p_category_set_id      IN    NUMBER,
31  p_category_id		    IN	NUMBER,
32  p_status_code 	    IN	VARCHAR2,
33  p_item_tbl             OUT NOCOPY /* file.sql.39 change */   l_tbl%TYPE
34 );
35 
36 END QP_ITEM_RANGE_PVT;