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 64: g_opr__tbl OE_Order_PUB.Line_Tbl_Type;

60: RETURN VARCHAR2;
61:
62: -- Global variable holding performed operations.
63:
64: g_opr__tbl OE_Order_PUB.Line_Tbl_Type;
65:
66: -- Procedure : Default_Attributes
67: --
68:

Line 74: , x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type

70: ( x_return_status OUT NOCOPY VARCHAR2
71: , x_msg_count OUT NOCOPY NUMBER
72: , x_msg_data OUT NOCOPY VARCHAR2
73: , p_header_id IN NUMBER
74: , x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
75: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
76: , x_line_val_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Tbl_Type
77:
78: )

Line 75: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type

71: , x_msg_count OUT NOCOPY NUMBER
72: , x_msg_data OUT NOCOPY VARCHAR2
73: , p_header_id IN NUMBER
74: , x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
75: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
76: , x_line_val_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Tbl_Type
77:
78: )
79: IS

Line 76: , x_line_val_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Tbl_Type

72: , x_msg_data OUT NOCOPY VARCHAR2
73: , p_header_id IN NUMBER
74: , x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
75: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
76: , x_line_val_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Tbl_Type
77:
78: )
79: IS
80: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 82: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

78: )
79: IS
80: l_control_rec OE_GLOBALS.Control_Rec_Type;
81: l_return_status VARCHAR2(1);
82: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
83: l_error NUMBER := 0;
84: --
85: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
86: --

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

111: l_control_rec.clear_api_cache := FALSE;
112: l_control_rec.clear_api_requests := FALSE;
113:
114: -- Load IN parameters if any exist
115: x_old_line_tbl(1) :=OE_ORDER_PUB.G_MISS_LINE_REC;
116: x_line_tbl(1) :=OE_ORDER_PUB.G_MISS_LINE_REC;
117: x_line_tbl(1).header_id := p_header_id;
118:
119: -- Defaulting of flex values is currently done by the form.

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

112: l_control_rec.clear_api_requests := FALSE;
113:
114: -- Load IN parameters if any exist
115: x_old_line_tbl(1) :=OE_ORDER_PUB.G_MISS_LINE_REC;
116: x_line_tbl(1) :=OE_ORDER_PUB.G_MISS_LINE_REC;
117: x_line_tbl(1).header_id := p_header_id;
118:
119: -- Defaulting of flex values is currently done by the form.
120: -- Set flex attributes to NULL in order to avoid defaulting them.

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

273: -- l_x_line_rec := x_line_tbl(1);
274:
275:
276: -- Load display OUT parameters if any
277: x_line_val_tbl(1):=OE_ORDER_PUB.G_MISS_LINE_VAL_REC;
278: x_line_val_tbl(1):=OE_Line_Util.Get_Values
279: ( p_line_rec => x_line_tbl(1)
280: );
281: -- Write to cache.

Line 368: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

364: ( p_attr_id IN NUMBER
365: , p_attr_value IN VARCHAR2
366: , p_line_dff_rec IN OE_OE_FORM_LINE.line_dff_rec_type
367: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-YYYY HH24:MI:SS'
368: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
369: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
370: )
371: IS
372: l_date_format_mask VARCHAR2(30) := p_date_format_mask;

Line 369: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type

365: , p_attr_value IN VARCHAR2
366: , p_line_dff_rec IN OE_OE_FORM_LINE.line_dff_rec_type
367: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-YYYY HH24:MI:SS'
368: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
369: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
370: )
371: IS
372: l_date_format_mask VARCHAR2(30) := p_date_format_mask;
373: --

Line 1155: , p_default_cache_line_rec IN OE_ORDER_PUB.Line_Rec_Type

