DBA Data[Home] [Help]

APPS.OE_OE_FORM_LINE_ADJ dependencies on OE_ORDER_ADJ_PVT

Line 31: x_line_id_tbl out nocopy Oe_Order_Adj_Pvt.Index_Tbl_Type);

27:
28: Procedure Get_Option_Service_Lines(p_top_model_line_id In Number,
29: p_service_line_id In Number Default null,
30: p_mode In VARCHAR2 Default 'SERVICE',
31: x_line_id_tbl out nocopy Oe_Order_Adj_Pvt.Index_Tbl_Type);
32:
33:
34: Procedure Process_Adj(p_parent_adj_rec In Oe_Order_Pub.Line_Adj_Rec_Type,
35: p_line_id_tbl In Oe_Order_Adj_Pvt.Index_Tbl_Type,

Line 35: p_line_id_tbl In Oe_Order_Adj_Pvt.Index_Tbl_Type,

31: x_line_id_tbl out nocopy Oe_Order_Adj_Pvt.Index_Tbl_Type);
32:
33:
34: Procedure Process_Adj(p_parent_adj_rec In Oe_Order_Pub.Line_Adj_Rec_Type,
35: p_line_id_tbl In Oe_Order_Adj_Pvt.Index_Tbl_Type,
36: p_delete_flag In Varchar2 default 'N',
37: p_create_adj_no_validate In Boolean Default FALSE);
38:
39: PROCEDURE Clear_Line_Adj;

Line 334: -- Call Oe_Order_Adj_Pvt.Line_Adj

