eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_OE_FORM_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_Form_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: g_set_of_books_rec Set_Of_Books_Rec_Type;
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: g_set_of_books_rec Set_Of_Books_Rec_Type;
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: -- Following record will be used to store the cascading enabled or disabled

Line 21: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

17:
18: g_cascade_test_record OE_OE_FORM_HEADER.Cascade_record;
19:
20: PROCEDURE Write_header
21: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
22: , p_db_record IN BOOLEAN := FALSE
23: );
24:
25: PROCEDURE Get_header

Line 28: , x_header_rec OUT NOCOPY OE_Order_PUB.Header_Rec_Type

24:
25: PROCEDURE Get_header
26: ( p_db_record IN BOOLEAN := FALSE
27: , p_header_id IN NUMBER
28: , x_header_rec OUT NOCOPY OE_Order_PUB.Header_Rec_Type
29: );
30:
31:
32: FUNCTION Filter_Phone_Number (

Line 49: g_opr__tbl OE_Order_PUB.Header_Tbl_Type;

45: PROCEDURE Clear_header;
46:
47: -- Global variable holding performed operations.
48:
49: g_opr__tbl OE_Order_PUB.Header_Tbl_Type;
50:
51: -- Procedure : Default_Attributes
52: --
53:

Line 58: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type

54: PROCEDURE Default_Attributes
55: ( x_return_status OUT NOCOPY VARCHAR2
56: , x_msg_count OUT NOCOPY NUMBER
57: , x_msg_data OUT NOCOPY VARCHAR2
58: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
59: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
60: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
61: , p_transaction_phase_code IN VARCHAR2
62: )

Line 59: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type

55: ( x_return_status OUT NOCOPY VARCHAR2
56: , x_msg_count OUT NOCOPY NUMBER
57: , x_msg_data OUT NOCOPY VARCHAR2
58: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
59: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
60: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
61: , p_transaction_phase_code IN VARCHAR2
62: )
63: IS

Line 60: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type

56: , x_msg_count OUT NOCOPY NUMBER
57: , x_msg_data OUT NOCOPY VARCHAR2
58: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
59: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
60: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
61: , p_transaction_phase_code IN VARCHAR2
62: )
63: IS
64: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 96: x_old_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;

92:
93: -- Bug 3433343 Begin
94: Clear_Header;
95: -- Bug 3433343 End
96: x_old_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;
97: x_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;
98: x_header_val_rec :=OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;
99:
100: --kmuruges

Line 97: x_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;

93: -- Bug 3433343 Begin
94: Clear_Header;
95: -- Bug 3433343 End
96: x_old_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;
97: x_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;
98: x_header_val_rec :=OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;
99:
100: --kmuruges
101: IF p_transaction_phase_code = 'N' THEN

Line 98: x_header_val_rec :=OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;

94: Clear_Header;
95: -- Bug 3433343 End
96: x_old_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;
97: x_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;
98: x_header_val_rec :=OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;
99:
100: --kmuruges
101: IF p_transaction_phase_code = 'N' THEN
102: x_header_rec.transaction_phase_code := p_transaction_phase_code;

Line 283: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type

279: , p_attr_id_tbl IN Number_Tbl_Type
280: , p_attr_value_tbl IN Varchar2_Tbl_Type
281: , p_header_dff_rec IN Oe_Oe_Form_Header.Header_Dff_Rec_Type
282: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-RRRR HH24:MI:SS'
283: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
284: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
285: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
286:
287: )

Line 284: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type

280: , p_attr_value_tbl IN Varchar2_Tbl_Type
281: , p_header_dff_rec IN Oe_Oe_Form_Header.Header_Dff_Rec_Type
282: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-RRRR HH24:MI:SS'
283: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
284: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
285: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
286:
287: )
288: IS

Line 285: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type

281: , p_header_dff_rec IN Oe_Oe_Form_Header.Header_Dff_Rec_Type
282: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-RRRR HH24:MI:SS'
283: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
284: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
285: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
286:
287: )
288: IS
289: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 899: l_x_old_header_rec OE_Order_PUB.Header_Rec_Type;

895: , x_payment_term_id OUT NOCOPY NUMBER
896: , x_payment_term OUT NOCOPY VARCHAR2
897: )
898: IS
899: l_x_old_header_rec OE_Order_PUB.Header_Rec_Type;
900: l_control_rec OE_GLOBALS.Control_Rec_Type;
901: l_return_status VARCHAR2(1);
902: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
903: BEGIN

Line 902: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

