1 PACKAGE OE_Default_Line AS
2 /* $Header: OEXDLINS.pls 120.0.12010000.2 2008/11/14 11:13:43 smanian ship $ */
3
4 PROCEDURE Attributes
5 ( p_x_Line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
6 , p_old_Line_rec IN OE_Order_PUB.Line_Rec_Type
7 , p_iteration IN NUMBER := 1
8 ) ;
9
10 FUNCTION Get_Line
11 RETURN NUMBER;
12
13 FUNCTION Get_Shipment_Number
14 RETURN NUMBER;
15
16 FUNCTION Get_Line_Number
17 RETURN NUMBER;
18
19 FUNCTION Get_Defaulting_Invoice_Line(p_return_context IN VARCHAR2,
20 p_return_attribute1 IN VARCHAR2,
21 p_return_attribute2 IN VARCHAR2)
22 RETURN NUMBER;
23 FUNCTION Get_Dual_Uom -- INVCONV
24 (
25 p_line_rec OE_ORDER_PUB.Line_Rec_Type
26 )
27 RETURN VARCHAR2;
28
29
30
31 FUNCTION Get_Defaulting_Order_Line(p_return_context IN VARCHAR2,
32 p_return_attribute1 IN VARCHAR2,
33 p_return_attribute2 IN VARCHAR2)
34 RETURN NUMBER;
35
36 -- to default return attributes from referenced invoice line
37 Procedure Attributes_From_Invoice_Line
38 ( p_invoice_line_id IN NUMBER
39 , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
40 );
41
42 -- to default return attributes from referenced order line
43 Procedure Attributes_From_Order_Line
44 ( p_order_line_id IN NUMBER
45 , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
46 );
47
48 -- to default return attributes
49 Procedure Return_Attributes
50 ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
51 , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
52 );
53
54 FUNCTION Get_Item_Type(p_line_rec OE_ORDER_PUB.Line_Rec_Type,
55 p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)
56 RETURN VARCHAR2;
57
58 PROCEDURE Insert_into_set
59 (p_line_id IN NUMBER,
60 p_child_line_id IN NUMBER,
61 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
62
63 -- 2806483
64 -- Added to spec to call the API from other packages.
65 FUNCTION GET_FREIGHT_CARRIER(p_line_rec OE_ORDER_PUB.Line_Rec_Type,
66 p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)
67 RETURN VARCHAR2;
68
69 /* Added for Pack J to support Config and Service items for Blanket Functionality
70 -- Added this package to populate the Service and Config
71 -- Related Blanket Number, Blanket Line Number and Version Number
72 -- By Srini
73 */
74
75 PROCEDURE Get_Blanket_Number_SVC_CONFIG
76 ( p_blanket_number IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
77 p_inventory_item_id IN NUMBER,
78 x_blanket_line_number OUT NOCOPY number,
79 x_blanket_version_number OUT NOCOPY number);
80
81 /* Made BSA defaulting procedure public.
82 --By Srini
83 */
84 PROCEDURE Default_Blanket_Values
85 ( p_blanket_number IN NUMBER,
86 p_cust_po_number IN VARCHAR2,
87 p_ordered_item_id IN NUMBER DEFAULT NULL, --bug6826787
88 p_ordered_item IN VARCHAR2 ,
89 p_inventory_item_id IN NUMBER,
90 p_item_identifier_type IN VARCHAR2,
91 p_request_date IN DATE,
92 p_sold_to_org_id IN NUMBER,
93 x_blanket_number OUT NOCOPY NUMBER,
94 x_blanket_line_number OUT NOCOPY NUMBER,
95 x_blanket_version_number OUT NOCOPY NUMBER,
96 x_blanket_request_date OUT NOCOPY DATE
97 );
98
99
100 /*PROCEDURE Get_Blanket_Number_SVC_CONFIG
101 ( p_blanket_number IN OUT NUMBER,
102 p_inventory_item_id IN NUMBER,
103 x_blanket_line_number OUT NOCOPY number,
104 x_blanket_version_number OUT NOCOPY number); */ -- INVCONV FOR PROBLEM
105
106
107
108 END OE_Default_Line;
[Home] [Help]