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 1245: -- Call Oe_Order_Adj_Pvt.Line_Adj

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

Line 1248: oe_order_adj_pvt.Line_Adjs

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

Line 2078: -- Call Oe_Order_Adj_Pvt.Line_Adj

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

Line 2079: oe_order_adj_pvt.Line_Adjs

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

Line 2325: l_line_id_tbl OE_Order_Adj_Pvt.Index_Tbl_Type;

2321: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2322:
2323: --1790502
2324: l_line_rec OE_Order_Pub.Line_Rec_Type;
2325: l_line_id_tbl OE_Order_Adj_Pvt.Index_Tbl_Type;
2326: l_top_model_line_id Number;
2327: l_profile_cascade_adjustments Varchar2(1):= NVL(FND_PROFILE.VALUE('ONT_CASCADE_ADJUSTMENTS'),'N');
2328:
2329: --

Line 2448: -- Call Oe_Order_Adj_Pvt.Line_Adj

2444: End If;
2445:
2446: End If;
2447:
2448: -- Call Oe_Order_Adj_Pvt.Line_Adj
2449: oe_order_adj_pvt.Line_Adjs
2450: ( p_init_msg_list => FND_API.G_TRUE
2451: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2452: , p_control_rec => l_control_rec

Line 2449: oe_order_adj_pvt.Line_Adjs

2445:
2446: End If;
2447:
2448: -- Call Oe_Order_Adj_Pvt.Line_Adj
2449: oe_order_adj_pvt.Line_Adjs
2450: ( p_init_msg_list => FND_API.G_TRUE
2451: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2452: , p_control_rec => l_control_rec
2453: , p_x_line_adj_tbl => l_x_Line_Adj_tbl

Line 2978: -- Call Oe_Order_Adj_Pvt.Line_Adj

2974: IF l_debug_level > 0 THEN
2975: oe_debug_pub.add( 'BEFORE EXECUTING PROCESS_ORDER...' , 1 ) ;
2976: END IF;
2977:
2978: -- Call Oe_Order_Adj_Pvt.Line_Adj
2979: oe_order_adj_pvt.Line_Adjs
2980: ( p_init_msg_list => FND_API.G_TRUE
2981: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
2982: , p_control_rec => l_control_rec

Line 2979: oe_order_adj_pvt.Line_Adjs

2975: oe_debug_pub.add( 'BEFORE EXECUTING PROCESS_ORDER...' , 1 ) ;
2976: END IF;
2977:
2978: -- Call Oe_Order_Adj_Pvt.Line_Adj
2979: oe_order_adj_pvt.Line_Adjs
2980: ( p_init_msg_list => FND_API.G_TRUE
2981: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
2982: , p_control_rec => l_control_rec
2983: , p_x_line_adj_tbl => l_x_Line_Adj_tbl

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

3393: INTO l_line_adj_tbl(1).price_adjustment_id
3394: FROM Dual;
3395:
3396:
3397: Oe_Order_Adj_Pvt.Line_Adjs(p_validation_level => FND_API.G_VALID_LEVEL_NONE,
3398: p_control_rec => l_control_rec,
3399: p_x_line_adj_tbl => l_line_adj_tbl,
3400: p_x_old_line_adj_tbl => l_dummy_tbl);
3401: x_price_adjustment_id := l_line_adj_tbl(1).price_adjustment_id;

Line 3438: x_line_id_tbl out nocopy Oe_Order_Adj_Pvt.Index_Tbl_Type) Is

3434: --If p_mode is set to 'SERVICE' it will return service lines for options line of a top_model_line
3435: Procedure Get_Option_Service_Lines(p_top_model_line_id In Number,
3436: p_service_line_id In Number Default null,
3437: p_mode In VARCHAR2 Default 'SERVICE',
3438: x_line_id_tbl out nocopy Oe_Order_Adj_Pvt.Index_Tbl_Type) Is
3439:
3440: Cursor service_cur is
3441: Select b.line_id
3442: From oe_order_lines_all a,

Line 3507: p_line_id_tbl In Oe_Order_Adj_Pvt.Index_Tbl_Type,

3503:
3504: --This Procedure will either change,create or delete adjustments
3505: --based on parent adjustment record
3506: Procedure Process_Adj(p_parent_adj_rec In Oe_Order_Pub.Line_Adj_Rec_Type,
3507: p_line_id_tbl In Oe_Order_Adj_Pvt.Index_Tbl_Type,
3508: p_delete_flag In Varchar2 Default 'N' ,
3509: p_create_adj_no_validate In Boolean Default FALSE) Is
3510:
3511: Cursor adjustment_cur(p_list_line_id Number ,p_line_id Number) Is