DBA Data[Home] [Help]

APPS.OE_OE_FORM_HEADER_SCREDIT dependencies on OE_ORDER_PUB

Line 10: g_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

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:

Line 11: g_db_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

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

Line 16: ( p_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type

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

Line 23: , x_header_scredit_rec OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

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:

Line 30: g_opr__tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

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:

Line 101: l_Header_Scredit_val_rec OE_Order_PUB.Header_Scredit_Val_Rec_Type;

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;

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

Line 105: l_x_Old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

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

Line 137: l_x_Header_Scredit_tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_REC;

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:

Line 138: l_x_old_Header_Scredit_Tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_REC;

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.

Line 394: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

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;

Line 395: l_Header_Scredit_val_rec OE_Order_PUB.Header_Scredit_Val_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);

Line 396: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

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:

Line 397: l_x_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

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

Line 856: l_x_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

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:

Line 859: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

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

Line 1059: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

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;

Line 1060: l_x_Old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

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

Line 1212: /*l_x_header_rec OE_Order_PUB.Header_Rec_Type;

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;

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

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

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

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

Line 1218: l_x_line_rec OE_Order_PUB.Line_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;
1222: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

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

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

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

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

Line 1223: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_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;

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

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

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

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

Line 1228: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_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; */

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

Line 1230: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_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:
1234: --

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

Line 1232: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_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;
1236: --

Line 1388: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

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

Line 1466: ( p_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type

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

Line 1496: , x_header_scredit_rec OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

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;

Line 1553: g_Header_Scredit_rec := OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC;

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

Line 1554: g_db_Header_Scredit_rec := OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC;

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;

Line 1563: Procedure Get_Values(p_header_scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type

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;

Line 1564: ,x_header_scredit_val_rec OUT NOCOPY OE_Order_PUB.Header_Scredit_Val_Rec_Type) AS

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}