DBA Data[Home] [Help]

APPS.OE_OE_HTML_HEADER dependencies on OE_ORDER_PUB

Line 10: g_header_rec OE_Order_PUB.Header_Rec_Type;

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Oe_Oe_Html_Header';
7:
8: -- Global variables holding cached record.
9:
10: g_header_rec OE_Order_PUB.Header_Rec_Type;
11: g_db_header_rec OE_Order_PUB.Header_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:

Line 11: g_db_header_rec OE_Order_PUB.Header_Rec_Type;

7:
8: -- Global variables holding cached record.
9:
10: g_header_rec OE_Order_PUB.Header_Rec_Type;
11: g_db_header_rec OE_Order_PUB.Header_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: -- Procedure : Default_Attributes

Line 22: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type

18: PROCEDURE Default_Attributes
19: ( x_return_status OUT NOCOPY VARCHAR2
20: , x_msg_count OUT NOCOPY NUMBER
21: , x_msg_data OUT NOCOPY VARCHAR2
22: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
23: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
24: , p_transaction_phase_code IN VARCHAR2
25: )
26: IS

Line 23: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type

19: ( x_return_status OUT NOCOPY VARCHAR2
20: , x_msg_count OUT NOCOPY NUMBER
21: , x_msg_data OUT NOCOPY VARCHAR2
22: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
23: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
24: , p_transaction_phase_code IN VARCHAR2
25: )
26: IS
27: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 29: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;

25: )
26: IS
27: l_control_rec OE_GLOBALS.Control_Rec_Type;
28: l_return_status VARCHAR2(1);
29: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
30: l_fname Varchar2(1000);
31: BEGIN
32: oe_debug_pub.g_debug_level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');
33: l_fname := oe_Debug_pub.set_debug_mode('FILE');

Line 61: l_old_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;

57: l_control_rec.clear_api_requests := TRUE;
58:
59: -- Load IN parameters if any exist
60:
61: l_old_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;
62: x_header_val_rec :=OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;
63:
64: IF p_transaction_phase_code = 'N' THEN
65: x_header_rec.transaction_phase_code := p_transaction_phase_code;

Line 62: x_header_val_rec :=OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;

58:
59: -- Load IN parameters if any exist
60:
61: l_old_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;
62: x_header_val_rec :=OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;
63:
64: IF p_transaction_phase_code = 'N' THEN
65: x_header_rec.transaction_phase_code := p_transaction_phase_code;
66: END IF;

Line 239: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type

235: , p_attr_id IN NUMBER
236: , p_attr_value IN VARCHAR2
237: , p_attr_id_tbl IN Number_Tbl_Type
238: , p_attr_value_tbl IN Varchar2_Tbl_Type
239: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
240: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
241: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
242:
243: )

Line 240: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type

236: , p_attr_value IN VARCHAR2
237: , p_attr_id_tbl IN Number_Tbl_Type
238: , p_attr_value_tbl IN Varchar2_Tbl_Type
239: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
240: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
241: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
242:
243: )
244: IS

Line 241: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type

237: , p_attr_id_tbl IN Number_Tbl_Type
238: , p_attr_value_tbl IN Varchar2_Tbl_Type
239: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
240: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
241: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
242:
243: )
244: IS
245: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 391: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type

387: , x_msg_count OUT NOCOPY NUMBER
388: , x_msg_data OUT NOCOPY VARCHAR2
389: , p_header_id IN NUMBER
390: , p_process IN BOOLEAN DEFAULT FALSE
391: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
392: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
393: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
394:
395: )

Line 392: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type

388: , x_msg_data OUT NOCOPY VARCHAR2
389: , p_header_id IN NUMBER
390: , p_process IN BOOLEAN DEFAULT FALSE
391: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
392: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
393: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
394:
395: )
396: IS

Line 393: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type

389: , p_header_id IN NUMBER
390: , p_process IN BOOLEAN DEFAULT FALSE
391: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
392: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
393: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
394:
395: )
396: IS
397: l_x_old_header_rec OE_Order_PUB.Header_Rec_Type;

