DBA Data[Home] [Help]

APPS.OE_OE_FORM_HEADER_PAYMENT dependencies on OE_ORDER_PUB

Line 10: g_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;

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

Line 11: g_db_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;

7:
8: -- Global variables holding cached record.
9:
10: g_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
11: g_db_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_Header_Payment

Line 16: ( p_Header_Payment_rec IN OE_Order_PUB.Header_PAYMENT_Rec_Type

12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_Header_Payment
16: ( p_Header_Payment_rec IN OE_Order_PUB.Header_PAYMENT_Rec_Type
17: , p_db_record IN BOOLEAN := FALSE
18: );
19:
20: PROCEDURE Get_Header_Payment

Line 24: , x_header_Payment_rec OUT NOCOPY OE_Order_PUB.Header_PAYMENT_Rec_Type

20: PROCEDURE Get_Header_Payment
21: ( p_db_record IN BOOLEAN := FALSE
22: , p_payment_number IN NUMBER
23: , p_header_id IN NUMBER
24: , x_header_Payment_rec OUT NOCOPY OE_Order_PUB.Header_PAYMENT_Rec_Type
25: );
26:
27: PROCEDURE Clear_Header_Payment;
28:

Line 31: g_opr__tbl OE_Order_PUB.Header_Payment_Tbl_Type;

27: PROCEDURE Clear_Header_Payment;
28:
29: -- Global variable holding performed operations.
30:
31: g_opr__tbl OE_Order_PUB.Header_Payment_Tbl_Type;
32:
33: -- Procedure : Default_Attributes
34: --
35:

Line 87: l_Header_Payment_val_rec OE_Order_PUB.Header_Payment_Val_Rec_Type;

83: , x_trxn_extension_id OUT NOCOPY NUMBER
84: , x_instrument_security_code OUT NOCOPY VARCHAR2 --R12 CC Encryption
85: )
86: IS
87: l_Header_Payment_val_rec OE_Order_PUB.Header_Payment_Val_Rec_Type;
88: l_control_rec OE_GLOBALS.Control_Rec_Type;
89: l_return_status VARCHAR2(1);
90: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
91: l_x_Old_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

Line 90: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

86: IS
87: l_Header_Payment_val_rec OE_Order_PUB.Header_Payment_Val_Rec_Type;
88: l_control_rec OE_GLOBALS.Control_Rec_Type;
89: l_return_status VARCHAR2(1);
90: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
91: l_x_Old_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
92:
93: --
94: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 91: l_x_Old_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

87: l_Header_Payment_val_rec OE_Order_PUB.Header_Payment_Val_Rec_Type;
88: l_control_rec OE_GLOBALS.Control_Rec_Type;
89: l_return_status VARCHAR2(1);
90: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
91: l_x_Old_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
92:
93: --
94: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
95: --

Line 123: l_x_Header_Payment_tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;

119: l_control_rec.clear_api_cache := FALSE;
120: l_control_rec.clear_api_requests := FALSE;
121:
122: -- Load IN parameters if any exist
123: l_x_Header_Payment_tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
124: l_x_old_Header_Payment_Tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
125:
126: l_x_Header_Payment_tbl(1).header_id := p_header_id;
127: l_x_Header_Payment_tbl(1).payment_number := p_payment_number;

Line 124: l_x_old_Header_Payment_Tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;

120: l_control_rec.clear_api_requests := FALSE;
121:
122: -- Load IN parameters if any exist
123: l_x_Header_Payment_tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
124: l_x_old_Header_Payment_Tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
125:
126: l_x_Header_Payment_tbl(1).header_id := p_header_id;
127: l_x_Header_Payment_tbl(1).payment_number := p_payment_number;
128:

Line 379: l_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;

375: , x_defer_processing_flag OUT NOCOPY VARCHAR2
376: , x_instrument_security_code OUT NOCOPY VARCHAR2 --R12 CC Encryption
377: )
378: IS
379: l_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
380: l_Header_Payment_val_rec OE_Order_PUB.Header_PAYMENT_Val_Rec_Type;
381: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
382: l_x_old_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
383: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 380: l_Header_Payment_val_rec OE_Order_PUB.Header_PAYMENT_Val_Rec_Type;

376: , x_instrument_security_code OUT NOCOPY VARCHAR2 --R12 CC Encryption
377: )
378: IS
379: l_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
380: l_Header_Payment_val_rec OE_Order_PUB.Header_PAYMENT_Val_Rec_Type;
381: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
382: l_x_old_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
383: l_control_rec OE_GLOBALS.Control_Rec_Type;
384: l_return_status VARCHAR2(1);

