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_ORDER_BOOK_UTIL dependencies on OE_ORDER_UTIL

Line 531: ,x_Header_adj_Tbl => OE_ORDER_UTIL.g_header_adj_tbl);

527: oe_debug_pub.add('p_header_id is '|| p_header_id);
528: oe_debug_pub.add('l_header_rec.header_id is '|| l_header_rec.header_id);
529: OE_HEADER_ADJ_UTIL.Query_Rows
530: (p_header_id => p_header_id
531: ,x_Header_adj_Tbl => OE_ORDER_UTIL.g_header_adj_tbl);
532:
533:
534: -- loop to populate the operation in the global table
535: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.FIRST;

Line 535: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.FIRST;

531: ,x_Header_adj_Tbl => OE_ORDER_UTIL.g_header_adj_tbl);
532:
533:
534: -- loop to populate the operation in the global table
535: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.FIRST;
536:
537: while l_in_loop_index is not null loop
538: OE_ORDER_UTIL.g_header_adj_tbl(l_in_loop_index).operation := OE_GLOBALS.G_OPR_CREATE;
539: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.NEXT(l_in_loop_index);

Line 538: OE_ORDER_UTIL.g_header_adj_tbl(l_in_loop_index).operation := OE_GLOBALS.G_OPR_CREATE;

534: -- loop to populate the operation in the global table
535: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.FIRST;
536:
537: while l_in_loop_index is not null loop
538: OE_ORDER_UTIL.g_header_adj_tbl(l_in_loop_index).operation := OE_GLOBALS.G_OPR_CREATE;
539: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.NEXT(l_in_loop_index);
540: END LOOP;
541:
542: oe_debug_pub.add('in OEXUBOKB header adj tbl count is '|| OE_ORDER_UTIL.g_header_adj_tbl.count);

Line 539: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.NEXT(l_in_loop_index);

535: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.FIRST;
536:
537: while l_in_loop_index is not null loop
538: OE_ORDER_UTIL.g_header_adj_tbl(l_in_loop_index).operation := OE_GLOBALS.G_OPR_CREATE;
539: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.NEXT(l_in_loop_index);
540: END LOOP;
541:
542: oe_debug_pub.add('in OEXUBOKB header adj tbl count is '|| OE_ORDER_UTIL.g_header_adj_tbl.count);
543:

Line 542: oe_debug_pub.add('in OEXUBOKB header adj tbl count is '|| OE_ORDER_UTIL.g_header_adj_tbl.count);

538: OE_ORDER_UTIL.g_header_adj_tbl(l_in_loop_index).operation := OE_GLOBALS.G_OPR_CREATE;
539: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.NEXT(l_in_loop_index);
540: END LOOP;
541:
542: oe_debug_pub.add('in OEXUBOKB header adj tbl count is '|| OE_ORDER_UTIL.g_header_adj_tbl.count);
543:
544: IF l_debug_level > 0 THEN
545: oe_debug_pub.add( 'BEFORE ENTERING UPDATE_GLOBAL_PICTURE IN BOOKING' ) ;
546: END IF;

Line 549: oe_debug_pub.add( 'BEFORE UPDATE , HEADER VALUE' || OE_ORDER_UTIL.G_HEADER_REC.HEADER_ID ) ;

545: oe_debug_pub.add( 'BEFORE ENTERING UPDATE_GLOBAL_PICTURE IN BOOKING' ) ;
546: END IF;
547: -- call notification framework to get header index position
548: IF l_debug_level > 0 THEN
549: oe_debug_pub.add( 'BEFORE UPDATE , HEADER VALUE' || OE_ORDER_UTIL.G_HEADER_REC.HEADER_ID ) ;
550: END IF;
551: IF l_debug_level > 0 THEN
552: oe_debug_pub.add( 'BEFORE UPDATE , OLD HEADER VALUE' || OE_ORDER_UTIL.G_OLD_HEADER_REC.HEADER_ID ) ;
553: END IF;

