DBA Data[Home] [Help]

APPS.OE_ORDER_CLOSE_UTIL dependencies on OE_ORDER_UTIL

Line 257: OE_ORDER_UTIL.Update_Global_Picture

253: -- jolin start
254: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
255:
256: -- call notification framework to get header index position
257: OE_ORDER_UTIL.Update_Global_Picture
258: (p_Upd_New_Rec_If_Exists =>FALSE
259: , p_header_rec => l_header_rec
260: , p_old_header_rec => l_old_header_rec
261: , p_header_id => l_header_rec.header_id

Line 275: OE_ORDER_UTIL.g_header_rec.open_flag:= l_header_rec.open_flag;

271:
272: IF l_notify_index is not null then
273: -- modify Global Picture
274:
275: OE_ORDER_UTIL.g_header_rec.open_flag:= l_header_rec.open_flag;
276: OE_ORDER_UTIL.g_header_rec.flow_status_code:= l_header_rec.flow_status_code;
277: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
278: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
279: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;

Line 276: OE_ORDER_UTIL.g_header_rec.flow_status_code:= l_header_rec.flow_status_code;

272: IF l_notify_index is not null then
273: -- modify Global Picture
274:
275: OE_ORDER_UTIL.g_header_rec.open_flag:= l_header_rec.open_flag;
276: OE_ORDER_UTIL.g_header_rec.flow_status_code:= l_header_rec.flow_status_code;
277: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
278: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
279: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
280: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;

Line 277: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;

273: -- modify Global Picture
274:
275: OE_ORDER_UTIL.g_header_rec.open_flag:= l_header_rec.open_flag;
276: OE_ORDER_UTIL.g_header_rec.flow_status_code:= l_header_rec.flow_status_code;
277: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
278: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
279: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
280: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
281:

Line 278: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;

274:
275: OE_ORDER_UTIL.g_header_rec.open_flag:= l_header_rec.open_flag;
276: OE_ORDER_UTIL.g_header_rec.flow_status_code:= l_header_rec.flow_status_code;
277: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
278: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
279: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
280: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
281:
282: IF l_debug_level > 0 THEN

Line 279: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;

275: OE_ORDER_UTIL.g_header_rec.open_flag:= l_header_rec.open_flag;
276: OE_ORDER_UTIL.g_header_rec.flow_status_code:= l_header_rec.flow_status_code;
277: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
278: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
279: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
280: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
281:
282: IF l_debug_level > 0 THEN
283: oe_debug_pub.add( 'GLOBAL HDR OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPEN_FLAG , 1 ) ;

Line 280: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;

276: OE_ORDER_UTIL.g_header_rec.flow_status_code:= l_header_rec.flow_status_code;
277: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
278: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
279: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
280: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
281:
282: IF l_debug_level > 0 THEN
283: oe_debug_pub.add( 'GLOBAL HDR OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPEN_FLAG , 1 ) ;
284: END IF;

Line 283: oe_debug_pub.add( 'GLOBAL HDR OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPEN_FLAG , 1 ) ;

279: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
280: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
281:
282: IF l_debug_level > 0 THEN
283: oe_debug_pub.add( 'GLOBAL HDR OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPEN_FLAG , 1 ) ;
284: END IF;
285: IF l_debug_level > 0 THEN
286: oe_debug_pub.add( 'GLOBAL HDR FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;
287: END IF;

Line 286: oe_debug_pub.add( 'GLOBAL HDR FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;

282: IF l_debug_level > 0 THEN
283: oe_debug_pub.add( 'GLOBAL HDR OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPEN_FLAG , 1 ) ;
284: END IF;
285: IF l_debug_level > 0 THEN
286: oe_debug_pub.add( 'GLOBAL HDR FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;
287: END IF;
288:
289: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
290: RAISE FND_API.G_EXC_ERROR;

Line 747: OE_ORDER_UTIL.Update_Global_Picture

743: -- jolin start
744: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
745:
746: -- call notification framework to get this line's index position
747: OE_ORDER_UTIL.Update_Global_Picture
748: (p_Upd_New_Rec_If_Exists =>FALSE
749: , p_line_rec => l_line_tbl(1)
750: , p_old_line_rec => l_old_line_tbl(1)
751: , p_line_id => l_line_tbl(1).line_id

Line 770: OE_ORDER_UTIL.g_line_tbl(l_notify_index).open_flag:= l_line_tbl(1).open_flag;

766: END IF;
767:
768: IF l_notify_index is not null then
769: -- modify Global Picture
770: OE_ORDER_UTIL.g_line_tbl(l_notify_index).open_flag:= l_line_tbl(1).open_flag;
771: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(1).calculate_price_flag;
772: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(1).flow_status_code;
773: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(1).last_updated_by;
774: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(1).last_update_login;

Line 771: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(1).calculate_price_flag;

767:
768: IF l_notify_index is not null then
769: -- modify Global Picture
770: OE_ORDER_UTIL.g_line_tbl(l_notify_index).open_flag:= l_line_tbl(1).open_flag;
771: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(1).calculate_price_flag;
772: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(1).flow_status_code;
773: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(1).last_updated_by;
774: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(1).last_update_login;
775: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(1).last_update_date;

Line 772: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(1).flow_status_code;

768: IF l_notify_index is not null then
769: -- modify Global Picture
770: OE_ORDER_UTIL.g_line_tbl(l_notify_index).open_flag:= l_line_tbl(1).open_flag;
771: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(1).calculate_price_flag;
772: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(1).flow_status_code;
773: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(1).last_updated_by;
774: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(1).last_update_login;
775: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(1).last_update_date;
776: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(1).lock_control;

Line 773: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(1).last_updated_by;

769: -- modify Global Picture
770: OE_ORDER_UTIL.g_line_tbl(l_notify_index).open_flag:= l_line_tbl(1).open_flag;
771: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(1).calculate_price_flag;
772: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(1).flow_status_code;
773: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(1).last_updated_by;
774: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(1).last_update_login;
775: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(1).last_update_date;
776: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(1).lock_control;
777:

Line 774: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(1).last_update_login;

770: OE_ORDER_UTIL.g_line_tbl(l_notify_index).open_flag:= l_line_tbl(1).open_flag;
771: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(1).calculate_price_flag;
772: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(1).flow_status_code;
773: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(1).last_updated_by;
774: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(1).last_update_login;
775: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(1).last_update_date;
776: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(1).lock_control;
777:
778: IF l_debug_level > 0 THEN

Line 775: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(1).last_update_date;

771: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(1).calculate_price_flag;
772: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(1).flow_status_code;
773: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(1).last_updated_by;
774: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(1).last_update_login;
775: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(1).last_update_date;
776: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(1).lock_control;
777:
778: IF l_debug_level > 0 THEN
779: oe_debug_pub.add( 'GLOBAL LINE OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OPEN_FLAG , 1 ) ;

Line 776: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(1).lock_control;

772: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(1).flow_status_code;
773: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(1).last_updated_by;
774: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(1).last_update_login;
775: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(1).last_update_date;
776: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(1).lock_control;
777:
778: IF l_debug_level > 0 THEN
779: oe_debug_pub.add( 'GLOBAL LINE OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OPEN_FLAG , 1 ) ;
780: END IF;

Line 779: oe_debug_pub.add( 'GLOBAL LINE OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OPEN_FLAG , 1 ) ;

775: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(1).last_update_date;
776: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(1).lock_control;
777:
778: IF l_debug_level > 0 THEN
779: oe_debug_pub.add( 'GLOBAL LINE OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OPEN_FLAG , 1 ) ;
780: END IF;
781: IF l_debug_level > 0 THEN
782: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
783: END IF;

Line 782: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;

778: IF l_debug_level > 0 THEN
779: oe_debug_pub.add( 'GLOBAL LINE OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OPEN_FLAG , 1 ) ;
780: END IF;
781: IF l_debug_level > 0 THEN
782: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
783: END IF;
784: IF l_debug_level > 0 THEN
785: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
786: END IF;

Line 785: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;

781: IF l_debug_level > 0 THEN
782: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
783: END IF;
784: IF l_debug_level > 0 THEN
785: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
786: END IF;
787:
788:
789: -- Process requests is TRUE, but don't need to notify