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 dependencies on OE_ORDER_PUB

Line 10: g_line_rec OE_Order_PUB.Line_Rec_Type;

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Oe_Oe_Form_Line';
7:
8: -- Global variables holding cached record.
9:
10: g_line_rec OE_Order_PUB.Line_Rec_Type;
11: g_db_line_rec OE_Order_PUB.Line_Rec_Type;
12: g_current_header_id NUMBER := 0;
13: --retro{Global variables for caching header_id and currency code
14: g_header_id NUMBER;

Line 11: g_db_line_rec OE_Order_PUB.Line_Rec_Type;

7:
8: -- Global variables holding cached record.
9:
10: g_line_rec OE_Order_PUB.Line_Rec_Type;
11: g_db_line_rec OE_Order_PUB.Line_Rec_Type;
12: g_current_header_id NUMBER := 0;
13: --retro{Global variables for caching header_id and currency code
14: g_header_id NUMBER;
15: g_currency_code VARCHAR2(15);

Line 28: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

24:
25: -- Forward declaration of procedures maintaining entity record cache.
26:
27: PROCEDURE Write_line
28: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
29: , p_db_record IN BOOLEAN := FALSE
30: );
31:
32: -- Bug 1713035

Line 38: , x_line_rec OUT NOCOPY OE_Order_PUB.Line_Rec_Type

34: /*
35: PROCEDURE Get_line
36: ( p_db_record IN BOOLEAN := FALSE
37: , p_line_id IN NUMBER
38: , x_line_rec OUT NOCOPY OE_Order_PUB.Line_Rec_Type
39: );
40: */
41:
42: PROCEDURE Clear_line;

Line 57: g_opr__tbl OE_Order_PUB.Line_Tbl_Type;

53: RETURN VARCHAR2;
54:
55: -- Global variable holding performed operations.
56:
57: g_opr__tbl OE_Order_PUB.Line_Tbl_Type;
58:
59: -- Procedure : Default_Attributes
60: --
61:

Line 67: , x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type

63: ( x_return_status OUT NOCOPY VARCHAR2
64: , x_msg_count OUT NOCOPY NUMBER
65: , x_msg_data OUT NOCOPY VARCHAR2
66: , p_header_id IN NUMBER
67: , x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
68: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
69: , x_line_val_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Tbl_Type
70:
71: )

Line 68: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type

64: , x_msg_count OUT NOCOPY NUMBER
65: , x_msg_data OUT NOCOPY VARCHAR2
66: , p_header_id IN NUMBER
67: , x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
68: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
69: , x_line_val_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Tbl_Type
70:
71: )
72: IS

Line 69: , x_line_val_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Tbl_Type

65: , x_msg_data OUT NOCOPY VARCHAR2
66: , p_header_id IN NUMBER
67: , x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
68: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
69: , x_line_val_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Tbl_Type
70:
71: )
72: IS
73: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 75: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

71: )
72: IS
73: l_control_rec OE_GLOBALS.Control_Rec_Type;
74: l_return_status VARCHAR2(1);
75: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
76: l_error NUMBER := 0;
77: --
78: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
79: --

Line 108: x_old_line_tbl(1) :=OE_ORDER_PUB.G_MISS_LINE_REC;

104: l_control_rec.clear_api_cache := FALSE;
105: l_control_rec.clear_api_requests := FALSE;
106:
107: -- Load IN parameters if any exist
108: x_old_line_tbl(1) :=OE_ORDER_PUB.G_MISS_LINE_REC;
109: x_line_tbl(1) :=OE_ORDER_PUB.G_MISS_LINE_REC;
110: x_line_tbl(1).header_id := p_header_id;
111:
112: -- Defaulting of flex values is currently done by the form.

Line 109: x_line_tbl(1) :=OE_ORDER_PUB.G_MISS_LINE_REC;

105: l_control_rec.clear_api_requests := FALSE;
106:
107: -- Load IN parameters if any exist
108: x_old_line_tbl(1) :=OE_ORDER_PUB.G_MISS_LINE_REC;
109: x_line_tbl(1) :=OE_ORDER_PUB.G_MISS_LINE_REC;
110: x_line_tbl(1).header_id := p_header_id;
111:
112: -- Defaulting of flex values is currently done by the form.
113: -- Set flex attributes to NULL in order to avoid defaulting them.

