6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_OE_Form_Line_Payment';
7:
8: -- Global variables holding cached record.
9:
10: g_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
11: g_db_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
7:
8: -- Global variables holding cached record.
9:
10: g_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
11: g_db_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_Line_Payment
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_Line_Payment
16: ( p_Line_Payment_rec IN OE_Order_PUB.Line_PAYMENT_Rec_Type
17: , p_db_record IN BOOLEAN := FALSE
18: );
19:
20: PROCEDURE Get_Line_Payment
21: ( p_db_record IN BOOLEAN := FALSE
22: , p_payment_number IN NUMBER
23: , p_line_id IN NUMBER
24: , p_header_id IN NUMBER
25: , x_line_Payment_rec OUT NOCOPY OE_Order_PUB.Line_PAYMENT_Rec_Type
26: );
27:
28: PROCEDURE Clear_Line_Payment;
29:
28: PROCEDURE Clear_Line_Payment;
29:
30: -- Global variable holding performed operations.
31:
32: g_opr__tbl OE_Order_PUB.Line_Payment_Tbl_Type;
33:
34: -- Procedure : Default_Attributes
35: --
36:
84: , x_trxn_extension_id OUT NOCOPY NUMBER --R12 process order api changes
85: , x_instrument_security_code OUT NOCOPY VARCHAR2 --R12 CC Encryption
86: )
87: IS
88: l_Line_Payment_val_rec OE_Order_PUB.Line_Payment_Val_Rec_Type;
89: l_control_rec OE_GLOBALS.Control_Rec_Type;
90: l_return_status VARCHAR2(1);
91: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
92: l_x_Old_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
87: IS
88: l_Line_Payment_val_rec OE_Order_PUB.Line_Payment_Val_Rec_Type;
89: l_control_rec OE_GLOBALS.Control_Rec_Type;
90: l_return_status VARCHAR2(1);
91: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
92: l_x_Old_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
93:
94: --
95: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
88: l_Line_Payment_val_rec OE_Order_PUB.Line_Payment_Val_Rec_Type;
89: l_control_rec OE_GLOBALS.Control_Rec_Type;
90: l_return_status VARCHAR2(1);
91: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
92: l_x_Old_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
93:
94: --
95: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
96: --
134: l_control_rec.clear_api_cache := FALSE;
135: l_control_rec.clear_api_requests := FALSE;
136:
137: -- Load IN parameters if any exist
138: l_x_Line_Payment_tbl(1):=OE_ORDER_PUB.G_MISS_LINE_PAYMENT_REC;
139: l_x_old_Line_Payment_Tbl(1):=OE_ORDER_PUB.G_MISS_LINE_PAYMENT_REC;
140:
141: l_x_Line_Payment_tbl(1).payment_number := p_payment_number;
142: l_x_Line_Payment_tbl(1).line_id := p_line_id;
135: l_control_rec.clear_api_requests := FALSE;
136:
137: -- Load IN parameters if any exist
138: l_x_Line_Payment_tbl(1):=OE_ORDER_PUB.G_MISS_LINE_PAYMENT_REC;
139: l_x_old_Line_Payment_Tbl(1):=OE_ORDER_PUB.G_MISS_LINE_PAYMENT_REC;
140:
141: l_x_Line_Payment_tbl(1).payment_number := p_payment_number;
142: l_x_Line_Payment_tbl(1).line_id := p_line_id;
143: l_x_Line_Payment_tbl(1).header_id := l_header_id;
393: , x_defer_processing_flag OUT NOCOPY VARCHAR2
394: , x_instrument_security_code OUT NOCOPY VARCHAR2 --R12 CC Encryption
395: )
396: IS
397: l_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
398: l_Line_Payment_val_rec OE_Order_PUB.Line_PAYMENT_Val_Rec_Type;
399: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
400: l_x_old_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
401: l_control_rec OE_GLOBALS.Control_Rec_Type;
394: , x_instrument_security_code OUT NOCOPY VARCHAR2 --R12 CC Encryption
395: )
396: IS
397: l_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
398: l_Line_Payment_val_rec OE_Order_PUB.Line_PAYMENT_Val_Rec_Type;
399: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
400: l_x_old_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
401: l_control_rec OE_GLOBALS.Control_Rec_Type;
402: l_return_status VARCHAR2(1);
395: )
396: IS
397: l_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
398: l_Line_Payment_val_rec OE_Order_PUB.Line_PAYMENT_Val_Rec_Type;
399: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
400: l_x_old_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
401: l_control_rec OE_GLOBALS.Control_Rec_Type;
402: l_return_status VARCHAR2(1);
403:
396: IS
397: l_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
398: l_Line_Payment_val_rec OE_Order_PUB.Line_PAYMENT_Val_Rec_Type;
399: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
400: l_x_old_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
401: l_control_rec OE_GLOBALS.Control_Rec_Type;
402: l_return_status VARCHAR2(1);
403:
404: --
932:
933: PROCEDURE Copy_Attribute_To_Rec
934: ( p_attr_id IN NUMBER
935: , p_attr_value IN VARCHAR2
936: , x_line_payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_PAYMENT_Tbl_Type
937: , x_old_line_payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_PAYMENT_Tbl_Type
938: , p_attribute1 IN VARCHAR2
939: , p_attribute2 IN VARCHAR2
940: , p_attribute3 IN VARCHAR2
933: PROCEDURE Copy_Attribute_To_Rec
934: ( p_attr_id IN NUMBER
935: , p_attr_value IN VARCHAR2
936: , x_line_payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_PAYMENT_Tbl_Type
937: , x_old_line_payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_PAYMENT_Tbl_Type
938: , p_attribute1 IN VARCHAR2
939: , p_attribute2 IN VARCHAR2
940: , p_attribute3 IN VARCHAR2
941: , p_attribute4 IN VARCHAR2
1100: , x_request_id OUT NOCOPY NUMBER
1101: , x_lock_control OUT NOCOPY NUMBER
1102: )
1103: IS
1104: l_x_old_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
1105: l_control_rec OE_GLOBALS.Control_Rec_Type;
1106: l_return_status VARCHAR2(1);
1107: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
1108:
1103: IS
1104: l_x_old_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
1105: l_control_rec OE_GLOBALS.Control_Rec_Type;
1106: l_return_status VARCHAR2(1);
1107: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
1108:
1109: --
1110: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1111: --
1280: )
1281: IS
1282: l_control_rec OE_GLOBALS.Control_Rec_Type;
1283: l_return_status VARCHAR2(1);
1284: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
1285: l_x_Old_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
1286:
1287: --
1288: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1281: IS
1282: l_control_rec OE_GLOBALS.Control_Rec_Type;
1283: l_return_status VARCHAR2(1);
1284: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
1285: l_x_Old_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
1286:
1287: --
1288: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1289: --
1431: , x_msg_data OUT NOCOPY VARCHAR2
1432: )
1433: IS
1434: l_return_status VARCHAR2(1);
1435: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1436: l_control_rec OE_GLOBALS.Control_Rec_Type;
1437: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1438: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1439: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1433: IS
1434: l_return_status VARCHAR2(1);
1435: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1436: l_control_rec OE_GLOBALS.Control_Rec_Type;
1437: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1438: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1439: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1440: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1441: l_x_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
1434: l_return_status VARCHAR2(1);
1435: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1436: l_control_rec OE_GLOBALS.Control_Rec_Type;
1437: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1438: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1439: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1440: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1441: l_x_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
1442: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
1435: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1436: l_control_rec OE_GLOBALS.Control_Rec_Type;
1437: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1438: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1439: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1440: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1441: l_x_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
1442: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
1443: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1436: l_control_rec OE_GLOBALS.Control_Rec_Type;
1437: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1438: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1439: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1440: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1441: l_x_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
1442: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
1443: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1444: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1437: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1438: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1439: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1440: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1441: l_x_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
1442: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
1443: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1444: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1445: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1438: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1439: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1440: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1441: l_x_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
1442: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
1443: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1444: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1445: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1446: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1439: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1440: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1441: l_x_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
1442: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
1443: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1444: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1445: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1446: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1447: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1440: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1441: l_x_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
1442: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
1443: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1444: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1445: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1446: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1447: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1448: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1441: l_x_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
1442: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
1443: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1444: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1445: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1446: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1447: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1448: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1449: l_x_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
1442: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
1443: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1444: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1445: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1446: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1447: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1448: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1449: l_x_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
1450: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
1443: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1444: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1445: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1446: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1447: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1448: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1449: l_x_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
1450: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
1451: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1444: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1445: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1446: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1447: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1448: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1449: l_x_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
1450: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
1451: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1452: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1445: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1446: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1447: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1448: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1449: l_x_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
1450: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
1451: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1452: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1453: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1446: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1447: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1448: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1449: l_x_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
1450: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
1451: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1452: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1453: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1454: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1447: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1448: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1449: l_x_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
1450: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
1451: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1452: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1453: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1454: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1455: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1448: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1449: l_x_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
1450: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
1451: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1452: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1453: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1454: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1455: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1456: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1449: l_x_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
1450: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
1451: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1452: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1453: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1454: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1455: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1456: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1457: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1450: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
1451: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1452: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1453: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1454: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1455: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1456: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1457: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1458: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1451: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1452: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1453: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1454: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1455: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1456: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1457: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1458: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1459: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1452: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1453: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1454: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1455: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1456: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1457: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1458: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1459: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1460:
1453: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1454: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1455: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1456: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1457: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1458: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1459: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1460:
1461: --
1454: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1455: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1456: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1457: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1458: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1459: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1460:
1461: --
1462: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1455: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1456: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1457: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1458: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1459: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1460:
1461: --
1462: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1463: --
1612: , p_lock_control IN NUMBER
1613: )
1614: IS
1615: l_return_status VARCHAR2(1);
1616: l_x_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
1617:
1618: --
1619: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1620: --
1692:
1693: -- Procedures maintaining Line_Payment record cache.
1694:
1695: PROCEDURE Write_Line_Payment
1696: ( p_Line_Payment_rec IN OE_Order_PUB.Line_PAYMENT_Rec_Type
1697: , p_db_record IN BOOLEAN := FALSE
1698: )
1699: IS
1700: --
1724: ( p_db_record IN BOOLEAN := FALSE
1725: , p_payment_number IN NUMBER
1726: , p_line_id IN NUMBER
1727: , p_header_id IN NUMBER
1728: , x_line_Payment_rec OUT NOCOPY OE_Order_PUB.Line_PAYMENT_Rec_Type
1729: )
1730: IS
1731: --
1732: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1783: IF l_debug_level > 0 THEN
1784: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_Payment.CLEAR_LINE_PAYMENT' , 1 ) ;
1785: END IF;
1786:
1787: g_Line_Payment_rec := OE_Order_PUB.G_MISS_LINE_PAYMENT_REC;
1788: g_db_Line_Payment_rec := OE_Order_PUB.G_MISS_LINE_PAYMENT_REC;
1789:
1790: IF l_debug_level > 0 THEN
1791: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_Payment.CLEAR_LINE_PAYMENT' , 1 ) ;
1784: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_Payment.CLEAR_LINE_PAYMENT' , 1 ) ;
1785: END IF;
1786:
1787: g_Line_Payment_rec := OE_Order_PUB.G_MISS_LINE_PAYMENT_REC;
1788: g_db_Line_Payment_rec := OE_Order_PUB.G_MISS_LINE_PAYMENT_REC;
1789:
1790: IF l_debug_level > 0 THEN
1791: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_Payment.CLEAR_LINE_PAYMENT' , 1 ) ;
1792: END IF;