eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_OE_FORM_LINE_SCREDIT dependencies on OE_ORDER_PUB

Line 10: g_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

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

Line 11: g_db_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

7:
8: -- Global variables holding cached record.
9:
10: g_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
11: g_db_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_Line_Scredit

Line 16: ( p_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type

12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_Line_Scredit
16: ( p_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type
17: , p_db_record IN BOOLEAN := FALSE
18: );
19:
20: PROCEDURE Get_Line_Scredit

Line 23: , x_line_scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type

19:
20: PROCEDURE Get_Line_Scredit
21: ( p_db_record IN BOOLEAN := FALSE
22: , p_sales_credit_id IN NUMBER
23: , x_line_scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
24: );
25:
26: PROCEDURE Clear_Line_Scredit;
27:

Line 30: g_opr__tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

26: PROCEDURE Clear_Line_Scredit;
27:
28: -- Global variable holding performed operations.
29:
30: g_opr__tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
31:
32: -- Procedure : Default_Attributes
33: --
34:

Line 100: l_Line_Scredit_val_rec OE_Order_PUB.Line_Scredit_Val_Rec_Type;

96: , x_sales_group_updated_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97: --SG}
98: )
99: IS
100: l_Line_Scredit_val_rec OE_Order_PUB.Line_Scredit_Val_Rec_Type;
101: l_control_rec OE_GLOBALS.Control_Rec_Type;
102: l_return_status VARCHAR2(1);
103: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
104: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 103: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

99: IS
100: l_Line_Scredit_val_rec OE_Order_PUB.Line_Scredit_Val_Rec_Type;
101: l_control_rec OE_GLOBALS.Control_Rec_Type;
102: l_return_status VARCHAR2(1);
103: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
104: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
105: l_x_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
106:
107: --

Line 104: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

100: l_Line_Scredit_val_rec OE_Order_PUB.Line_Scredit_Val_Rec_Type;
101: l_control_rec OE_GLOBALS.Control_Rec_Type;
102: l_return_status VARCHAR2(1);
103: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
104: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
105: l_x_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
106:
107: --
108: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 105: l_x_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

101: l_control_rec OE_GLOBALS.Control_Rec_Type;
102: l_return_status VARCHAR2(1);
103: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
104: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
105: l_x_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
106:
107: --
108: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
109: --

Line 137: l_x_Line_Scredit_rec:=OE_ORDER_PUB.G_MISS_LINE_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_Line_Scredit_rec:=OE_ORDER_PUB.G_MISS_LINE_SCREDIT_REC;
138: l_x_old_Line_Scredit_Tbl(1):=OE_ORDER_PUB.G_MISS_LINE_SCREDIT_REC;
139:
140: l_x_Line_Scredit_rec.line_id := p_line_id;
141:

Line 138: l_x_old_Line_Scredit_Tbl(1):=OE_ORDER_PUB.G_MISS_LINE_SCREDIT_REC;

134: l_control_rec.clear_api_requests := FALSE;
135:
136: -- Load IN parameters if any exist
137: l_x_Line_Scredit_rec:=OE_ORDER_PUB.G_MISS_LINE_SCREDIT_REC;
138: l_x_old_Line_Scredit_Tbl(1):=OE_ORDER_PUB.G_MISS_LINE_SCREDIT_REC;
139:
140: l_x_Line_Scredit_rec.line_id := p_line_id;
141:
142: -- Defaulting of flex values is currently done by the form.

Line 397: l_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

393: --SG}
394:
395: )
396: IS
397: l_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
398: l_old_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
399: l_Line_Scredit_val_rec OE_Order_PUB.Line_Scredit_Val_Rec_Type;
400: l_control_rec OE_GLOBALS.Control_Rec_Type;
401: l_return_status VARCHAR2(1);

Line 398: l_old_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

394:
395: )
396: IS
397: l_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
398: l_old_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
399: l_Line_Scredit_val_rec OE_Order_PUB.Line_Scredit_Val_Rec_Type;
400: l_control_rec OE_GLOBALS.Control_Rec_Type;
401: l_return_status VARCHAR2(1);
402: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

Line 399: l_Line_Scredit_val_rec OE_Order_PUB.Line_Scredit_Val_Rec_Type;

395: )
396: IS
397: l_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
398: l_old_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
399: l_Line_Scredit_val_rec OE_Order_PUB.Line_Scredit_Val_Rec_Type;
400: l_control_rec OE_GLOBALS.Control_Rec_Type;
401: l_return_status VARCHAR2(1);
402: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
403: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 402: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

398: l_old_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
399: l_Line_Scredit_val_rec OE_Order_PUB.Line_Scredit_Val_Rec_Type;
400: l_control_rec OE_GLOBALS.Control_Rec_Type;
401: l_return_status VARCHAR2(1);
402: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
403: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
404: l_x_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
405:
406: --

Line 403: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

399: l_Line_Scredit_val_rec OE_Order_PUB.Line_Scredit_Val_Rec_Type;
400: l_control_rec OE_GLOBALS.Control_Rec_Type;
401: l_return_status VARCHAR2(1);
402: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
403: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
404: l_x_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
405:
406: --
407: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 404: l_x_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

400: l_control_rec OE_GLOBALS.Control_Rec_Type;
401: l_return_status VARCHAR2(1);
402: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
403: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
404: l_x_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
405:
406: --
407: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
408: --

Line 858: l_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

854: , x_lock_control OUT NOCOPY NUMBER
855:
856: )
857: IS
858: l_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
859: l_old_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
860: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
861: l_x_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
862: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 859: l_old_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

855:
856: )
857: IS
858: l_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
859: l_old_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
860: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
861: l_x_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
862: l_control_rec OE_GLOBALS.Control_Rec_Type;
863: l_return_status VARCHAR2(1);

Line 860: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

856: )
857: IS
858: l_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
859: l_old_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
860: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
861: l_x_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
862: l_control_rec OE_GLOBALS.Control_Rec_Type;
863: l_return_status VARCHAR2(1);
864: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 861: l_x_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

857: IS
858: l_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
859: l_old_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
860: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
861: l_x_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
862: l_control_rec OE_GLOBALS.Control_Rec_Type;
863: l_return_status VARCHAR2(1);
864: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
865:

Line 864: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

860: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
861: l_x_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
862: l_control_rec OE_GLOBALS.Control_Rec_Type;
863: l_return_status VARCHAR2(1);
864: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
865:
866: --
867: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
868: --

Line 1070: l_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

1066: , p_change_reason_code IN VARCHAR2 Default Null
1067: , p_change_comments IN VARCHAR2 Default Null
1068: )
1069: IS
1070: l_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1071: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1072: l_control_rec OE_GLOBALS.Control_Rec_Type;
1073: l_return_status VARCHAR2(1);
1074: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 1071: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

1067: , p_change_comments IN VARCHAR2 Default Null
1068: )
1069: IS
1070: l_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1071: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1072: l_control_rec OE_GLOBALS.Control_Rec_Type;
1073: l_return_status VARCHAR2(1);
1074: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1075: l_x_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 1074: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

1070: l_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1071: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1072: l_control_rec OE_GLOBALS.Control_Rec_Type;
1073: l_return_status VARCHAR2(1);
1074: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1075: l_x_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1076:
1077: --
1078: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1075: l_x_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

1071: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1072: l_control_rec OE_GLOBALS.Control_Rec_Type;
1073: l_return_status VARCHAR2(1);
1074: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1075: l_x_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1076:
1077: --
1078: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1079: --

Line 1229: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