Line 270: x_line_val_tbl(1):=OE_ORDER_PUB.G_MISS_LINE_VAL_REC;

266: -- l_x_line_rec := x_line_tbl(1);
267:
268:
269: -- Load display OUT parameters if any
270: x_line_val_tbl(1):=OE_ORDER_PUB.G_MISS_LINE_VAL_REC;
271: x_line_val_tbl(1):=OE_Line_Util.Get_Values
272: ( p_line_rec => x_line_tbl(1)
273: );
274: -- Write to cache.

Line 361: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

357: ( p_attr_id IN NUMBER
358: , p_attr_value IN VARCHAR2
359: , p_line_dff_rec IN OE_OE_FORM_LINE.line_dff_rec_type
360: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-YYYY HH24:MI:SS'
361: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
362: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
363: )
364: IS
365: l_date_format_mask VARCHAR2(30) := p_date_format_mask;

Line 362: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type

358: , p_attr_value IN VARCHAR2
359: , p_line_dff_rec IN OE_OE_FORM_LINE.line_dff_rec_type
360: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-YYYY HH24:MI:SS'
361: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
362: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
363: )
364: IS
365: l_date_format_mask VARCHAR2(30) := p_date_format_mask;
366: --

Line 1136: , p_default_cache_line_rec IN OE_ORDER_PUB.Line_Rec_Type

1132: , p_attr_value_tbl IN Varchar2_Tbl_Type
1133: , p_reason IN VARCHAR2
1134: , p_comments IN VARCHAR2
1135: , p_line_dff_rec IN OE_OE_FORM_LINE.line_dff_rec_type
1136: , p_default_cache_line_rec IN OE_ORDER_PUB.Line_Rec_Type
1137: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-YYYY HH24:MI:SS'
1138: , x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1139: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1140: , x_line_val_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Tbl_Type

Line 1138: , x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type

1134: , p_comments IN VARCHAR2
1135: , p_line_dff_rec IN OE_OE_FORM_LINE.line_dff_rec_type
1136: , p_default_cache_line_rec IN OE_ORDER_PUB.Line_Rec_Type
1137: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-YYYY HH24:MI:SS'
1138: , x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1139: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1140: , x_line_val_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Tbl_Type
1141: --, x_dualum_ind OUT NOCOPY NUMBER --OPM 02/JUN/00 INVCONV
1142: --, x_grade_ctl OUT NOCOPY NUMBER --OPM 02/JUN/00 INVCONV

Line 1139: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type

1135: , p_line_dff_rec IN OE_OE_FORM_LINE.line_dff_rec_type
1136: , p_default_cache_line_rec IN OE_ORDER_PUB.Line_Rec_Type
1137: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-YYYY HH24:MI:SS'
1138: , x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1139: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1140: , x_line_val_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Tbl_Type
1141: --, x_dualum_ind OUT NOCOPY NUMBER --OPM 02/JUN/00 INVCONV
1142: --, x_grade_ctl OUT NOCOPY NUMBER --OPM 02/JUN/00 INVCONV
1143: , x_process_warehouse_flag OUT NOCOPY VARCHAR2 --OPM 02/JUN/00

Line 1140: , x_line_val_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Tbl_Type

1136: , p_default_cache_line_rec IN OE_ORDER_PUB.Line_Rec_Type
1137: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-YYYY HH24:MI:SS'
1138: , x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1139: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1140: , x_line_val_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Tbl_Type
1141: --, x_dualum_ind OUT NOCOPY NUMBER --OPM 02/JUN/00 INVCONV
1142: --, x_grade_ctl OUT NOCOPY NUMBER --OPM 02/JUN/00 INVCONV
1143: , x_process_warehouse_flag OUT NOCOPY VARCHAR2 --OPM 02/JUN/00
1144: --, x_ont_pricing_qty_source OUT NOCOPY NUMBER --OPM 2046190

Line 1203: --x_old_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;

1199: END IF;
1200:
1201:
1202: IF p_default_cache_line_rec.line_id IS NOT NULL THEN
1203: --x_old_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;
1204: x_old_line_tbl(1).line_id := null;
1205: x_line_tbl(1):=p_default_cache_line_rec;
1206: l_control_rec.default_attributes := FALSE;
1207: l_control_rec.clear_dependents := FALSE;

Line 2262: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

