DBA Data[Home] [Help]

APPS.OE_PORTAL_LINE dependencies on OE_ORDER_PUB

Line 12: g_line_rec OE_Order_PUB.Line_Rec_Type;

8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Oe_Portal_Line';
9:
10: -- Global variables holding cached record.
11:
12: g_line_rec OE_Order_PUB.Line_Rec_Type;
13: g_db_line_rec OE_Order_PUB.Line_Rec_Type;
14: --g_set_of_books_rec Set_Of_Books_Rec_Type;
15: -- Forward declaration of procedures maintaining entity record cache.
16:

Line 13: g_db_line_rec OE_Order_PUB.Line_Rec_Type;

9:
10: -- Global variables holding cached record.
11:
12: g_line_rec OE_Order_PUB.Line_Rec_Type;
13: g_db_line_rec OE_Order_PUB.Line_Rec_Type;
14: --g_set_of_books_rec Set_Of_Books_Rec_Type;
15: -- Forward declaration of procedures maintaining entity record cache.
16:
17:

Line 21: , x_line_rec OUT NOCOPY OE_Order_PUB.Line_Rec_Type

17:
18:
19: PROCEDURE Get_line
20: ( p_line_id IN NUMBER
21: , x_line_rec OUT NOCOPY OE_Order_PUB.Line_Rec_Type
22: );
23:
24:
25: PROCEDURE Get_Item_Values(Item_Id IN NUMBER ,

Line 32: g_opr__tbl OE_Order_PUB.Header_Tbl_Type;

28: PROCEDURE Clear_Line;
29:
30: -- Global variable holding performed operations.
31:
32: g_opr__tbl OE_Order_PUB.Header_Tbl_Type;
33:
34:
35: PROCEDURE Validate_Write_Line
36: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 99: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

95: , x_ship_to_address3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
96: , x_ship_to_address4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97: )
98: IS
99: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
100: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
101: l_control_rec OE_GLOBALS.Control_Rec_Type;
102: l_return_status VARCHAR2(1);
103: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

Line 100: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

96: , x_ship_to_address4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97: )
98: IS
99: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
100: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
101: l_control_rec OE_GLOBALS.Control_Rec_Type;
102: l_return_status VARCHAR2(1);
103: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
104: l_charge_amount NUMBER := 0.0;

Line 103: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

99: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
100: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
101: l_control_rec OE_GLOBALS.Control_Rec_Type;
102: l_return_status VARCHAR2(1);
103: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
104: l_charge_amount NUMBER := 0.0;
105: BEGIN
106:
107: /* chhung delete the content of all procedures. Request by Esha */

Line 135: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

131: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
132: , p_line_id IN NUMBER
133: )
134: IS
135: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
136: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
137: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
138: l_control_rec OE_GLOBALS.Control_Rec_Type;
139: l_return_status VARCHAR2(1);

Line 136: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

132: , p_line_id IN NUMBER
133: )
134: IS
135: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
136: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
137: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
138: l_control_rec OE_GLOBALS.Control_Rec_Type;
139: l_return_status VARCHAR2(1);
140: BEGIN

Line 137: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

133: )
134: IS
135: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
136: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
137: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
138: l_control_rec OE_GLOBALS.Control_Rec_Type;
139: l_return_status VARCHAR2(1);
140: BEGIN
141:

Line 151: , x_line_rec OUT NOCOPY OE_Order_PUB.Line_Rec_Type

147:
148: PROCEDURE Get_line
149: (
150: p_line_id IN NUMBER
151: , x_line_rec OUT NOCOPY OE_Order_PUB.Line_Rec_Type
152: )
153: IS
154: BEGIN
155: