1 PACKAGE ASO_LINE_NUM_INT as
2 /* $Header: asoilnms.pls 120.1 2005/06/29 12:33:43 appldev ship $ */
3 -- Start of Comments
4 -- Package name : aso_line_num_int
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11
12 --Input Line Number pl/sql Record and table declaration
13 TYPE In_Line_Number_Rec_Type IS RECORD
14 (
15 Quote_Line_ID NUMBER := FND_API.G_MISS_NUM
16 );
17
18 G_MISS_In_Line_Number_Rec In_Line_Number_Rec_Type;
19
20 TYPE In_Line_Number_Tbl_Type IS TABLE OF In_Line_Number_Rec_Type INDEX BY BINARY_INTEGER;
21
22 G_MISS_In_Line_Number_Tbl In_Line_Number_Tbl_Type;
23
24
25 TYPE Out_Line_Number_Tbl_Type IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
26
27
28 TYPE Line_Rec_Type IS RECORD
29 (
30 Quote_Line_ID NUMBER := FND_API.G_MISS_NUM,
31 Item_Type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
32 Serviceable_Product_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
33 Service_Item_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
34 Service_Ref_Type_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
35 Config_Header_ID NUMBER := FND_API.G_MISS_NUM,
36 Config_Revision_Num NUMBER := FND_API.G_MISS_NUM
37 );
38
39 G_MISS_Line_Rec Line_Rec_Type;
40
41 TYPE Line_Tbl_Type IS TABLE OF Line_Rec_Type INDEX BY BINARY_INTEGER;
42
43 G_MISS_Line_Tbl Line_Tbl_Type;
44
45
46 PROCEDURE ASO_UI_LINE_NUMBER(
47 P_In_Line_Number_Tbl IN ASO_LINE_NUM_INT.In_Line_Number_Tbl_Type,
48 X_Out_Line_Number_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_LINE_NUM_INT.Out_Line_Number_Tbl_Type
49 );
50
51 PROCEDURE RESET_LINE_NUM;
52
53 FUNCTION ASO_QUOTE_LINE_NUMBER(
54 p_quote_line_id in number,
55 p_item_type_code in varchar2,
56 p_serviceable_product_flag in varchar2,
57 p_service_item_flag in varchar2,
58 p_service_ref_type_code in varchar2,
59 p_config_header_id in number,
60 p_config_revision_num in number
61 )
62 RETURN VARCHAR2;
63
64
65 FUNCTION GET_UI_LINE_NUMBER(
66 P_Quote_Line_Id IN NUMBER
67 )
68 RETURN VARCHAR2;
69
70 END ASO_LINE_NUM_INT;