2258: , p_change_comments IN VARCHAR2
2259: , x_line_val_rec OUT NOCOPY validate_write_rec_type
2260: )
2261: IS
2262: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2263: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2264: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2265: l_control_rec OE_GLOBALS.Control_Rec_Type;
2266: l_return_status VARCHAR2(1);

Line 2263: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

2259: , x_line_val_rec OUT NOCOPY validate_write_rec_type
2260: )
2261: IS
2262: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2263: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2264: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2265: l_control_rec OE_GLOBALS.Control_Rec_Type;
2266: l_return_status VARCHAR2(1);
2267: l_charge_amount NUMBER := 0.0;

Line 2264: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

2260: )
2261: IS
2262: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2263: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2264: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2265: l_control_rec OE_GLOBALS.Control_Rec_Type;
2266: l_return_status VARCHAR2(1);
2267: l_charge_amount NUMBER := 0.0;
2268: l_last_index NUMBER;

Line 2756: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

2752: , p_change_reason_code IN VARCHAR2 Default Null
2753: , p_change_comments IN VARCHAR2 Default Null
2754: )
2755: IS
2756: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2757: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2758: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2759: l_control_rec OE_GLOBALS.Control_Rec_Type;
2760: l_return_status VARCHAR2(1);

Line 2757: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

2753: , p_change_comments IN VARCHAR2 Default Null
2754: )
2755: IS
2756: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2757: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2758: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2759: l_control_rec OE_GLOBALS.Control_Rec_Type;
2760: l_return_status VARCHAR2(1);
2761: --

Line 2758: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

2754: )
2755: IS
2756: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2757: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2758: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2759: l_control_rec OE_GLOBALS.Control_Rec_Type;
2760: l_return_status VARCHAR2(1);
2761: --
2762: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2912: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

2908: )
2909: IS
2910: l_control_rec OE_GLOBALS.Control_Rec_Type;
2911: l_return_status VARCHAR2(1);
2912: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2913: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2914: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2915: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2916: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 2913: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

2909: IS
2910: l_control_rec OE_GLOBALS.Control_Rec_Type;
2911: l_return_status VARCHAR2(1);
2912: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2913: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2914: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2915: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2916: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2917: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

Line 2914: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2910: l_control_rec OE_GLOBALS.Control_Rec_Type;
2911: l_return_status VARCHAR2(1);
2912: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2913: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2914: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2915: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2916: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2917: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2918: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 2915: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

2911: l_return_status VARCHAR2(1);
2912: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2913: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2914: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2915: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2916: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2917: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2918: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2919: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 2916: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2912: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2913: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2914: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2915: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2916: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2917: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2918: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2919: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2920: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 2917: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

2913: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2914: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2915: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2916: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2917: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2918: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2919: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2920: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2921: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

Line 2918: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

2914: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2915: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2916: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2917: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2918: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2919: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2920: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2921: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2922: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 2919: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

2915: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2916: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2917: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2918: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2919: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2920: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2921: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2922: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2923: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;

Line 2920: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

2916: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2917: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2918: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2919: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2920: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2921: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2922: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2923: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2924: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 2921: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

2917: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2918: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2919: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2920: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2921: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2922: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2923: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2924: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2925: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 2922: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

2918: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2919: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2920: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2921: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2922: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2923: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2924: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2925: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2926: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 2923: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;

2919: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2920: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2921: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2922: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2923: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2924: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2925: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2926: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2927: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 2924: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

2920: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2921: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2922: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2923: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2924: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2925: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2926: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2927: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2928: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 2925: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

2921: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2922: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2923: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2924: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2925: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2926: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2927: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2928: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2929: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 2926: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

2922: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2923: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2924: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2925: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2926: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2927: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2928: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2929: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2930: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 2927: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

2923: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2924: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2925: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2926: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2927: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2928: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2929: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2930: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2931: --serla begin

Line 2928: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

2924: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2925: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2926: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2927: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2928: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2929: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2930: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2931: --serla begin
2932: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

Line 2929: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

2925: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2926: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2927: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2928: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2929: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2930: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2931: --serla begin
2932: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2933: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

Line 2930: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

2926: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2927: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2928: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2929: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2930: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2931: --serla begin
2932: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2933: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2934: --serla end

Line 2932: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

2928: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2929: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2930: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2931: --serla begin
2932: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2933: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2934: --serla end
2935: --
2936: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2933: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

2929: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2930: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2931: --serla begin
2932: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2933: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2934: --serla end
2935: --
2936: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2937: --