Line 552: oe_debug_pub.add( 'BEFORE UPDATE , OLD HEADER VALUE' || OE_ORDER_UTIL.G_OLD_HEADER_REC.HEADER_ID ) ;

548: IF l_debug_level > 0 THEN
549: oe_debug_pub.add( 'BEFORE UPDATE , HEADER VALUE' || OE_ORDER_UTIL.G_HEADER_REC.HEADER_ID ) ;
550: END IF;
551: IF l_debug_level > 0 THEN
552: oe_debug_pub.add( 'BEFORE UPDATE , OLD HEADER VALUE' || OE_ORDER_UTIL.G_OLD_HEADER_REC.HEADER_ID ) ;
553: END IF;
554: OE_ORDER_UTIL.Update_Global_Picture
555: (p_Upd_New_Rec_If_Exists =>FALSE
556: , p_header_rec => l_header_rec

Line 554: OE_ORDER_UTIL.Update_Global_Picture

550: END IF;
551: IF l_debug_level > 0 THEN
552: oe_debug_pub.add( 'BEFORE UPDATE , OLD HEADER VALUE' || OE_ORDER_UTIL.G_OLD_HEADER_REC.HEADER_ID ) ;
553: END IF;
554: OE_ORDER_UTIL.Update_Global_Picture
555: (p_Upd_New_Rec_If_Exists =>FALSE
556: , p_header_rec => l_header_rec
557: , p_old_header_rec => l_old_header_rec
558: , p_header_id => l_header_rec.header_id

Line 578: oe_debug_pub.add( 'JPN: OLD GLOBAL HDR REC BOOKED_FLAG IS:' || OE_ORDER_UTIL.G_OLD_HEADER_REC.BOOKED_FLAG , 1 ) ;

574:
575: IF l_notify_index is not null then
576: -- modify Global Picture
577: IF l_debug_level > 0 THEN
578: oe_debug_pub.add( 'JPN: OLD GLOBAL HDR REC BOOKED_FLAG IS:' || OE_ORDER_UTIL.G_OLD_HEADER_REC.BOOKED_FLAG , 1 ) ;
579: END IF;
580: OE_ORDER_UTIL.g_old_header_rec := l_old_header_rec;
581: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
582: OE_ORDER_UTIL.g_old_header_rec.booked_flag := 'N';

Line 580: OE_ORDER_UTIL.g_old_header_rec := l_old_header_rec;

576: -- modify Global Picture
577: IF l_debug_level > 0 THEN
578: oe_debug_pub.add( 'JPN: OLD GLOBAL HDR REC BOOKED_FLAG IS:' || OE_ORDER_UTIL.G_OLD_HEADER_REC.BOOKED_FLAG , 1 ) ;
579: END IF;
580: OE_ORDER_UTIL.g_old_header_rec := l_old_header_rec;
581: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
582: OE_ORDER_UTIL.g_old_header_rec.booked_flag := 'N';
583: OE_ORDER_UTIL.g_old_header_rec.booked_date := NULL;
584: OE_ORDER_UTIL.g_header_rec.booked_flag := l_header_rec.booked_flag;

Line 581: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;

577: IF l_debug_level > 0 THEN
578: oe_debug_pub.add( 'JPN: OLD GLOBAL HDR REC BOOKED_FLAG IS:' || OE_ORDER_UTIL.G_OLD_HEADER_REC.BOOKED_FLAG , 1 ) ;
579: END IF;
580: OE_ORDER_UTIL.g_old_header_rec := l_old_header_rec;
581: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
582: OE_ORDER_UTIL.g_old_header_rec.booked_flag := 'N';
583: OE_ORDER_UTIL.g_old_header_rec.booked_date := NULL;
584: OE_ORDER_UTIL.g_header_rec.booked_flag := l_header_rec.booked_flag;
585: OE_ORDER_UTIL.g_header_rec.booked_date:= l_header_rec.booked_date;

Line 582: OE_ORDER_UTIL.g_old_header_rec.booked_flag := 'N';

578: oe_debug_pub.add( 'JPN: OLD GLOBAL HDR REC BOOKED_FLAG IS:' || OE_ORDER_UTIL.G_OLD_HEADER_REC.BOOKED_FLAG , 1 ) ;
579: END IF;
580: OE_ORDER_UTIL.g_old_header_rec := l_old_header_rec;
581: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
582: OE_ORDER_UTIL.g_old_header_rec.booked_flag := 'N';
583: OE_ORDER_UTIL.g_old_header_rec.booked_date := NULL;
584: OE_ORDER_UTIL.g_header_rec.booked_flag := l_header_rec.booked_flag;
585: OE_ORDER_UTIL.g_header_rec.booked_date:= l_header_rec.booked_date;
586: OE_ORDER_UTIL.g_header_rec.flow_status_code:=l_header_rec.flow_status_code;

Line 583: OE_ORDER_UTIL.g_old_header_rec.booked_date := NULL;

579: END IF;
580: OE_ORDER_UTIL.g_old_header_rec := l_old_header_rec;
581: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
582: OE_ORDER_UTIL.g_old_header_rec.booked_flag := 'N';
583: OE_ORDER_UTIL.g_old_header_rec.booked_date := NULL;
584: OE_ORDER_UTIL.g_header_rec.booked_flag := l_header_rec.booked_flag;
585: OE_ORDER_UTIL.g_header_rec.booked_date:= l_header_rec.booked_date;
586: OE_ORDER_UTIL.g_header_rec.flow_status_code:=l_header_rec.flow_status_code;
587: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;

Line 584: OE_ORDER_UTIL.g_header_rec.booked_flag := l_header_rec.booked_flag;

580: OE_ORDER_UTIL.g_old_header_rec := l_old_header_rec;
581: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
582: OE_ORDER_UTIL.g_old_header_rec.booked_flag := 'N';
583: OE_ORDER_UTIL.g_old_header_rec.booked_date := NULL;
584: OE_ORDER_UTIL.g_header_rec.booked_flag := l_header_rec.booked_flag;
585: OE_ORDER_UTIL.g_header_rec.booked_date:= l_header_rec.booked_date;
586: OE_ORDER_UTIL.g_header_rec.flow_status_code:=l_header_rec.flow_status_code;
587: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
588: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;

Line 585: OE_ORDER_UTIL.g_header_rec.booked_date:= l_header_rec.booked_date;

581: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
582: OE_ORDER_UTIL.g_old_header_rec.booked_flag := 'N';
583: OE_ORDER_UTIL.g_old_header_rec.booked_date := NULL;
584: OE_ORDER_UTIL.g_header_rec.booked_flag := l_header_rec.booked_flag;
585: OE_ORDER_UTIL.g_header_rec.booked_date:= l_header_rec.booked_date;
586: OE_ORDER_UTIL.g_header_rec.flow_status_code:=l_header_rec.flow_status_code;
587: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
588: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
589: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;

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

582: OE_ORDER_UTIL.g_old_header_rec.booked_flag := 'N';
583: OE_ORDER_UTIL.g_old_header_rec.booked_date := NULL;
584: OE_ORDER_UTIL.g_header_rec.booked_flag := l_header_rec.booked_flag;
585: OE_ORDER_UTIL.g_header_rec.booked_date:= l_header_rec.booked_date;
586: OE_ORDER_UTIL.g_header_rec.flow_status_code:=l_header_rec.flow_status_code;
587: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
588: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
589: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
590: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;

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

583: OE_ORDER_UTIL.g_old_header_rec.booked_date := NULL;
584: OE_ORDER_UTIL.g_header_rec.booked_flag := l_header_rec.booked_flag;
585: OE_ORDER_UTIL.g_header_rec.booked_date:= l_header_rec.booked_date;
586: OE_ORDER_UTIL.g_header_rec.flow_status_code:=l_header_rec.flow_status_code;
587: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
588: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
589: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
590: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
591: OE_ORDER_UTIL.g_header_rec.operation:= l_header_rec.operation;

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

584: OE_ORDER_UTIL.g_header_rec.booked_flag := l_header_rec.booked_flag;
585: OE_ORDER_UTIL.g_header_rec.booked_date:= l_header_rec.booked_date;
586: OE_ORDER_UTIL.g_header_rec.flow_status_code:=l_header_rec.flow_status_code;
587: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
588: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
589: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
590: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
591: OE_ORDER_UTIL.g_header_rec.operation:= l_header_rec.operation;
592:

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

585: OE_ORDER_UTIL.g_header_rec.booked_date:= l_header_rec.booked_date;
586: OE_ORDER_UTIL.g_header_rec.flow_status_code:=l_header_rec.flow_status_code;
587: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
588: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
589: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
590: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
591: OE_ORDER_UTIL.g_header_rec.operation:= l_header_rec.operation;
592:
593: IF l_debug_level > 0 THEN

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

586: OE_ORDER_UTIL.g_header_rec.flow_status_code:=l_header_rec.flow_status_code;
587: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
588: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
589: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
590: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
591: OE_ORDER_UTIL.g_header_rec.operation:= l_header_rec.operation;
592:
593: IF l_debug_level > 0 THEN
594: oe_debug_pub.add( 'JYOTHI:GLOBAL HDR REC BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG , 1 ) ;

Line 591: OE_ORDER_UTIL.g_header_rec.operation:= l_header_rec.operation;

587: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
588: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
589: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
590: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
591: OE_ORDER_UTIL.g_header_rec.operation:= l_header_rec.operation;
592:
593: IF l_debug_level > 0 THEN
594: oe_debug_pub.add( 'JYOTHI:GLOBAL HDR REC BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG , 1 ) ;
595: END IF;

Line 594: oe_debug_pub.add( 'JYOTHI:GLOBAL HDR REC BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG , 1 ) ;

590: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
591: OE_ORDER_UTIL.g_header_rec.operation:= l_header_rec.operation;
592:
593: IF l_debug_level > 0 THEN
594: oe_debug_pub.add( 'JYOTHI:GLOBAL HDR REC BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG , 1 ) ;
595: END IF;
596: IF l_debug_level > 0 THEN
597: oe_debug_pub.add( 'GLOBAL HDR BOOKED_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_DATE , 1 ) ;
598: END IF;

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

593: IF l_debug_level > 0 THEN
594: oe_debug_pub.add( 'JYOTHI:GLOBAL HDR REC BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG , 1 ) ;
595: END IF;
596: IF l_debug_level > 0 THEN
597: oe_debug_pub.add( 'GLOBAL HDR BOOKED_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_DATE , 1 ) ;
598: END IF;
599: IF l_debug_level > 0 THEN
600: oe_debug_pub.add( 'GLOBAL HDR FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;
601: END IF;

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

596: IF l_debug_level > 0 THEN
597: oe_debug_pub.add( 'GLOBAL HDR BOOKED_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_DATE , 1 ) ;
598: END IF;
599: IF l_debug_level > 0 THEN
600: oe_debug_pub.add( 'GLOBAL HDR FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;
601: END IF;
602:
603: END IF ; /* global entity index null check */
604:

Line 617: OE_ORDER_UTIL.Update_Global_Picture

613: IF l_debug_level > 0 THEN
614: oe_debug_pub.add( 'JFC: IN BOOKING LINES , L_LOOP_INDEX= '||L_LOOP_INDEX , 1 ) ;
615: END IF;
616: -- call notification framework to get this line's index position
617: OE_ORDER_UTIL.Update_Global_Picture
618: (p_Upd_New_Rec_If_Exists =>FALSE
619: , p_line_rec => l_line_tbl(l_loop_index)
620: , p_line_id => l_line_tbl(l_loop_index).line_id
621: , x_index => l_notify_index

Line 639: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index):= l_old_line_tbl(l_loop_index);

635: END IF;
636:
637: IF l_notify_index is not null then
638: -- modify Global Picture
639: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index):= l_old_line_tbl(l_loop_index);
640: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
641: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index).booked_flag:='N';
642:
643: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id:= l_line_tbl(l_loop_index).line_id;

Line 640: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);

636:
637: IF l_notify_index is not null then
638: -- modify Global Picture
639: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index):= l_old_line_tbl(l_loop_index);
640: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
641: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index).booked_flag:='N';
642:
643: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id:= l_line_tbl(l_loop_index).line_id;
644: OE_ORDER_UTIL.g_line_tbl(l_notify_index).booked_flag:= l_line_tbl(l_loop_index).booked_flag;

Line 641: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index).booked_flag:='N';

637: IF l_notify_index is not null then
638: -- modify Global Picture
639: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index):= l_old_line_tbl(l_loop_index);
640: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
641: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index).booked_flag:='N';
642:
643: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id:= l_line_tbl(l_loop_index).line_id;
644: OE_ORDER_UTIL.g_line_tbl(l_notify_index).booked_flag:= l_line_tbl(l_loop_index).booked_flag;
645: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(l_loop_index).flow_status_code;

Line 643: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id:= l_line_tbl(l_loop_index).line_id;

639: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index):= l_old_line_tbl(l_loop_index);
640: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
641: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index).booked_flag:='N';
642:
643: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id:= l_line_tbl(l_loop_index).line_id;
644: OE_ORDER_UTIL.g_line_tbl(l_notify_index).booked_flag:= l_line_tbl(l_loop_index).booked_flag;
645: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(l_loop_index).flow_status_code;
646: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(l_loop_index).last_updated_by;
647: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(l_loop_index).last_update_login;

Line 644: OE_ORDER_UTIL.g_line_tbl(l_notify_index).booked_flag:= l_line_tbl(l_loop_index).booked_flag;

640: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
641: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index).booked_flag:='N';
642:
643: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id:= l_line_tbl(l_loop_index).line_id;
644: OE_ORDER_UTIL.g_line_tbl(l_notify_index).booked_flag:= l_line_tbl(l_loop_index).booked_flag;
645: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(l_loop_index).flow_status_code;
646: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(l_loop_index).last_updated_by;
647: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(l_loop_index).last_update_login;
648: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(l_loop_index).last_update_date;

Line 645: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(l_loop_index).flow_status_code;

641: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index).booked_flag:='N';
642:
643: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id:= l_line_tbl(l_loop_index).line_id;
644: OE_ORDER_UTIL.g_line_tbl(l_notify_index).booked_flag:= l_line_tbl(l_loop_index).booked_flag;
645: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(l_loop_index).flow_status_code;
646: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(l_loop_index).last_updated_by;
647: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(l_loop_index).last_update_login;
648: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(l_loop_index).last_update_date;
649: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(l_loop_index).lock_control;