898: IS
899: l_x_old_header_rec OE_Order_PUB.Header_Rec_Type;
900: l_control_rec OE_GLOBALS.Control_Rec_Type;
901: l_return_status VARCHAR2(1);
902: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
903: BEGIN
904:
905: SAVEPOINT Header_Validate_And_Write;
906: OE_HEADER_UTIL.g_rollback_done := 'N'; -- bug 12759791

Line 1123: l_x_old_header_rec OE_Order_PUB.Header_Rec_Type;

1119: , x_msg_data OUT NOCOPY VARCHAR2
1120: , p_header_id IN NUMBER
1121: )
1122: IS
1123: l_x_old_header_rec OE_Order_PUB.Header_Rec_Type;
1124: l_control_rec OE_GLOBALS.Control_Rec_Type;
1125: l_return_status VARCHAR2(1);
1126: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1127: BEGIN

Line 1126: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

1122: IS
1123: l_x_old_header_rec OE_Order_PUB.Header_Rec_Type;
1124: l_control_rec OE_GLOBALS.Control_Rec_Type;
1125: l_return_status VARCHAR2(1);
1126: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1127: BEGIN
1128: SAVEPOINT Header_Delete;
1129: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.DELETE_ROW', 1);
1130:

Line 1367: l_line_tbl oe_order_pub.line_tbl_type;

1363: )
1364: IS
1365: l_return_status VARCHAR2(1);
1366: l_control_rec OE_GLOBALS.Control_Rec_Type;
1367: l_line_tbl oe_order_pub.line_tbl_type;
1368: BEGIN
1369: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.PROCESS_OBJECT', 1);
1370:
1371: OE_MSG_PUB.initialize;

Line 1514: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

1510: )
1511:
1512: IS
1513: l_return_status VARCHAR2(1);
1514: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1515: BEGIN
1516:
1517: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.LOCK_ROW', 1);
1518:

Line 1616: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

1612:
1613: -- Procedures maintaining header record cache.
1614:
1615: PROCEDURE Write_header
1616: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
1617: , p_db_record IN BOOLEAN := FALSE
1618: )
1619: IS
1620: BEGIN

Line 1639: , x_header_rec OUT NOCOPY OE_Order_PUB.Header_Rec_Type

1635:
1636: PROCEDURE Get_header
1637: ( p_db_record IN BOOLEAN := FALSE
1638: , p_header_id IN NUMBER
1639: , x_header_rec OUT NOCOPY OE_Order_PUB.Header_Rec_Type
1640: )
1641: IS
1642:
1643: BEGIN

Line 1685: g_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;

1681: BEGIN
1682:
1683: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.CLEAR_HEADER', 1);
1684:
1685: g_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1686: g_db_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1687:
1688: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.CLEAR_HEADER', 1);
1689:

Line 1686: g_db_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;

1682:
1683: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.CLEAR_HEADER', 1);
1684:
1685: g_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1686: g_db_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1687:
1688: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.CLEAR_HEADER', 1);
1689:
1690: END Clear_Header;

Line 2864: p_old_db_header_rec IN OE_ORDER_PUB.Header_Rec_Type

2860: END Get_GSA_Indicator;
2861:
2862: PROCEDURE CASCADE_HEADER_ATTRIBUTES
2863: (
2864: p_old_db_header_rec IN OE_ORDER_PUB.Header_Rec_Type
2865: , p_header_rec IN OE_ORDER_PUB.Header_Rec_Type
2866: , x_return_status OUT NOCOPY VARCHAR2
2867: , x_msg_count OUT NOCOPY NUMBER
2868: , x_msg_data OUT NOCOPY VARCHAR2

Line 2865: , p_header_rec IN OE_ORDER_PUB.Header_Rec_Type

2861:
2862: PROCEDURE CASCADE_HEADER_ATTRIBUTES
2863: (
2864: p_old_db_header_rec IN OE_ORDER_PUB.Header_Rec_Type
2865: , p_header_rec IN OE_ORDER_PUB.Header_Rec_Type
2866: , x_return_status OUT NOCOPY VARCHAR2
2867: , x_msg_count OUT NOCOPY NUMBER
2868: , x_msg_data OUT NOCOPY VARCHAR2
2869: ) IS

Line 2870: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

2866: , x_return_status OUT NOCOPY VARCHAR2
2867: , x_msg_count OUT NOCOPY NUMBER
2868: , x_msg_data OUT NOCOPY VARCHAR2
2869: ) IS
2870: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2871: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2872: l_line_rec OE_Order_PUB.Line_Rec_Type;
2873: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2874: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 2871: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