330: -- Populate Line_Adj table
331: l_x_Line_Adj_tbl(1) := l_x_Line_Adj_rec;
332: l_x_old_Line_Adj_tbl(1) := l_x_old_Line_Adj_rec;
333:
334: -- Call Oe_Order_Adj_Pvt.Line_Adj
335: oe_order_adj_pvt.Line_Adjs
336: ( p_init_msg_list => FND_API.G_TRUE
337: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
338: , p_control_rec => l_control_rec

Line 335: oe_order_adj_pvt.Line_Adjs

331: l_x_Line_Adj_tbl(1) := l_x_Line_Adj_rec;
332: l_x_old_Line_Adj_tbl(1) := l_x_old_Line_Adj_rec;
333:
334: -- Call Oe_Order_Adj_Pvt.Line_Adj
335: oe_order_adj_pvt.Line_Adjs
336: ( p_init_msg_list => FND_API.G_TRUE
337: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
338: , p_control_rec => l_control_rec
339: , p_x_line_adj_tbl => l_x_Line_Adj_tbl

Line 795: l_line_id_tbl OE_Order_Adj_Pvt.Index_Tbl_Type;

791: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
792:
793: --1790502
794: l_line_rec OE_Order_Pub.Line_Rec_Type;
795: l_line_id_tbl OE_Order_Adj_Pvt.Index_Tbl_Type;
796: l_top_model_line_id Number;
797:
798: l_profile_cascade_adjustments Varchar2(1):= NVL(FND_PROFILE.VALUE('ONT_CASCADE_ADJUSTMENTS'),'N');
799: l_orcl_customization Varchar2(1):= NVL(FND_PROFILE.VALUE('ONT_ACTIVATE_ORACLE_CUSTOMIZATION'),'N');

Line 1247: -- Call Oe_Order_Adj_Pvt.Line_Adj

1243: -- Populate Line_Adj table
1244: l_x_Line_Adj_tbl(1) := l_x_Line_Adj_rec;
1245: l_x_old_Line_Adj_tbl(1) := l_x_old_Line_Adj_rec;
1246:
1247: -- Call Oe_Order_Adj_Pvt.Line_Adj
1248: l_Line_Adj_rec := l_x_Line_Adj_rec;
1249:
1250: oe_order_adj_pvt.Line_Adjs
1251: ( p_init_msg_list => FND_API.G_TRUE

Line 1250: oe_order_adj_pvt.Line_Adjs

1246:
1247: -- Call Oe_Order_Adj_Pvt.Line_Adj
1248: l_Line_Adj_rec := l_x_Line_Adj_rec;
1249:
1250: oe_order_adj_pvt.Line_Adjs
1251: ( p_init_msg_list => FND_API.G_TRUE
1252: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1253: , p_control_rec => l_control_rec
1254: , p_x_line_adj_tbl => l_x_Line_Adj_tbl

Line 2080: -- Call Oe_Order_Adj_Pvt.Line_Adj

2076:
2077: END IF; */
2078:
2079:
2080: -- Call Oe_Order_Adj_Pvt.Line_Adj
2081: oe_order_adj_pvt.Line_Adjs
2082: ( p_init_msg_list => FND_API.G_TRUE
2083: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2084: , p_control_rec => l_control_rec

Line 2081: oe_order_adj_pvt.Line_Adjs

2077: END IF; */
2078:
2079:
2080: -- Call Oe_Order_Adj_Pvt.Line_Adj
2081: oe_order_adj_pvt.Line_Adjs
2082: ( p_init_msg_list => FND_API.G_TRUE
2083: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2084: , p_control_rec => l_control_rec
2085: , p_x_line_adj_tbl => l_x_Line_Adj_tbl

Line 2342: l_line_id_tbl OE_Order_Adj_Pvt.Index_Tbl_Type;

2338: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2339:
2340: --1790502
2341: l_line_rec OE_Order_Pub.Line_Rec_Type;
2342: l_line_id_tbl OE_Order_Adj_Pvt.Index_Tbl_Type;
2343: l_top_model_line_id Number;
2344: l_profile_cascade_adjustments Varchar2(1):= NVL(FND_PROFILE.VALUE('ONT_CASCADE_ADJUSTMENTS'),'N');
2345:
2346: --

Line 2465: -- Call Oe_Order_Adj_Pvt.Line_Adj

2461: End If;
2462:
2463: End If;
2464:
2465: -- Call Oe_Order_Adj_Pvt.Line_Adj
2466: oe_order_adj_pvt.Line_Adjs
2467: ( p_init_msg_list => FND_API.G_TRUE
2468: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2469: , p_control_rec => l_control_rec

Line 2466: oe_order_adj_pvt.Line_Adjs

2462:
2463: End If;
2464:
2465: -- Call Oe_Order_Adj_Pvt.Line_Adj
2466: oe_order_adj_pvt.Line_Adjs
2467: ( p_init_msg_list => FND_API.G_TRUE
2468: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2469: , p_control_rec => l_control_rec
2470: , p_x_line_adj_tbl => l_x_Line_Adj_tbl

Line 2995: -- Call Oe_Order_Adj_Pvt.Line_Adj

2991: IF l_debug_level > 0 THEN
2992: oe_debug_pub.add( 'BEFORE EXECUTING PROCESS_ORDER...' , 1 ) ;
2993: END IF;
2994:
2995: -- Call Oe_Order_Adj_Pvt.Line_Adj
2996: oe_order_adj_pvt.Line_Adjs
2997: ( p_init_msg_list => FND_API.G_TRUE
2998: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
2999: , p_control_rec => l_control_rec

Line 2996: oe_order_adj_pvt.Line_Adjs

2992: oe_debug_pub.add( 'BEFORE EXECUTING PROCESS_ORDER...' , 1 ) ;
2993: END IF;
2994:
2995: -- Call Oe_Order_Adj_Pvt.Line_Adj
2996: oe_order_adj_pvt.Line_Adjs
2997: ( p_init_msg_list => FND_API.G_TRUE
2998: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
2999: , p_control_rec => l_control_rec
3000: , p_x_line_adj_tbl => l_x_Line_Adj_tbl

Line 3414: Oe_Order_Adj_Pvt.Line_Adjs(p_validation_level => FND_API.G_VALID_LEVEL_NONE,

3410: INTO l_line_adj_tbl(1).price_adjustment_id
3411: FROM Dual;
3412:
3413:
3414: Oe_Order_Adj_Pvt.Line_Adjs(p_validation_level => FND_API.G_VALID_LEVEL_NONE,
3415: p_control_rec => l_control_rec,
3416: p_x_line_adj_tbl => l_line_adj_tbl,
3417: p_x_old_line_adj_tbl => l_dummy_tbl);
3418: x_price_adjustment_id := l_line_adj_tbl(1).price_adjustment_id;

Line 3468: x_line_id_tbl out nocopy Oe_Order_Adj_Pvt.Index_Tbl_Type) Is

3464: --If p_mode is set to 'SERVICE' it will return service lines for options line of a top_model_line
3465: Procedure Get_Option_Service_Lines(p_top_model_line_id In Number,
3466: p_service_line_id In Number Default null,
3467: p_mode In VARCHAR2 Default 'SERVICE',
3468: x_line_id_tbl out nocopy Oe_Order_Adj_Pvt.Index_Tbl_Type) Is
3469:
3470: Cursor service_cur is
3471: Select b.line_id
3472: From oe_order_lines_all a,

Line 3537: p_line_id_tbl In Oe_Order_Adj_Pvt.Index_Tbl_Type,

3533:
3534: --This Procedure will either change,create or delete adjustments
3535: --based on parent adjustment record
3536: Procedure Process_Adj(p_parent_adj_rec In Oe_Order_Pub.Line_Adj_Rec_Type,
3537: p_line_id_tbl In Oe_Order_Adj_Pvt.Index_Tbl_Type,
3538: p_delete_flag In Varchar2 Default 'N' ,
3539: p_create_adj_no_validate In Boolean Default FALSE) Is
3540:
3541: Cursor adjustment_cur(p_list_line_id Number ,p_line_id Number) Is