Line 646: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(l_loop_index).last_updated_by;

642:
643: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id:= l_line_tbl(l_loop_index).line_id;
644: OE_ORDER_UTIL.g_line_tbl(l_notify_index).booked_flag:= l_line_tbl(l_loop_index).booked_flag;
645: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(l_loop_index).flow_status_code;
646: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(l_loop_index).last_updated_by;
647: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(l_loop_index).last_update_login;
648: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(l_loop_index).last_update_date;
649: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(l_loop_index).lock_control;
650: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation:=l_line_tbl(l_loop_index).operation;

Line 647: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(l_loop_index).last_update_login;

643: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id:= l_line_tbl(l_loop_index).line_id;
644: OE_ORDER_UTIL.g_line_tbl(l_notify_index).booked_flag:= l_line_tbl(l_loop_index).booked_flag;
645: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(l_loop_index).flow_status_code;
646: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(l_loop_index).last_updated_by;
647: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(l_loop_index).last_update_login;
648: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(l_loop_index).last_update_date;
649: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(l_loop_index).lock_control;
650: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation:=l_line_tbl(l_loop_index).operation;
651:

Line 648: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(l_loop_index).last_update_date;

644: OE_ORDER_UTIL.g_line_tbl(l_notify_index).booked_flag:= l_line_tbl(l_loop_index).booked_flag;
645: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(l_loop_index).flow_status_code;
646: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(l_loop_index).last_updated_by;
647: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(l_loop_index).last_update_login;
648: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(l_loop_index).last_update_date;
649: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(l_loop_index).lock_control;
650: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation:=l_line_tbl(l_loop_index).operation;
651:
652: IF l_debug_level > 0 THEN

