6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_OE_Form_Header_Scredit';
7:
8: -- Global variables holding cached record.
9:
10: g_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
11: g_db_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
7:
8: -- Global variables holding cached record.
9:
10: g_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
11: g_db_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_Header_Scredit
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_Header_Scredit
16: ( p_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type
17: , p_db_record IN BOOLEAN := FALSE
18: );
19:
20: PROCEDURE Get_Header_Scredit
19:
20: PROCEDURE Get_Header_Scredit
21: ( p_db_record IN BOOLEAN := FALSE
22: , p_sales_credit_id IN NUMBER
23: , x_header_scredit_rec OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
24: );
25:
26: PROCEDURE Clear_Header_Scredit;
27:
26: PROCEDURE Clear_Header_Scredit;
27:
28: -- Global variable holding performed operations.
29:
30: g_opr__tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
31:
32: -- Procedure : Default_Attributes
33: --
34:
97: --SG}
98:
99: )
100: IS
101: l_Header_Scredit_val_rec OE_Order_PUB.Header_Scredit_Val_Rec_Type;
102: l_control_rec OE_GLOBALS.Control_Rec_Type;
103: l_return_status VARCHAR2(1);
104: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
105: l_x_Old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
100: IS
101: l_Header_Scredit_val_rec OE_Order_PUB.Header_Scredit_Val_Rec_Type;
102: l_control_rec OE_GLOBALS.Control_Rec_Type;
103: l_return_status VARCHAR2(1);
104: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
105: l_x_Old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
106:
107: --
108: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
101: l_Header_Scredit_val_rec OE_Order_PUB.Header_Scredit_Val_Rec_Type;
102: l_control_rec OE_GLOBALS.Control_Rec_Type;
103: l_return_status VARCHAR2(1);
104: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
105: l_x_Old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
106:
107: --
108: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
109: --
133: l_control_rec.clear_api_cache := FALSE;
134: l_control_rec.clear_api_requests := FALSE;
135:
136: -- Load IN parameters if any exist
137: l_x_Header_Scredit_tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_REC;
138: l_x_old_Header_Scredit_Tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_REC;
139:
140: l_x_Header_Scredit_tbl(1).header_id := p_header_id;
141:
134: l_control_rec.clear_api_requests := FALSE;
135:
136: -- Load IN parameters if any exist
137: l_x_Header_Scredit_tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_REC;
138: l_x_old_Header_Scredit_Tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_REC;
139:
140: l_x_Header_Scredit_tbl(1).header_id := p_header_id;
141:
142: -- Defaulting of flex values is currently done by the form.
390: --SG}
391:
392: )
393: IS
394: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
395: l_Header_Scredit_val_rec OE_Order_PUB.Header_Scredit_Val_Rec_Type;
396: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
397: l_x_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
398: l_control_rec OE_GLOBALS.Control_Rec_Type;
391:
392: )
393: IS
394: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
395: l_Header_Scredit_val_rec OE_Order_PUB.Header_Scredit_Val_Rec_Type;
396: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
397: l_x_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
398: l_control_rec OE_GLOBALS.Control_Rec_Type;
399: l_return_status VARCHAR2(1);
392: )
393: IS
394: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
395: l_Header_Scredit_val_rec OE_Order_PUB.Header_Scredit_Val_Rec_Type;
396: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
397: l_x_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
398: l_control_rec OE_GLOBALS.Control_Rec_Type;
399: l_return_status VARCHAR2(1);
400:
393: IS
394: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
395: l_Header_Scredit_val_rec OE_Order_PUB.Header_Scredit_Val_Rec_Type;
396: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
397: l_x_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
398: l_control_rec OE_GLOBALS.Control_Rec_Type;
399: l_return_status VARCHAR2(1);
400:
401: --
852: , x_lock_control OUT NOCOPY NUMBER
853:
854: )
855: IS
856: l_x_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
857: l_control_rec OE_GLOBALS.Control_Rec_Type;
858: l_return_status VARCHAR2(1);
859: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
860:
855: IS
856: l_x_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
857: l_control_rec OE_GLOBALS.Control_Rec_Type;
858: l_return_status VARCHAR2(1);
859: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
860:
861: --
862: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
863: --
1055: )
1056: IS
1057: l_control_rec OE_GLOBALS.Control_Rec_Type;
1058: l_return_status VARCHAR2(1);
1059: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1060: l_x_Old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1061:
1062: --
1063: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1056: IS
1057: l_control_rec OE_GLOBALS.Control_Rec_Type;
1058: l_return_status VARCHAR2(1);
1059: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1060: l_x_Old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1061:
1062: --
1063: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1064: --
1208:
1209: )
1210: IS
1211: l_return_status VARCHAR2(1);
1212: /*l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1213: l_control_rec OE_GLOBALS.Control_Rec_Type;
1214: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1215: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1216: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1210: IS
1211: l_return_status VARCHAR2(1);
1212: /*l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1213: l_control_rec OE_GLOBALS.Control_Rec_Type;
1214: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1215: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1216: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1217: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1218: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1211: l_return_status VARCHAR2(1);
1212: /*l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1213: l_control_rec OE_GLOBALS.Control_Rec_Type;
1214: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1215: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1216: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1217: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1218: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1219: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1212: /*l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1213: l_control_rec OE_GLOBALS.Control_Rec_Type;
1214: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1215: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1216: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1217: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1218: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1219: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1220: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1213: l_control_rec OE_GLOBALS.Control_Rec_Type;
1214: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1215: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1216: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1217: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1218: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1219: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1220: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1221: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1214: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1215: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1216: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1217: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1218: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1219: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1220: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1221: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1222: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1215: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1216: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1217: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1218: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1219: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1220: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1221: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1222: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1223: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1216: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1217: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1218: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1219: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1220: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1221: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1222: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1223: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1224: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1217: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1218: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1219: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1220: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1221: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1222: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1223: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1224: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1225: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1218: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1219: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1220: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1221: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1222: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1223: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1224: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1225: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1226: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1219: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1220: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1221: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1222: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1223: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1224: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1225: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1226: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1227: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1220: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1221: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1222: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1223: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1224: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1225: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1226: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1227: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1228: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1221: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1222: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1223: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1224: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1225: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1226: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1227: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1228: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1229: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1222: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1223: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1224: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1225: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1226: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1227: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1228: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1229: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1230: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1223: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1224: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1225: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1226: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1227: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1228: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1229: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1230: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1231: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1224: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1225: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1226: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1227: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1228: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1229: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1230: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1231: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1232: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type; */
1225: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1226: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1227: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1228: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1229: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1230: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1231: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1232: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type; */
1233:
1226: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1227: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1228: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1229: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1230: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1231: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1232: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type; */
1233:
1234: --
1227: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1228: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1229: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1230: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1231: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1232: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type; */
1233:
1234: --
1235: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1228: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1229: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1230: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1231: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1232: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type; */
1233:
1234: --
1235: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1236: --
1384: , p_lock_control IN NUMBER
1385: )
1386: IS
1387: l_return_status VARCHAR2(1);
1388: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1389:
1390: --
1391: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1392: --
1462:
1463: -- Procedures maintaining Header_Scredit record cache.
1464:
1465: PROCEDURE Write_Header_Scredit
1466: ( p_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type
1467: , p_db_record IN BOOLEAN := FALSE
1468: )
1469: IS
1470: --
1492:
1493: PROCEDURE Get_Header_Scredit
1494: ( p_db_record IN BOOLEAN := FALSE
1495: , p_sales_credit_id IN NUMBER
1496: , x_header_scredit_rec OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
1497: )
1498: IS
1499: --
1500: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1549: IF l_debug_level > 0 THEN
1550: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER_SCREDIT.CLEAR_HEADER_SCREDIT' , 1 ) ;
1551: END IF;
1552:
1553: g_Header_Scredit_rec := OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC;
1554: g_db_Header_Scredit_rec := OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC;
1555:
1556: IF l_debug_level > 0 THEN
1557: oe_debug_pub.add( 'EXITING OE_OE_FORM_HEADER_SCREDIT.CLEAR_HEADER_SCREDIT' , 1 ) ;
1550: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER_SCREDIT.CLEAR_HEADER_SCREDIT' , 1 ) ;
1551: END IF;
1552:
1553: g_Header_Scredit_rec := OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC;
1554: g_db_Header_Scredit_rec := OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC;
1555:
1556: IF l_debug_level > 0 THEN
1557: oe_debug_pub.add( 'EXITING OE_OE_FORM_HEADER_SCREDIT.CLEAR_HEADER_SCREDIT' , 1 ) ;
1558: END IF;
1559:
1560: END Clear_Header_Scredit;
1561:
1562: --SG{
1563: Procedure Get_Values(p_header_scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type
1564: ,x_header_scredit_val_rec OUT NOCOPY OE_Order_PUB.Header_Scredit_Val_Rec_Type) AS
1565: BEGIN
1566: x_header_scredit_val_rec:=OE_Header_Scredit_Util.Get_Values(p_header_scredit_rec);
1567: END;
1560: END Clear_Header_Scredit;
1561:
1562: --SG{
1563: Procedure Get_Values(p_header_scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type
1564: ,x_header_scredit_val_rec OUT NOCOPY OE_Order_PUB.Header_Scredit_Val_Rec_Type) AS
1565: BEGIN
1566: x_header_scredit_val_rec:=OE_Header_Scredit_Util.Get_Values(p_header_scredit_rec);
1567: END;
1568: --SG}