1 PACKAGE OE_FREIGHT_RATING_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEXVFRRS.pls 120.0.12010000.1 2008/07/25 07:59:53 appldev ship $ */
3
4 TYPE T_DATE is TABLE OF DATE;
5 TYPE T_NUM is TABLE OF NUMBER;
6 TYPE T_V1 is TABLE OF VARCHAR(01);
7 TYPE T_V3 is TABLE OF VARCHAR(03);
8 TYPE T_V10 is TABLE OF VARCHAR(10);
9 TYPE T_V15 is TABLE OF VARCHAR(15);
10 TYPE T_V25 is TABLE OF VARCHAR(25);
11 TYPE T_V30 is TABLE OF VARCHAR(30);
12 TYPE T_V40 is TABLE OF VARCHAR(40);
13 TYPE T_V50 is TABLE OF VARCHAR(50);
14 TYPE T_V80 is TABLE OF VARCHAR(80);
15 TYPE T_V240 is TABLE OF VARCHAR(240);
16 TYPE T_V1000 is TABLE OF VARCHAR(1000);
17 TYPE T_V2000 is TABLE OF VARCHAR(2000);
18 TYPE NUMBER_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
19
20 TYPE Bulk_Line_Adj_Rec_Type IS RECORD
21 ( price_adjustment_id T_NUM
22 , header_id T_NUM
23 , line_id T_NUM
24 , adjusted_amount T_NUM
25 , operand T_NUM
26 , list_line_type_code T_V30
27 , charge_type_code T_V30
28 , estimated_flag T_V1
29 , source_system_code T_V30
30 , creation_date T_DATE
31 , created_by T_NUM
32 , last_updated_by T_NUM
33 , last_update_date T_DATE
34 , last_update_login T_NUM
35 );
36
37 Type List_Line_Type_Code_Rec_Type is Record
38 (
39 list_line_type_code Varchar2(30)
40 );
41
42 TYPE List_Line_Type_Code_Tbl_Type IS TABLE OF List_Line_Type_Code_Rec_Type
43 INDEX BY BINARY_INTEGER;
44
45 g_list_line_type_code_rec List_Line_Type_Code_Rec_Type;
46 g_list_line_type_code_tbl List_Line_Type_Code_Tbl_Type;
47
48 FUNCTION Get_List_Line_Type_Code
49 ( p_key IN NUMBER)
50 RETURN VARCHAR2;
51
52 PROCEDURE Process_FTE_Output
53 ( p_header_id IN NUMBER
54 ,p_x_fte_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab
55 ,p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
56 ,p_fte_rates_tab IN FTE_PROCESS_REQUESTS.Fte_Source_Line_Rates_Tab
57 ,p_config_count IN NUMBER
58 ,p_ui_flag IN VARCHAR2
59 ,p_call_pricing_for_FR IN VARCHAR2
60 ,x_return_status OUT NOCOPY VARCHAR2
61
62 );
63
64 END OE_FREIGHT_RATING_PVT;
|
|
|