1151: , p_attr_value_tbl IN Varchar2_Tbl_Type
1152: , p_reason IN VARCHAR2
1153: , p_comments IN VARCHAR2
1154: , p_line_dff_rec IN OE_OE_FORM_LINE.line_dff_rec_type
1155: , p_default_cache_line_rec IN OE_ORDER_PUB.Line_Rec_Type
1156: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-YYYY HH24:MI:SS'
1157: , x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1158: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1159: , x_line_val_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Tbl_Type

Line 1157: , x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type

1153: , p_comments IN VARCHAR2
1154: , p_line_dff_rec IN OE_OE_FORM_LINE.line_dff_rec_type
1155: , p_default_cache_line_rec IN OE_ORDER_PUB.Line_Rec_Type
1156: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-YYYY HH24:MI:SS'
1157: , x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1158: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1159: , x_line_val_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Tbl_Type
1160: --, x_dualum_ind OUT NOCOPY NUMBER --OPM 02/JUN/00 INVCONV
1161: --, x_grade_ctl OUT NOCOPY NUMBER --OPM 02/JUN/00 INVCONV

Line 1158: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type

1154: , p_line_dff_rec IN OE_OE_FORM_LINE.line_dff_rec_type
1155: , p_default_cache_line_rec IN OE_ORDER_PUB.Line_Rec_Type
1156: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-YYYY HH24:MI:SS'
1157: , x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1158: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1159: , x_line_val_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Tbl_Type
1160: --, x_dualum_ind OUT NOCOPY NUMBER --OPM 02/JUN/00 INVCONV
1161: --, x_grade_ctl OUT NOCOPY NUMBER --OPM 02/JUN/00 INVCONV
1162: , x_process_warehouse_flag OUT NOCOPY VARCHAR2 --OPM 02/JUN/00

Line 1159: , x_line_val_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Tbl_Type

1155: , p_default_cache_line_rec IN OE_ORDER_PUB.Line_Rec_Type
1156: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-YYYY HH24:MI:SS'
1157: , x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1158: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1159: , x_line_val_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Tbl_Type
1160: --, x_dualum_ind OUT NOCOPY NUMBER --OPM 02/JUN/00 INVCONV
1161: --, x_grade_ctl OUT NOCOPY NUMBER --OPM 02/JUN/00 INVCONV
1162: , x_process_warehouse_flag OUT NOCOPY VARCHAR2 --OPM 02/JUN/00
1163: --, x_ont_pricing_qty_source OUT NOCOPY NUMBER --OPM 2046190

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

1223: END IF;
1224:
1225:
1226: IF p_default_cache_line_rec.line_id IS NOT NULL THEN
1227: --x_old_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;
1228: x_old_line_tbl(1).line_id := null;
1229: x_line_tbl(1):=p_default_cache_line_rec;
1230: l_control_rec.default_attributes := FALSE;
1231: l_control_rec.clear_dependents := FALSE;

Line 2322: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

2318: , p_change_comments IN VARCHAR2
2319: , x_line_val_rec OUT NOCOPY validate_write_rec_type
2320: )
2321: IS
2322: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2323: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2324: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2325: l_control_rec OE_GLOBALS.Control_Rec_Type;
2326: l_return_status VARCHAR2(1);

Line 2323: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

2319: , x_line_val_rec OUT NOCOPY validate_write_rec_type
2320: )
2321: IS
2322: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2323: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2324: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2325: l_control_rec OE_GLOBALS.Control_Rec_Type;
2326: l_return_status VARCHAR2(1);
2327: l_charge_amount NUMBER := 0.0;

Line 2324: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

2320: )
2321: IS
2322: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2323: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2324: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2325: l_control_rec OE_GLOBALS.Control_Rec_Type;
2326: l_return_status VARCHAR2(1);
2327: l_charge_amount NUMBER := 0.0;
2328: l_last_index NUMBER;

Line 2820: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

2816: , p_change_reason_code IN VARCHAR2 Default Null
2817: , p_change_comments IN VARCHAR2 Default Null
2818: )
2819: IS
2820: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2821: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2822: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2823: l_control_rec OE_GLOBALS.Control_Rec_Type;
2824: l_return_status VARCHAR2(1);

