DBA Data[Home] [Help]

APPS.OE_PORTAL_UTIL dependencies on OE_ORDER_PUB

Line 10: ( p_header_rec IN OE_Order_PUB.HEADER_Rec_Type

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Portal_Util';
7:
8:
9: PROCEDURE get_values
10: ( p_header_rec IN OE_Order_PUB.HEADER_Rec_Type
11: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
12: OE_Order_PUB.G_MISS_HEADER_REC
13: , x_header_val_rec_type OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
14: )

Line 11: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=

7:
8:
9: PROCEDURE get_values
10: ( p_header_rec IN OE_Order_PUB.HEADER_Rec_Type
11: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
12: OE_Order_PUB.G_MISS_HEADER_REC
13: , x_header_val_rec_type OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
14: )
15: IS

Line 12: OE_Order_PUB.G_MISS_HEADER_REC

8:
9: PROCEDURE get_values
10: ( p_header_rec IN OE_Order_PUB.HEADER_Rec_Type
11: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
12: OE_Order_PUB.G_MISS_HEADER_REC
13: , x_header_val_rec_type OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
14: )
15: IS
16: BEGIN

Line 13: , x_header_val_rec_type OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type

9: PROCEDURE get_values
10: ( p_header_rec IN OE_Order_PUB.HEADER_Rec_Type
11: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
12: OE_Order_PUB.G_MISS_HEADER_REC
13: , x_header_val_rec_type OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
14: )
15: IS
16: BEGIN
17: x_header_val_rec_type := OE_HEADER_UTIL.get_values

Line 43: , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

39: PROCEDURE lines
40: ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
41: , p_validation_level IN NUMBER
42: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
43: , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
44: , p_return_status OUT NOCOPY VARCHAR2
45: )
46: IS
47: l_return_status VARCHAR2(1);

Line 48: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

44: , p_return_status OUT NOCOPY VARCHAR2
45: )
46: IS
47: l_return_status VARCHAR2(1);
48: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
49:
50: BEGIN
51: oe_debug_pub.add('entering oe_portal_util.lines', 1);
52: if p_x_line_tbl(1).operation = OE_GLOBALS.G_OPR_CREATE THEN

Line 53: l_old_line_tbl :=OE_Order_PUB.G_MISS_LINE_TBL;

49:
50: BEGIN
51: oe_debug_pub.add('entering oe_portal_util.lines', 1);
52: if p_x_line_tbl(1).operation = OE_GLOBALS.G_OPR_CREATE THEN
53: l_old_line_tbl :=OE_Order_PUB.G_MISS_LINE_TBL;
54: elsif p_x_line_tbl(1).operation = OE_GLOBALS.G_OPR_UPDATE THEN
55: oe_oe_form_line.Get_line
56: ( p_db_record => TRUE
57: , p_line_id => p_x_line_tbl(1).line_id

Line 95: ( p_header_rec IN OE_Order_PUB.HEADER_Rec_Type

91:
92: END lines;
93:
94: PROCEDURE set_header_cache
95: ( p_header_rec IN OE_Order_PUB.HEADER_Rec_Type
96: )
97: IS
98: l_return_status VARCHAR2(1);
99: l_ak_header_rec OE_AK_ORDER_HEADERS_V%rowtype;

Line 147: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.HEADER_Rec_Type

143:
144: PROCEDURE get_header
145: (
146: p_header_id IN NUMBER,
147: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.HEADER_Rec_Type
148: )
149: IS
150: BEGIN
151:

Line 162: x_line_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Rec_Type

158:
159: PROCEDURE get_line
160: (
161: p_line_id IN NUMBER,
162: x_line_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Rec_Type
163: )
164: IS
165: BEGIN
166: OE_Line_Util.Query_Row