DBA Data[Home] [Help]

APPS.OE_OE_FORM_LINE_PAYMENT dependencies on OE_ORDER_PUB

Line 10: g_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;

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:

Line 11: g_db_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;

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

Line 16: ( p_Line_Payment_rec IN OE_Order_PUB.Line_PAYMENT_Rec_Type

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

Line 25: , x_line_Payment_rec OUT NOCOPY OE_Order_PUB.Line_PAYMENT_Rec_Type

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:

Line 32: g_opr__tbl OE_Order_PUB.Line_Payment_Tbl_Type;

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:

Line 88: l_Line_Payment_val_rec OE_Order_PUB.Line_Payment_Val_Rec_Type;

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;

Line 91: l_x_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;

Line 92: l_x_Old_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

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: --

Line 138: l_x_Line_Payment_tbl(1):=OE_ORDER_PUB.G_MISS_LINE_PAYMENT_REC;

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;

Line 139: l_x_old_Line_Payment_Tbl(1):=OE_ORDER_PUB.G_MISS_LINE_PAYMENT_REC;

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;

Line 397: l_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;

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;

Line 398: l_Line_Payment_val_rec OE_Order_PUB.Line_PAYMENT_Val_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);

Line 399: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;

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:

Line 400: l_x_old_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;

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: --

Line 936: , x_line_payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_PAYMENT_Tbl_Type

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

Line 937: , x_old_line_payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_PAYMENT_Tbl_Type

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

Line 1104: l_x_old_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;

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:

Line 1107: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;

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: --

Line 1284: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

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;

Line 1285: l_x_Old_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

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: --

Line 1435: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

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;

Line 1437: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_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;

Line 1438: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_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;

Line 1439: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_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;

Line 1440: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_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;

Line 1441: l_x_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_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;
1445: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 1442: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_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;

Line 1443: l_x_line_rec OE_Order_PUB.Line_Rec_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;

Line 1444: l_x_line_tbl OE_Order_PUB.Line_Tbl_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;

Line 1445: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_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;

Line 1446: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_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;

Line 1447: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_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;

Line 1448: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_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;

Line 1449: l_x_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_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;

Line 1450: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_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;

Line 1451: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_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;

Line 1452: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_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;

Line 1453: l_x_action_request_tbl OE_Order_PUB.request_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;

Line 1454: l_x_Header_price_Att_tbl OE_Order_PUB.Header_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;

Line 1455: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_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;

Line 1456: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_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:

Line 1457: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_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:
1461: --

Line 1458: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_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: --
1462: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1459: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_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;
1463: --

Line 1616: l_x_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;

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: --

Line 1696: ( p_Line_Payment_rec IN OE_Order_PUB.Line_PAYMENT_Rec_Type

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: --

Line 1728: , x_line_Payment_rec OUT NOCOPY OE_Order_PUB.Line_PAYMENT_Rec_Type

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;

Line 1787: g_Line_Payment_rec := OE_Order_PUB.G_MISS_LINE_PAYMENT_REC;

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 ) ;

Line 1788: g_db_Line_Payment_rec := OE_Order_PUB.G_MISS_LINE_PAYMENT_REC;

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;