Line 2821: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

2817: , p_change_comments IN VARCHAR2 Default Null
2818: )
2819: IS
2820: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2821: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2822: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2823: l_control_rec OE_GLOBALS.Control_Rec_Type;
2824: l_return_status VARCHAR2(1);
2825: --

Line 2822: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

2818: )
2819: IS
2820: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2821: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2822: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2823: l_control_rec OE_GLOBALS.Control_Rec_Type;
2824: l_return_status VARCHAR2(1);
2825: --
2826: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2976: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

2972: )
2973: IS
2974: l_control_rec OE_GLOBALS.Control_Rec_Type;
2975: l_return_status VARCHAR2(1);
2976: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2977: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2978: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2979: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2980: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 2977: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

2973: IS
2974: l_control_rec OE_GLOBALS.Control_Rec_Type;
2975: l_return_status VARCHAR2(1);
2976: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2977: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2978: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2979: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2980: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2981: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

Line 2978: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2974: l_control_rec OE_GLOBALS.Control_Rec_Type;
2975: l_return_status VARCHAR2(1);
2976: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2977: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2978: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2979: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2980: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2981: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2982: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 2979: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

2975: l_return_status VARCHAR2(1);
2976: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2977: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2978: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2979: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2980: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2981: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2982: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2983: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 2980: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2976: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2977: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2978: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2979: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2980: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2981: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2982: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2983: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2984: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 2981: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

2977: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2978: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2979: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2980: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2981: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2982: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2983: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2984: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2985: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

Line 2982: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

2978: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2979: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2980: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2981: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2982: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2983: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2984: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2985: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2986: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 2983: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

2979: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2980: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2981: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2982: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2983: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2984: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2985: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2986: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2987: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;

Line 2984: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

2980: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2981: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2982: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2983: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2984: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2985: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2986: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2987: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2988: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 2985: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

2981: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2982: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2983: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2984: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2985: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2986: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2987: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2988: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2989: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 2986: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

2982: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2983: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2984: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2985: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2986: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2987: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2988: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2989: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2990: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 2987: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;

2983: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2984: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2985: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2986: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2987: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2988: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2989: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2990: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2991: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 2988: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

2984: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2985: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2986: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2987: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2988: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2989: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2990: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2991: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2992: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 2989: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

2985: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2986: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2987: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2988: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2989: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2990: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2991: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2992: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2993: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 2990: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

2986: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2987: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2988: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2989: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2990: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2991: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2992: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2993: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2994: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 2991: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

2987: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2988: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2989: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2990: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2991: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2992: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2993: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2994: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2995: --serla begin

Line 2992: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

2988: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2989: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2990: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2991: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2992: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2993: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2994: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2995: --serla begin
2996: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

Line 2993: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

2989: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2990: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2991: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2992: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2993: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2994: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2995: --serla begin
2996: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2997: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

Line 2994: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

2990: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2991: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2992: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2993: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2994: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2995: --serla begin
2996: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2997: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2998: --serla end

Line 2996: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

2992: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2993: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2994: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2995: --serla begin
2996: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2997: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2998: --serla end
2999: --
3000: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2997: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

2993: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2994: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2995: --serla begin
2996: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2997: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2998: --serla end
2999: --
3000: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3001: --

Line 3148: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

3144: )
3145:
3146: IS
3147: l_return_status VARCHAR2(1);
3148: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3149: --
3150: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3151: --
3152: BEGIN

Line 3263: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

3259:
3260: -- Procedures maintaining line record cache.
3261:
3262: PROCEDURE Write_line
3263: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
3264: , p_db_record IN BOOLEAN := FALSE
3265: )
3266: IS
3267: --

Line 3292: , x_line_rec OUT NOCOPY OE_Order_PUB.Line_Rec_Type