2867: , x_msg_count OUT NOCOPY NUMBER
2868: , x_msg_data OUT NOCOPY VARCHAR2
2869: ) IS
2870: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2871: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2872: l_line_rec OE_Order_PUB.Line_Rec_Type;
2873: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2874: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2875: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 2872: l_line_rec OE_Order_PUB.Line_Rec_Type;

2868: , x_msg_data OUT NOCOPY VARCHAR2
2869: ) IS
2870: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2871: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2872: l_line_rec OE_Order_PUB.Line_Rec_Type;
2873: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2874: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2875: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2876: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 2873: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

2869: ) IS
2870: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2871: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2872: l_line_rec OE_Order_PUB.Line_Rec_Type;
2873: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2874: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2875: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2876: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2877: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 2874: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2870: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2871: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2872: l_line_rec OE_Order_PUB.Line_Rec_Type;
2873: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2874: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2875: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2876: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2877: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2878: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;

Line 2875: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2871: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2872: l_line_rec OE_Order_PUB.Line_Rec_Type;
2873: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2874: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2875: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2876: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2877: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2878: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2879: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 2876: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

2872: l_line_rec OE_Order_PUB.Line_Rec_Type;
2873: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2874: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2875: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2876: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2877: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2878: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2879: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2880: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 2877: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

2873: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2874: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2875: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2876: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2877: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2878: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2879: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2880: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2881: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 2878: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;

2874: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2875: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2876: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2877: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2878: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2879: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2880: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2881: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2882: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 2879: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

2875: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2876: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2877: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2878: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2879: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2880: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2881: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2882: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2883: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 2880: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

2876: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2877: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2878: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2879: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2880: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2881: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2882: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2883: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2884: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 2881: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

2877: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2878: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2879: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2880: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2881: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2882: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2883: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2884: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2885: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 2882: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

2878: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2879: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2880: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2881: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2882: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2883: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2884: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2885: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2886: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 2883: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

2879: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2880: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2881: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2882: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2883: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2884: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2885: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2886: l_control_rec OE_GLOBALS.Control_Rec_Type;
2887: l_count NUMBER;

Line 2884: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

2880: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2881: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2882: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2883: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2884: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2885: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2886: l_control_rec OE_GLOBALS.Control_Rec_Type;
2887: l_count NUMBER;
2888: l_return_status VARCHAR2(1);

Line 2885: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

2881: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2882: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2883: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2884: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2885: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2886: l_control_rec OE_GLOBALS.Control_Rec_Type;
2887: l_count NUMBER;
2888: l_return_status VARCHAR2(1);
2889: --serla begin

Line 2890: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

2886: l_control_rec OE_GLOBALS.Control_Rec_Type;
2887: l_count NUMBER;
2888: l_return_status VARCHAR2(1);
2889: --serla begin
2890: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2891: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2892: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
2893: --serla end
2894: BEGIN

Line 2891: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

2887: l_count NUMBER;
2888: l_return_status VARCHAR2(1);
2889: --serla begin
2890: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2891: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2892: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
2893: --serla end
2894: BEGIN
2895: SAVEPOINT Header_Cascade_Attributes;

Line 3603: g_db_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;

3599: -- moved down for bug 3686007
3600:
3601: OE_ORDER_CACHE.g_header_rec.header_id:=null;
3602: OE_GLOBALS.G_HEADER_CREATED := FALSE;
3603: g_db_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
3604:
3605:
3606: END Clear_Global_PO_Cache;
3607:

Line 3613: , x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

3609: ( p_attr_id IN NUMBER
3610: , p_attr_value IN VARCHAR2
3611: , p_header_dff_rec IN OE_OE_FORM_HEADER.header_dff_rec_type
3612: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-YYYY HH24:MI:SS'
3613: , x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
3614: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
3615: )
3616: IS
3617: l_date_format_mask VARCHAR2(30) := p_date_format_mask;

Line 3614: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type

3610: , p_attr_value IN VARCHAR2
3611: , p_header_dff_rec IN OE_OE_FORM_HEADER.header_dff_rec_type
3612: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-YYYY HH24:MI:SS'
3613: , x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
3614: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
3615: )
3616: IS
3617: l_date_format_mask VARCHAR2(30) := p_date_format_mask;
3618: --

Line 4296: l_header_rec OE_ORDER_PUB.Header_rec_type;

4292: x_msg_data IN OUT NOCOPY VARCHAR2,
4293: x_constrained IN OUT NOCOPY BOOLEAN)
4294:
4295: IS
4296: l_header_rec OE_ORDER_PUB.Header_rec_type;
4297: l_operation VARCHAR2(30);
4298: l_result NUMBER;
4299: l_rowtype_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
4300: l_action NUMBER;