1225: )
1226: IS
1227: l_return_status VARCHAR2(1);
1228: /*l_control_rec OE_GLOBALS.Control_Rec_Type;
1229: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1230: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1231: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1232: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1233: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 1230: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

1226: IS
1227: l_return_status VARCHAR2(1);
1228: /*l_control_rec OE_GLOBALS.Control_Rec_Type;
1229: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1230: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1231: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1232: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1233: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1234: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

Line 1231: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

1227: l_return_status VARCHAR2(1);
1228: /*l_control_rec OE_GLOBALS.Control_Rec_Type;
1229: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1230: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1231: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1232: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1233: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1234: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1235: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 1232: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

1228: /*l_control_rec OE_GLOBALS.Control_Rec_Type;
1229: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1230: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1231: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1232: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1233: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1234: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1235: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1236: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 1233: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

1229: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1230: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1231: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1232: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1233: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1234: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1235: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1236: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1237: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 1234: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

1230: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1231: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1232: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1233: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1234: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1235: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1236: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1237: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1238: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

Line 1235: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

1231: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1232: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1233: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1234: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1235: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1236: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1237: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1238: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1239: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 1236: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

1232: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1233: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1234: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1235: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1236: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1237: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1238: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1239: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1240: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

Line 1237: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

1233: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1234: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1235: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1236: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1237: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1238: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1239: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1240: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1241: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 1238: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

1234: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1235: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1236: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1237: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1238: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1239: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1240: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1241: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1242: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

Line 1239: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

1235: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1236: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1237: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1238: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1239: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1240: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1241: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1242: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1243: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 1240: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

1236: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1237: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1238: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1239: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1240: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1241: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1242: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1243: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1244: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 1241: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

1237: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1238: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1239: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1240: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1241: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1242: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1243: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1244: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1245: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 1242: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

1238: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1239: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1240: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1241: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1242: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1243: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1244: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1245: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1246: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 1243: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

1239: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1240: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1241: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1242: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1243: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1244: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1245: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1246: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1247: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 1244: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

1240: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1241: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1242: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1243: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1244: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1245: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1246: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1247: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1248: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type; */

Line 1245: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

1241: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1242: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1243: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1244: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1245: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1246: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1247: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1248: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type; */
1249:

Line 1246: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

1242: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
1243: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1244: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1245: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1246: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1247: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1248: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type; */
1249:
1250: --

Line 1247: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

1243: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1244: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1245: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1246: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1247: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1248: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type; */
1249:
1250: --
1251: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1248: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type; */

1244: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1245: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1246: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1247: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1248: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type; */
1249:
1250: --
1251: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1252: --

Line 1404: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

1400: , p_lock_control IN NUMBER
1401: )
1402: IS
1403: l_return_status VARCHAR2(1);
1404: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1405:
1406: --
1407: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1408: --

Line 1486: ( p_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type

1482:
1483: -- Procedures maintaining Line_Scredit record cache.
1484:
1485: PROCEDURE Write_Line_Scredit
1486: ( p_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type
1487: , p_db_record IN BOOLEAN := FALSE
1488: )
1489: IS
1490: --

Line 1516: , x_line_scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type

1512:
1513: PROCEDURE Get_Line_Scredit
1514: ( p_db_record IN BOOLEAN := FALSE
1515: , p_sales_credit_id IN NUMBER
1516: , x_line_scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
1517: )
1518: IS
1519: --
1520: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1573: g_Line_Scredit_rec := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC;

1569: IF l_debug_level > 0 THEN
1570: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_SCREDIT.CLEAR_LINE_SCREDIT' , 1 ) ;
1571: END IF;
1572:
1573: g_Line_Scredit_rec := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC;
1574: g_db_Line_Scredit_rec := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC;
1575:
1576: IF l_debug_level > 0 THEN
1577: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_SCREDIT.CLEAR_LINE_SCREDIT' , 1 ) ;

Line 1574: g_db_Line_Scredit_rec := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC;

1570: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_SCREDIT.CLEAR_LINE_SCREDIT' , 1 ) ;
1571: END IF;
1572:
1573: g_Line_Scredit_rec := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC;
1574: g_db_Line_Scredit_rec := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC;
1575:
1576: IF l_debug_level > 0 THEN
1577: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_SCREDIT.CLEAR_LINE_SCREDIT' , 1 ) ;
1578: END IF;