Line 381: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;

377: )
378: IS
379: l_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
380: l_Header_Payment_val_rec OE_Order_PUB.Header_PAYMENT_Val_Rec_Type;
381: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
382: l_x_old_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
383: l_control_rec OE_GLOBALS.Control_Rec_Type;
384: l_return_status VARCHAR2(1);
385:

Line 382: l_x_old_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;

378: IS
379: l_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
380: l_Header_Payment_val_rec OE_Order_PUB.Header_PAYMENT_Val_Rec_Type;
381: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
382: l_x_old_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
383: l_control_rec OE_GLOBALS.Control_Rec_Type;
384: l_return_status VARCHAR2(1);
385:
386: --

Line 923: , x_header_payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_PAYMENT_Tbl_Type

919:
920: PROCEDURE Copy_Attribute_To_Rec
921: ( p_attr_id IN NUMBER
922: , p_attr_value IN VARCHAR2
923: , x_header_payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_PAYMENT_Tbl_Type
924: , x_old_header_payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_PAYMENT_Tbl_Type
925: , p_attribute1 IN VARCHAR2
926: , p_attribute2 IN VARCHAR2
927: , p_attribute3 IN VARCHAR2

Line 924: , x_old_header_payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_PAYMENT_Tbl_Type

920: PROCEDURE Copy_Attribute_To_Rec
921: ( p_attr_id IN NUMBER
922: , p_attr_value IN VARCHAR2
923: , x_header_payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_PAYMENT_Tbl_Type
924: , x_old_header_payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_PAYMENT_Tbl_Type
925: , p_attribute1 IN VARCHAR2
926: , p_attribute2 IN VARCHAR2
927: , p_attribute3 IN VARCHAR2
928: , p_attribute4 IN VARCHAR2

Line 1092: l_x_old_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;

1088: , x_request_id OUT NOCOPY NUMBER
1089: , x_lock_control OUT NOCOPY NUMBER
1090: )
1091: IS
1092: l_x_old_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
1093: l_control_rec OE_GLOBALS.Control_Rec_Type;
1094: l_return_status VARCHAR2(1);
1095: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
1096:

Line 1095: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;

1091: IS
1092: l_x_old_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
1093: l_control_rec OE_GLOBALS.Control_Rec_Type;
1094: l_return_status VARCHAR2(1);
1095: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
1096:
1097: --
1098: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1099: --

Line 1269: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

1265: )
1266: IS
1267: l_control_rec OE_GLOBALS.Control_Rec_Type;
1268: l_return_status VARCHAR2(1);
1269: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1270: l_x_Old_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1271:
1272: --
1273: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1270: l_x_Old_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

1266: IS
1267: l_control_rec OE_GLOBALS.Control_Rec_Type;
1268: l_return_status VARCHAR2(1);
1269: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1270: l_x_Old_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1271:
1272: --
1273: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1274: --

Line 1419: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

1415: , x_msg_data OUT NOCOPY VARCHAR2
1416: )
1417: IS
1418: l_return_status VARCHAR2(1);
1419: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1420: l_control_rec OE_GLOBALS.Control_Rec_Type;
1421: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1422: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1423: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

Line 1421: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

1417: IS
1418: l_return_status VARCHAR2(1);
1419: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1420: l_control_rec OE_GLOBALS.Control_Rec_Type;
1421: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1422: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1423: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1424: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1425: l_x_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;

Line 1422: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

1418: l_return_status VARCHAR2(1);
1419: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1420: l_control_rec OE_GLOBALS.Control_Rec_Type;
1421: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1422: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1423: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1424: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1425: l_x_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
1426: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;

Line 1423: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

1419: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1420: l_control_rec OE_GLOBALS.Control_Rec_Type;
1421: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1422: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1423: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1424: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1425: l_x_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
1426: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
1427: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

Line 1424: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

1420: l_control_rec OE_GLOBALS.Control_Rec_Type;
1421: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1422: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1423: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1424: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1425: l_x_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
1426: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
1427: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1428: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 1425: l_x_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;

1421: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1422: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1423: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1424: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1425: l_x_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
1426: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
1427: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1428: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1429: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 1426: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;

1422: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1423: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1424: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1425: l_x_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
1426: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
1427: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1428: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1429: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1430: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 1427: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

1423: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1424: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1425: l_x_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
1426: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
1427: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1428: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1429: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1430: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1431: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

Line 1428: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

1424: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1425: l_x_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
1426: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
1427: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1428: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1429: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1430: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1431: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1432: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 1429: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