Line 649: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(l_loop_index).lock_control;

645: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(l_loop_index).flow_status_code;
646: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(l_loop_index).last_updated_by;
647: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(l_loop_index).last_update_login;
648: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(l_loop_index).last_update_date;
649: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(l_loop_index).lock_control;
650: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation:=l_line_tbl(l_loop_index).operation;
651:
652: IF l_debug_level > 0 THEN
653: oe_debug_pub.add( 'IN BOOKING , AFTER UPDATE LINE GLOBAL PICTURE' ) ;

Line 650: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation:=l_line_tbl(l_loop_index).operation;

646: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(l_loop_index).last_updated_by;
647: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(l_loop_index).last_update_login;
648: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(l_loop_index).last_update_date;
649: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(l_loop_index).lock_control;
650: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation:=l_line_tbl(l_loop_index).operation;
651:
652: IF l_debug_level > 0 THEN
653: oe_debug_pub.add( 'IN BOOKING , AFTER UPDATE LINE GLOBAL PICTURE' ) ;
654: END IF;

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

652: IF l_debug_level > 0 THEN
653: oe_debug_pub.add( 'IN BOOKING , AFTER UPDATE LINE GLOBAL PICTURE' ) ;
654: END IF;
655: IF l_debug_level > 0 THEN
656: oe_debug_pub.add( 'GLOBAL LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;
657: END IF;
658: IF l_debug_level > 0 THEN
659: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
660: END IF;

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

655: IF l_debug_level > 0 THEN
656: oe_debug_pub.add( 'GLOBAL LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;
657: END IF;
658: IF l_debug_level > 0 THEN
659: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
660: END IF;
661: IF l_debug_level > 0 THEN
662: oe_debug_pub.add( 'GLOBAL OLD LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;
663: END IF;

Line 662: oe_debug_pub.add( 'GLOBAL OLD LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;

658: IF l_debug_level > 0 THEN
659: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
660: END IF;
661: IF l_debug_level > 0 THEN
662: oe_debug_pub.add( 'GLOBAL OLD LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;
663: END IF;
664: IF l_debug_level > 0 THEN
665: oe_debug_pub.add( 'GLOBAL LINE OPERATION IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OPERATION , 1 ) ;
666: END IF;

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

661: IF l_debug_level > 0 THEN
662: oe_debug_pub.add( 'GLOBAL OLD LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;
663: END IF;
664: IF l_debug_level > 0 THEN
665: oe_debug_pub.add( 'GLOBAL LINE OPERATION IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OPERATION , 1 ) ;
666: END IF;
667: END IF ; /* global entity index null check */
668:
669: -- bug 2821129

Line 674: oe_debug_pub.add('in OEXUBOKB start g line adj tbl count is '|| OE_ORDER_UTIL.g_line_adj_tbl.count);

670:
671: oe_debug_pub.add('p_header_id is '|| p_header_id);
672: oe_debug_pub.add('line_id is '|| l_line_tbl(l_loop_index).line_id);
673:
674: oe_debug_pub.add('in OEXUBOKB start g line adj tbl count is '|| OE_ORDER_UTIL.g_line_adj_tbl.count);
675:
676: OE_LINE_ADJ_UTIL.Query_Rows
677: (
678: p_line_id => l_line_tbl(l_loop_index).line_id

Line 690: OE_ORDER_UTIL.Update_Global_Picture

686: l_in_loop_index := l_line_adj_tbl.FIRST;
687:
688: While l_in_loop_index is not NULL LOOP
689:
690: OE_ORDER_UTIL.Update_Global_Picture
691: (p_Upd_New_Rec_If_Exists =>FALSE
692: , p_line_adj_id => l_line_adj_tbl(l_in_loop_index).price_adjustment_id
693: , x_index => l_notify_index
694: , x_return_status => l_return_status);

Line 696: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index) := l_line_adj_tbl(l_in_loop_index);

692: , p_line_adj_id => l_line_adj_tbl(l_in_loop_index).price_adjustment_id
693: , x_index => l_notify_index
694: , x_return_status => l_return_status);
695:
696: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index) := l_line_adj_tbl(l_in_loop_index);
697: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation := OE_GLOBALS.G_OPR_CREATE;
698: oe_debug_pub.add('in OEXUBOKB after insert into global table, line_id is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).line_id);
699: oe_debug_pub.add('in OEXUBOKB after insert into global table, operation is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation);
700:

Line 697: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation := OE_GLOBALS.G_OPR_CREATE;

693: , x_index => l_notify_index
694: , x_return_status => l_return_status);
695:
696: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index) := l_line_adj_tbl(l_in_loop_index);
697: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation := OE_GLOBALS.G_OPR_CREATE;
698: oe_debug_pub.add('in OEXUBOKB after insert into global table, line_id is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).line_id);
699: oe_debug_pub.add('in OEXUBOKB after insert into global table, operation is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation);
700:
701: l_in_loop_index := l_line_adj_tbl.NEXT(l_in_loop_index);

Line 698: oe_debug_pub.add('in OEXUBOKB after insert into global table, line_id is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).line_id);

694: , x_return_status => l_return_status);
695:
696: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index) := l_line_adj_tbl(l_in_loop_index);
697: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation := OE_GLOBALS.G_OPR_CREATE;
698: oe_debug_pub.add('in OEXUBOKB after insert into global table, line_id is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).line_id);
699: oe_debug_pub.add('in OEXUBOKB after insert into global table, operation is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation);
700:
701: l_in_loop_index := l_line_adj_tbl.NEXT(l_in_loop_index);
702:

Line 699: oe_debug_pub.add('in OEXUBOKB after insert into global table, operation is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation);

695:
696: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index) := l_line_adj_tbl(l_in_loop_index);
697: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation := OE_GLOBALS.G_OPR_CREATE;
698: oe_debug_pub.add('in OEXUBOKB after insert into global table, line_id is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).line_id);
699: oe_debug_pub.add('in OEXUBOKB after insert into global table, operation is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation);
700:
701: l_in_loop_index := l_line_adj_tbl.NEXT(l_in_loop_index);
702:
703: END LOOP;

Line 705: oe_debug_pub.add('in OEXUBOKB at end g line adj tbl count is '|| OE_ORDER_UTIL.g_line_adj_tbl.count);

701: l_in_loop_index := l_line_adj_tbl.NEXT(l_in_loop_index);
702:
703: END LOOP;
704:
705: oe_debug_pub.add('in OEXUBOKB at end g line adj tbl count is '|| OE_ORDER_UTIL.g_line_adj_tbl.count);
706:
707: l_loop_index := l_line_tbl.NEXT(l_loop_index);
708:
709: END LOOP outer; -- over each line to update global picture

Line 1124: p_date=> nvl(OE_ORDER_UTIL.g_header_rec.booked_date,SYSDATE));

1120: );
1121:
1122: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1123: OE_Header_Scredit_Util.Redefault_Sales_Group(p_header_id=>p_header_id,
1124: p_date=> nvl(OE_ORDER_UTIL.g_header_rec.booked_date,SYSDATE));
1125: END IF;
1126:
1127: -- if unexpected error, then go to exception handler. If there
1128: -- were validation failures, then it is expected error therefore

Line 1529: OE_ORDER_UTIL.Lock_Order_Object

1525: -- This will prevent another user from working on the same order
1526: -- and needs to be done before calling the wf_engine as the workflow
1527: -- engine will hang if another user is trying to book the same order
1528:
1529: OE_ORDER_UTIL.Lock_Order_Object
1530: (p_header_id => p_header_id
1531: ,x_return_status => x_return_status
1532: );
1533: IF x_return_status = FND_API.G_RET_STS_ERROR THEN