3288:
3289: PROCEDURE Get_line
3290: ( p_db_record IN BOOLEAN := FALSE
3291: , p_line_id IN NUMBER
3292: , x_line_rec OUT NOCOPY OE_Order_PUB.Line_Rec_Type
3293: )
3294: IS
3295: --
3296: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3334: g_db_line_rec := OE_Order_PUB.G_MISS_LINE_REC;

3330:
3331: IF p_db_record THEN
3332: --Added for bug3911285
3333: IF p_line_id <> g_db_line_rec.line_id THEN
3334: g_db_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
3335: END IF;
3336: --End of bug3911285
3337:
3338: x_line_rec:= g_db_line_rec;

Line 3359: g_line_rec := OE_Order_PUB.G_MISS_LINE_REC;

3355: IF l_debug_level > 0 THEN
3356: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.CLEAR_LINE' , 1 ) ;
3357: END IF;
3358:
3359: g_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
3360: g_db_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
3361:
3362: IF l_debug_level > 0 THEN
3363: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.CLEAR_LINE' , 1 ) ;

Line 3360: g_db_line_rec := OE_Order_PUB.G_MISS_LINE_REC;

3356: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.CLEAR_LINE' , 1 ) ;
3357: END IF;
3358:
3359: g_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
3360: g_db_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
3361:
3362: IF l_debug_level > 0 THEN
3363: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.CLEAR_LINE' , 1 ) ;
3364: END IF;

Line 5769: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

5765: ,x_msg_data OUT NOCOPY VARCHAR2
5766: ) IS
5767:
5768: i NUMBER;
5769: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5770: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5771: l_line_rec OE_Order_PUB.Line_Rec_Type;
5772: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5773: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 5770: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

5766: ) IS
5767:
5768: i NUMBER;
5769: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5770: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5771: l_line_rec OE_Order_PUB.Line_Rec_Type;
5772: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5773: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5774: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 5771: l_line_rec OE_Order_PUB.Line_Rec_Type;

5767:
5768: i NUMBER;
5769: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5770: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5771: l_line_rec OE_Order_PUB.Line_Rec_Type;
5772: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5773: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5774: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5775: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 5772: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

5768: i NUMBER;
5769: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5770: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5771: l_line_rec OE_Order_PUB.Line_Rec_Type;
5772: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5773: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5774: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5775: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5776: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 5773: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

5769: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5770: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5771: l_line_rec OE_Order_PUB.Line_Rec_Type;
5772: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5773: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5774: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5775: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5776: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5777: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;

Line 5774: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

5770: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5771: l_line_rec OE_Order_PUB.Line_Rec_Type;
5772: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5773: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5774: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5775: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5776: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5777: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
5778: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 5775: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

5771: l_line_rec OE_Order_PUB.Line_Rec_Type;
5772: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5773: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5774: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5775: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5776: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5777: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
5778: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
5779: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 5776: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

5772: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5773: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5774: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5775: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5776: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5777: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
5778: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
5779: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
5780: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 5777: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;

5773: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5774: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5775: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5776: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5777: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
5778: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
5779: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
5780: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
5781: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 5778: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

5774: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5775: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5776: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5777: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
5778: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
5779: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
5780: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
5781: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
5782: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 5779: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

5775: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5776: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5777: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
5778: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
5779: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
5780: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
5781: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
5782: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
5783: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 5780: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

5776: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5777: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
5778: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
5779: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
5780: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
5781: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
5782: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
5783: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
5784: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 5781: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

5777: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
5778: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
5779: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
5780: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
5781: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
5782: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
5783: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
5784: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
5785: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 5782: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

5778: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
5779: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
5780: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
5781: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
5782: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
5783: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
5784: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
5785: l_control_rec OE_GLOBALS.Control_Rec_Type;
5786: l_return_status VARCHAR2(1);

Line 5783: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

5779: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
5780: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
5781: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
5782: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
5783: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
5784: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
5785: l_control_rec OE_GLOBALS.Control_Rec_Type;
5786: l_return_status VARCHAR2(1);
5787: l_line_id NUMBER;