Line 3084: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

3080: )
3081:
3082: IS
3083: l_return_status VARCHAR2(1);
3084: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3085: --
3086: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3087: --
3088: BEGIN

Line 3199: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

3195:
3196: -- Procedures maintaining line record cache.
3197:
3198: PROCEDURE Write_line
3199: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
3200: , p_db_record IN BOOLEAN := FALSE
3201: )
3202: IS
3203: --

Line 3228: , x_line_rec OUT NOCOPY OE_Order_PUB.Line_Rec_Type

3224:
3225: PROCEDURE Get_line
3226: ( p_db_record IN BOOLEAN := FALSE
3227: , p_line_id IN NUMBER
3228: , x_line_rec OUT NOCOPY OE_Order_PUB.Line_Rec_Type
3229: )
3230: IS
3231: --
3232: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3270: g_db_line_rec := OE_Order_PUB.G_MISS_LINE_REC;

3266:
3267: IF p_db_record THEN
3268: --Added for bug3911285
3269: IF p_line_id <> g_db_line_rec.line_id THEN
3270: g_db_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
3271: END IF;
3272: --End of bug3911285
3273:
3274: x_line_rec:= g_db_line_rec;

Line 3295: g_line_rec := OE_Order_PUB.G_MISS_LINE_REC;

3291: IF l_debug_level > 0 THEN
3292: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.CLEAR_LINE' , 1 ) ;
3293: END IF;
3294:
3295: g_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
3296: g_db_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
3297:
3298: IF l_debug_level > 0 THEN
3299: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.CLEAR_LINE' , 1 ) ;

Line 3296: g_db_line_rec := OE_Order_PUB.G_MISS_LINE_REC;

3292: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.CLEAR_LINE' , 1 ) ;
3293: END IF;
3294:
3295: g_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
3296: g_db_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
3297:
3298: IF l_debug_level > 0 THEN
3299: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.CLEAR_LINE' , 1 ) ;
3300: END IF;

Line 5481: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

5477: ,x_msg_data OUT NOCOPY VARCHAR2
5478: ) IS
5479:
5480: i NUMBER;
5481: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5482: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5483: l_line_rec OE_Order_PUB.Line_Rec_Type;
5484: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5485: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 5482: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

5478: ) IS
5479:
5480: i NUMBER;
5481: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5482: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5483: l_line_rec OE_Order_PUB.Line_Rec_Type;
5484: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5485: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5486: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 5483: l_line_rec OE_Order_PUB.Line_Rec_Type;

5479:
5480: i NUMBER;
5481: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5482: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5483: l_line_rec OE_Order_PUB.Line_Rec_Type;
5484: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5485: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5486: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5487: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 5484: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

5480: i NUMBER;
5481: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5482: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5483: l_line_rec OE_Order_PUB.Line_Rec_Type;
5484: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5485: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5486: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5487: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5488: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 5485: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

5481: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5482: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5483: l_line_rec OE_Order_PUB.Line_Rec_Type;
5484: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5485: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5486: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5487: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5488: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5489: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;

Line 5486: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

5482: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5483: l_line_rec OE_Order_PUB.Line_Rec_Type;
5484: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5485: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5486: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5487: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5488: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5489: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
5490: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 5487: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

5483: l_line_rec OE_Order_PUB.Line_Rec_Type;
5484: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5485: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5486: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5487: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5488: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5489: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
5490: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
5491: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 5488: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

5484: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5485: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5486: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5487: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5488: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5489: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
5490: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
5491: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
5492: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 5489: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;

5485: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5486: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5487: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5488: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5489: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
5490: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
5491: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
5492: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
5493: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 5490: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

5486: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5487: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5488: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5489: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
5490: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
5491: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
5492: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
5493: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
5494: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 5491: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

5487: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5488: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5489: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
5490: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
5491: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
5492: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
5493: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
5494: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
5495: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 5492: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

5488: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5489: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
5490: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
5491: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
5492: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
5493: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
5494: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
5495: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
5496: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 5493: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

5489: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
5490: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
5491: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
5492: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
5493: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
5494: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
5495: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
5496: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
5497: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 5494: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

5490: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
5491: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
5492: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
5493: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
5494: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
5495: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
5496: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
5497: l_control_rec OE_GLOBALS.Control_Rec_Type;
5498: l_return_status VARCHAR2(1);