Line 397: l_x_old_header_rec OE_Order_PUB.Header_Rec_Type;

393: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
394:
395: )
396: IS
397: l_x_old_header_rec OE_Order_PUB.Header_Rec_Type;
398: l_control_rec OE_GLOBALS.Control_Rec_Type;
399: l_return_status VARCHAR2(1);
400: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
401: L_CASCADE_FLAG BOOLEAN;

Line 400: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

396: IS
397: l_x_old_header_rec OE_Order_PUB.Header_Rec_Type;
398: l_control_rec OE_GLOBALS.Control_Rec_Type;
399: l_return_status VARCHAR2(1);
400: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
401: L_CASCADE_FLAG BOOLEAN;
402: l_dir VARCHAR2(2000);
403: l_fname VARCHAR2(2000);
404: BEGIN

Line 622: l_x_old_header_rec OE_Order_PUB.Header_Rec_Type;

618: , x_msg_data OUT NOCOPY VARCHAR2
619: , p_header_id IN NUMBER
620: )
621: IS
622: l_x_old_header_rec OE_Order_PUB.Header_Rec_Type;
623: l_control_rec OE_GLOBALS.Control_Rec_Type;
624: l_return_status VARCHAR2(1);
625: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
626: BEGIN

Line 625: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

621: IS
622: l_x_old_header_rec OE_Order_PUB.Header_Rec_Type;
623: l_control_rec OE_GLOBALS.Control_Rec_Type;
624: l_return_status VARCHAR2(1);
625: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
626: BEGIN
627: SAVEPOINT Header_Delete;
628: oe_debug_pub.add('Entering Oe_Oe_Html_Header.DELETE_ROW', 1);
629:

Line 761: l_line_tbl oe_order_pub.line_tbl_type;

757: )
758: IS
759: l_return_status VARCHAR2(1);
760: l_control_rec OE_GLOBALS.Control_Rec_Type;
761: l_line_tbl oe_order_pub.line_tbl_type;
762: BEGIN
763: oe_debug_pub.add('Entering Oe_Oe_Html_Header.PROCESS_OBJECT', 1);
764:
765: OE_MSG_PUB.initialize;

Line 908: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

904: )
905:
906: IS
907: l_return_status VARCHAR2(1);
908: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
909: BEGIN
910:
911: oe_debug_pub.add('Entering Oe_Oe_Html_Header.LOCK_ROW', 1);
912:

Line 1009: g_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;

1005: BEGIN
1006:
1007: oe_debug_pub.add('Entering Oe_Oe_Html_Header.CLEAR_HEADER', 1);
1008:
1009: g_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1010: g_db_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1011:
1012: oe_debug_pub.add('Exiting Oe_Oe_Html_Header.CLEAR_HEADER', 1);
1013:

Line 1010: g_db_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;

1006:
1007: oe_debug_pub.add('Entering Oe_Oe_Html_Header.CLEAR_HEADER', 1);
1008:
1009: g_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1010: g_db_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1011:
1012: oe_debug_pub.add('Exiting Oe_Oe_Html_Header.CLEAR_HEADER', 1);
1013:
1014: END Clear_Header;

Line 1142: p_header_rec IN OE_Order_PUB.Header_Rec_Type

1138:
1139: END get_customer_details;
1140: Procedure Populate_Transient_Attributes
1141: (
1142: p_header_rec IN OE_Order_PUB.Header_Rec_Type
1143: , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
1144: , x_return_status OUT NOCOPY VARCHAR2
1145: , x_msg_count OUT NOCOPY NUMBER
1146: , x_msg_data OUT NOCOPY VARCHAR2

Line 1143: , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type

1139: END get_customer_details;
1140: Procedure Populate_Transient_Attributes
1141: (
1142: p_header_rec IN OE_Order_PUB.Header_Rec_Type
1143: , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
1144: , x_return_status OUT NOCOPY VARCHAR2
1145: , x_msg_count OUT NOCOPY NUMBER
1146: , x_msg_data OUT NOCOPY VARCHAR2
1147: )