Line 5784: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

5780: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
5781: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
5782: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
5783: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
5784: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
5785: l_control_rec OE_GLOBALS.Control_Rec_Type;
5786: l_return_status VARCHAR2(1);
5787: l_line_id NUMBER;
5788: l_process_add_attributes Boolean :=FALSE;

Line 5793: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

5789: j NUMBER; -- for bug 1988144
5790: k NUMBER; -- for bug 1988144
5791: l_rec_count NUMBER; -- for bug 1988144
5792: --serla begin
5793: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
5794: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
5795: --serla end
5796: --10278858
5797: l_org_request_date DATE;

Line 5794: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

5790: k NUMBER; -- for bug 1988144
5791: l_rec_count NUMBER; -- for bug 1988144
5792: --serla begin
5793: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
5794: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
5795: --serla end
5796: --10278858
5797: l_org_request_date DATE;
5798: l_org_ship_from_org_id NUMBER;

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

5830: l_line_id:=x_line_tbl_type(i).line_id;
5831: IF l_debug_level > 0 THEN
5832: oe_debug_pub.add( 'LINE CONTROLLER - BEFORE GET LINE'|| X_LINE_TBL_TYPE ( I ) .LINE_ID , 1 ) ;
5833: END IF;
5834: -- l_x_line_tbl(i):=OE_ORDER_PUB.G_MISS_LINE_REC;
5835: /* Get_line
5836: ( p_db_record => FALSE
5837: ,p_line_id => x_line_tbl_type(i).line_id
5838: ,x_line_rec => l_x_line_tbl(i)); */

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

5975: IF l_x_line_tbl.count>0 THEN
5976: l_line_tbl.delete;
5977: /* -- 8706868: No need to call again. First call has updated this.
5978: FOR i in x_line_tbl_type.first .. x_line_tbl_type.last LOOP
5979: l_line_tbl(i):=OE_ORDER_PUB.G_MISS_LINE_REC;
5980: IF x_line_tbl_type(i).ship_to_org_id is not null THEN
5981: IF nvl(l_x_line_tbl(i).ship_to_org_id,-1)<>nvl(x_line_tbl_type(i).ship_to_org_id,-1) THEN
5982: l_line_tbl(i).ship_to_org_id:=x_line_tbl_type(i).ship_to_org_id;
5983: l_process_add_attributes:=TRUE;

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

6044: l_rec_count := 1; --8706868
6045: FOR i in l_x_line_tbl.first .. l_x_line_tbl.last LOOP
6046: IF l_x_line_tbl(i).item_type_code = 'SERVICE' THEN
6047:
6048: l_line_tbl(l_rec_count) := OE_ORDER_PUB.G_MISS_LINE_REC;
6049:
6050: FOR j in l_x_line_tbl.first .. l_x_line_tbl.last LOOP
6051: IF l_x_line_tbl(i).service_reference_line_id = l_x_line_tbl(j).line_id THEN
6052: l_line_id := nvl( l_x_line_tbl(j).top_model_line_id, l_x_line_tbl(j).line_id );

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

6233: l_count_to_keep NUMBER;
6234: --
6235: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6236: --
6237: /* l_new_line_rec OE_Order_PUB.Line_Rec_Type; --3445778
6238: l_old_line_rec OE_Order_PUB.Line_Rec_Type; --3445778
6239: l_index NUMBER; --3445778 */
6240: l_header_id NUMBER;
6241: BEGIN

Line 6238: l_old_line_rec OE_Order_PUB.Line_Rec_Type; --3445778

6234: --
6235: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6236: --
6237: /* l_new_line_rec OE_Order_PUB.Line_Rec_Type; --3445778
6238: l_old_line_rec OE_Order_PUB.Line_Rec_Type; --3445778
6239: l_index NUMBER; --3445778 */
6240: l_header_id NUMBER;
6241: BEGIN
6242: OE_MSG_PUB.initialize;