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:

Line 1122: l_x_old_header_rec OE_Order_PUB.Header_Rec_Type;

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

Line 1125: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

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

Line 1366: l_line_tbl oe_order_pub.line_tbl_type;

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

Line 1513: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

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

Line 1615: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

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

Line 1638: , x_header_rec OUT NOCOPY OE_Order_PUB.Header_Rec_Type

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

Line 1684: g_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;

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

Line 1685: g_db_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;

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

Line 2863: p_old_db_header_rec IN OE_ORDER_PUB.Header_Rec_Type

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

Line 2864: , p_header_rec IN OE_ORDER_PUB.Header_Rec_Type

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

Line 2869: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

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

Line 2870: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

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

Line 2871: l_line_rec OE_Order_PUB.Line_Rec_Type;

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

Line 2872: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

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

Line 2873: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

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

Line 2874: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

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

Line 2875: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

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

Line 2876: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

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

Line 2877: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;

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

Line 2878: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

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

Line 2879: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

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

Line 2880: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

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

Line 2881: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

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

Line 2882: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

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

Line 2883: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

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

Line 2884: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

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

Line 2889: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

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

Line 2890: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

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

Line 3600: g_db_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;

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

Line 3610: , x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

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

Line 3611: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type

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

Line 4293: l_header_rec OE_ORDER_PUB.Header_rec_type;

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