Line 5495: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

5491: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
5492: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
5493: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
5494: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
5495: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
5496: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
5497: l_control_rec OE_GLOBALS.Control_Rec_Type;
5498: l_return_status VARCHAR2(1);
5499: l_line_id NUMBER;

Line 5496: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

5492: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
5493: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
5494: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
5495: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
5496: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
5497: l_control_rec OE_GLOBALS.Control_Rec_Type;
5498: l_return_status VARCHAR2(1);
5499: l_line_id NUMBER;
5500: l_process_add_attributes Boolean :=FALSE;

Line 5505: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

5501: j NUMBER; -- for bug 1988144
5502: k NUMBER; -- for bug 1988144
5503: l_rec_count NUMBER; -- for bug 1988144
5504: --serla begin
5505: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
5506: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
5507: --serla end
5508: --
5509: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 5506: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

5502: k NUMBER; -- for bug 1988144
5503: l_rec_count NUMBER; -- for bug 1988144
5504: --serla begin
5505: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
5506: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
5507: --serla end
5508: --
5509: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5510: --

Line 5538: -- l_x_line_tbl(i):=OE_ORDER_PUB.G_MISS_LINE_REC;

5534: l_line_id:=x_line_tbl_type(i).line_id;
5535: IF l_debug_level > 0 THEN
5536: oe_debug_pub.add( 'LINE CONTROLLER - BEFORE GET LINE'|| X_LINE_TBL_TYPE ( I ) .LINE_ID , 1 ) ;
5537: END IF;
5538: -- l_x_line_tbl(i):=OE_ORDER_PUB.G_MISS_LINE_REC;
5539: /* Get_line
5540: ( p_db_record => FALSE
5541: ,p_line_id => x_line_tbl_type(i).line_id
5542: ,x_line_rec => l_x_line_tbl(i)); */

Line 5642: l_line_tbl(i):=OE_ORDER_PUB.G_MISS_LINE_REC;

5638:
5639: IF l_x_line_tbl.count>0 THEN
5640: l_line_tbl.delete;
5641: FOR i in x_line_tbl_type.first .. x_line_tbl_type.last LOOP
5642: l_line_tbl(i):=OE_ORDER_PUB.G_MISS_LINE_REC;
5643: IF x_line_tbl_type(i).ship_to_org_id is not null THEN
5644: IF nvl(l_x_line_tbl(i).ship_to_org_id,-1)<>nvl(x_line_tbl_type(i).ship_to_org_id,-1) THEN
5645: l_line_tbl(i).ship_to_org_id:=x_line_tbl_type(i).ship_to_org_id;
5646: l_process_add_attributes:=TRUE;

Line 5710: l_line_tbl(l_rec_count) := OE_ORDER_PUB.G_MISS_LINE_REC;

5706:
5707: FOR i in l_x_line_tbl.first .. l_x_line_tbl.last LOOP
5708: IF l_x_line_tbl(i).item_type_code = 'SERVICE' THEN
5709:
5710: l_line_tbl(l_rec_count) := OE_ORDER_PUB.G_MISS_LINE_REC;
5711:
5712: FOR j in l_x_line_tbl.first .. l_x_line_tbl.last LOOP
5713: IF l_x_line_tbl(i).service_reference_line_id = l_x_line_tbl(j).line_id THEN
5714: l_line_id := nvl( l_x_line_tbl(j).top_model_line_id, l_x_line_tbl(j).line_id );

Line 5889: /* l_new_line_rec OE_Order_PUB.Line_Rec_Type; --3445778

5885: l_count_to_keep NUMBER;
5886: --
5887: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5888: --
5889: /* l_new_line_rec OE_Order_PUB.Line_Rec_Type; --3445778
5890: l_old_line_rec OE_Order_PUB.Line_Rec_Type; --3445778
5891: l_index NUMBER; --3445778 */
5892: l_header_id NUMBER;
5893: BEGIN

Line 5890: l_old_line_rec OE_Order_PUB.Line_Rec_Type; --3445778

5886: --
5887: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5888: --
5889: /* l_new_line_rec OE_Order_PUB.Line_Rec_Type; --3445778
5890: l_old_line_rec OE_Order_PUB.Line_Rec_Type; --3445778
5891: l_index NUMBER; --3445778 */
5892: l_header_id NUMBER;
5893: BEGIN
5894: OE_MSG_PUB.initialize;