1425: l_x_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
1426: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
1427: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1428: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1429: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1430: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1431: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1432: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1433: l_x_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;

Line 1430: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

1426: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
1427: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1428: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1429: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1430: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1431: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1432: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1433: l_x_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
1434: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;

Line 1431: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

1427: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1428: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1429: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1430: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1431: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1432: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1433: l_x_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
1434: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
1435: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

Line 1432: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

1428: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1429: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1430: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1431: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1432: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1433: l_x_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
1434: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
1435: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1436: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 1433: l_x_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;

1429: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1430: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1431: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1432: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1433: l_x_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
1434: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
1435: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1436: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1437: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

Line 1434: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;

1430: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1431: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1432: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1433: l_x_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
1434: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
1435: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1436: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1437: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1438: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 1435: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

1431: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1432: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1433: l_x_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
1434: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
1435: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1436: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1437: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1438: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1439: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 1436: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

1432: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1433: l_x_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
1434: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
1435: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1436: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1437: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1438: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1439: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1440: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 1437: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

1433: l_x_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
1434: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
1435: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1436: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1437: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1438: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1439: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1440: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1441: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 1438: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

1434: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
1435: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1436: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1437: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1438: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1439: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1440: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1441: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1442: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 1439: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

1435: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1436: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1437: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1438: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1439: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1440: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1441: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1442: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1443: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 1440: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

1436: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1437: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1438: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1439: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1440: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1441: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1442: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1443: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1444:

Line 1441: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

1437: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1438: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1439: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1440: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1441: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1442: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1443: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1444:
1445: --

Line 1442: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

1438: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1439: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1440: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1441: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1442: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1443: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1444:
1445: --
1446: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1443: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

1439: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1440: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1441: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1442: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1443: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1444:
1445: --
1446: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1447: --

Line 1599: l_x_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;

1595: , p_lock_control IN NUMBER
1596: )
1597: IS
1598: l_return_status VARCHAR2(1);
1599: l_x_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
1600:
1601: --
1602: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1603: --

Line 1678: ( p_Header_Payment_rec IN OE_Order_PUB.Header_PAYMENT_Rec_Type

1674:
1675: -- Procedures maintaining Header_Payment record cache.
1676:
1677: PROCEDURE Write_Header_Payment
1678: ( p_Header_Payment_rec IN OE_Order_PUB.Header_PAYMENT_Rec_Type
1679: , p_db_record IN BOOLEAN := FALSE
1680: )
1681: IS
1682: --

Line 1709: , x_header_Payment_rec OUT NOCOPY OE_Order_PUB.Header_PAYMENT_Rec_Type

1705: PROCEDURE Get_Header_Payment
1706: ( p_db_record IN BOOLEAN := FALSE
1707: , p_payment_number IN NUMBER
1708: , p_header_id IN NUMBER
1709: , x_header_Payment_rec OUT NOCOPY OE_Order_PUB.Header_PAYMENT_Rec_Type
1710: )
1711: IS
1712: --
1713: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1768: g_Header_Payment_rec := OE_Order_PUB.G_MISS_HEADER_PAYMENT_REC;

1764: IF l_debug_level > 0 THEN
1765: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER_Payment.CLEAR_HEADER_PAYMENT' , 1 ) ;
1766: END IF;
1767:
1768: g_Header_Payment_rec := OE_Order_PUB.G_MISS_HEADER_PAYMENT_REC;
1769: g_db_Header_Payment_rec := OE_Order_PUB.G_MISS_HEADER_PAYMENT_REC;
1770:
1771: IF l_debug_level > 0 THEN
1772: oe_debug_pub.add( 'EXITING OE_OE_FORM_HEADER_Payment.CLEAR_HEADER_PAYMENT' , 1 ) ;

Line 1769: g_db_Header_Payment_rec := OE_Order_PUB.G_MISS_HEADER_PAYMENT_REC;

1765: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER_Payment.CLEAR_HEADER_PAYMENT' , 1 ) ;
1766: END IF;
1767:
1768: g_Header_Payment_rec := OE_Order_PUB.G_MISS_HEADER_PAYMENT_REC;
1769: g_db_Header_Payment_rec := OE_Order_PUB.G_MISS_HEADER_PAYMENT_REC;
1770:
1771: IF l_debug_level > 0 THEN
1772: oe_debug_pub.add( 'EXITING OE_OE_FORM_HEADER_Payment.CLEAR_HEADER_PAYMENT' , 1 ) ;
1773: END IF;