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 585: ,x_Header_adj_Tbl => OE_ORDER_UTIL.g_header_adj_tbl);

581: oe_debug_pub.add('p_header_id is '|| p_header_id);
582: oe_debug_pub.add('l_header_rec.header_id is '|| l_header_rec.header_id);
583: OE_HEADER_ADJ_UTIL.Query_Rows
584: (p_header_id => p_header_id
585: ,x_Header_adj_Tbl => OE_ORDER_UTIL.g_header_adj_tbl);
586:
587:
588: -- loop to populate the operation in the global table
589: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.FIRST;

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

585: ,x_Header_adj_Tbl => OE_ORDER_UTIL.g_header_adj_tbl);
586:
587:
588: -- loop to populate the operation in the global table
589: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.FIRST;
590:
591: while l_in_loop_index is not null loop
592: OE_ORDER_UTIL.g_header_adj_tbl(l_in_loop_index).operation := OE_GLOBALS.G_OPR_CREATE;
593: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.NEXT(l_in_loop_index);

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

588: -- loop to populate the operation in the global table
589: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.FIRST;
590:
591: while l_in_loop_index is not null loop
592: OE_ORDER_UTIL.g_header_adj_tbl(l_in_loop_index).operation := OE_GLOBALS.G_OPR_CREATE;
593: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.NEXT(l_in_loop_index);
594: END LOOP;
595:
596: oe_debug_pub.add('in OEXUBOKB header adj tbl count is '|| OE_ORDER_UTIL.g_header_adj_tbl.count);

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

589: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.FIRST;
590:
591: while l_in_loop_index is not null loop
592: OE_ORDER_UTIL.g_header_adj_tbl(l_in_loop_index).operation := OE_GLOBALS.G_OPR_CREATE;
593: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.NEXT(l_in_loop_index);
594: END LOOP;
595:
596: oe_debug_pub.add('in OEXUBOKB header adj tbl count is '|| OE_ORDER_UTIL.g_header_adj_tbl.count);
597:

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

592: OE_ORDER_UTIL.g_header_adj_tbl(l_in_loop_index).operation := OE_GLOBALS.G_OPR_CREATE;
593: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.NEXT(l_in_loop_index);
594: END LOOP;
595:
596: oe_debug_pub.add('in OEXUBOKB header adj tbl count is '|| OE_ORDER_UTIL.g_header_adj_tbl.count);
597:
598: IF l_debug_level > 0 THEN
599: oe_debug_pub.add( 'BEFORE ENTERING UPDATE_GLOBAL_PICTURE IN BOOKING' ) ;
600: END IF;

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

599: oe_debug_pub.add( 'BEFORE ENTERING UPDATE_GLOBAL_PICTURE IN BOOKING' ) ;
600: END IF;
601: -- call notification framework to get header index position
602: IF l_debug_level > 0 THEN
603: oe_debug_pub.add( 'BEFORE UPDATE , HEADER VALUE' || OE_ORDER_UTIL.G_HEADER_REC.HEADER_ID ) ;
604: END IF;
605: IF l_debug_level > 0 THEN
606: oe_debug_pub.add( 'BEFORE UPDATE , OLD HEADER VALUE' || OE_ORDER_UTIL.G_OLD_HEADER_REC.HEADER_ID ) ;
607: END IF;

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

602: IF l_debug_level > 0 THEN
603: oe_debug_pub.add( 'BEFORE UPDATE , HEADER VALUE' || OE_ORDER_UTIL.G_HEADER_REC.HEADER_ID ) ;
604: END IF;
605: IF l_debug_level > 0 THEN
606: oe_debug_pub.add( 'BEFORE UPDATE , OLD HEADER VALUE' || OE_ORDER_UTIL.G_OLD_HEADER_REC.HEADER_ID ) ;
607: END IF;
608: OE_ORDER_UTIL.Update_Global_Picture
609: (p_Upd_New_Rec_If_Exists =>FALSE
610: , p_header_rec => l_header_rec

Line 608: OE_ORDER_UTIL.Update_Global_Picture

604: END IF;
605: IF l_debug_level > 0 THEN
606: oe_debug_pub.add( 'BEFORE UPDATE , OLD HEADER VALUE' || OE_ORDER_UTIL.G_OLD_HEADER_REC.HEADER_ID ) ;
607: END IF;
608: OE_ORDER_UTIL.Update_Global_Picture
609: (p_Upd_New_Rec_If_Exists =>FALSE
610: , p_header_rec => l_header_rec
611: , p_old_header_rec => l_old_header_rec
612: , p_header_id => l_header_rec.header_id

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

628:
629: IF l_notify_index is not null then
630: -- modify Global Picture
631: IF l_debug_level > 0 THEN
632: oe_debug_pub.add( 'JPN: OLD GLOBAL HDR REC BOOKED_FLAG IS:' || OE_ORDER_UTIL.G_OLD_HEADER_REC.BOOKED_FLAG , 1 ) ;
633: END IF;
634: OE_ORDER_UTIL.g_old_header_rec := l_old_header_rec;
635: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
636: OE_ORDER_UTIL.g_old_header_rec.booked_flag := 'N';

Line 634: OE_ORDER_UTIL.g_old_header_rec := l_old_header_rec;

630: -- modify Global Picture
631: IF l_debug_level > 0 THEN
632: oe_debug_pub.add( 'JPN: OLD GLOBAL HDR REC BOOKED_FLAG IS:' || OE_ORDER_UTIL.G_OLD_HEADER_REC.BOOKED_FLAG , 1 ) ;
633: END IF;
634: OE_ORDER_UTIL.g_old_header_rec := l_old_header_rec;
635: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
636: OE_ORDER_UTIL.g_old_header_rec.booked_flag := 'N';
637: OE_ORDER_UTIL.g_old_header_rec.booked_date := NULL;
638: OE_ORDER_UTIL.g_header_rec.booked_flag := l_header_rec.booked_flag;

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

631: IF l_debug_level > 0 THEN
632: oe_debug_pub.add( 'JPN: OLD GLOBAL HDR REC BOOKED_FLAG IS:' || OE_ORDER_UTIL.G_OLD_HEADER_REC.BOOKED_FLAG , 1 ) ;
633: END IF;
634: OE_ORDER_UTIL.g_old_header_rec := l_old_header_rec;
635: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
636: OE_ORDER_UTIL.g_old_header_rec.booked_flag := 'N';
637: OE_ORDER_UTIL.g_old_header_rec.booked_date := NULL;
638: OE_ORDER_UTIL.g_header_rec.booked_flag := l_header_rec.booked_flag;
639: OE_ORDER_UTIL.g_header_rec.booked_date:= l_header_rec.booked_date;

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

632: oe_debug_pub.add( 'JPN: OLD GLOBAL HDR REC BOOKED_FLAG IS:' || OE_ORDER_UTIL.G_OLD_HEADER_REC.BOOKED_FLAG , 1 ) ;
633: END IF;
634: OE_ORDER_UTIL.g_old_header_rec := l_old_header_rec;
635: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
636: OE_ORDER_UTIL.g_old_header_rec.booked_flag := 'N';
637: OE_ORDER_UTIL.g_old_header_rec.booked_date := NULL;
638: OE_ORDER_UTIL.g_header_rec.booked_flag := l_header_rec.booked_flag;
639: OE_ORDER_UTIL.g_header_rec.booked_date:= l_header_rec.booked_date;
640: OE_ORDER_UTIL.g_header_rec.flow_status_code:=l_header_rec.flow_status_code;

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

633: END IF;
634: OE_ORDER_UTIL.g_old_header_rec := l_old_header_rec;
635: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
636: OE_ORDER_UTIL.g_old_header_rec.booked_flag := 'N';
637: OE_ORDER_UTIL.g_old_header_rec.booked_date := NULL;
638: OE_ORDER_UTIL.g_header_rec.booked_flag := l_header_rec.booked_flag;
639: OE_ORDER_UTIL.g_header_rec.booked_date:= l_header_rec.booked_date;
640: OE_ORDER_UTIL.g_header_rec.flow_status_code:=l_header_rec.flow_status_code;
641: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;

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

634: OE_ORDER_UTIL.g_old_header_rec := l_old_header_rec;
635: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
636: OE_ORDER_UTIL.g_old_header_rec.booked_flag := 'N';
637: OE_ORDER_UTIL.g_old_header_rec.booked_date := NULL;
638: OE_ORDER_UTIL.g_header_rec.booked_flag := l_header_rec.booked_flag;
639: OE_ORDER_UTIL.g_header_rec.booked_date:= l_header_rec.booked_date;
640: OE_ORDER_UTIL.g_header_rec.flow_status_code:=l_header_rec.flow_status_code;
641: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
642: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;

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

635: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
636: OE_ORDER_UTIL.g_old_header_rec.booked_flag := 'N';
637: OE_ORDER_UTIL.g_old_header_rec.booked_date := NULL;
638: OE_ORDER_UTIL.g_header_rec.booked_flag := l_header_rec.booked_flag;
639: OE_ORDER_UTIL.g_header_rec.booked_date:= l_header_rec.booked_date;
640: OE_ORDER_UTIL.g_header_rec.flow_status_code:=l_header_rec.flow_status_code;
641: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
642: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
643: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;

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

636: OE_ORDER_UTIL.g_old_header_rec.booked_flag := 'N';
637: OE_ORDER_UTIL.g_old_header_rec.booked_date := NULL;
638: OE_ORDER_UTIL.g_header_rec.booked_flag := l_header_rec.booked_flag;
639: OE_ORDER_UTIL.g_header_rec.booked_date:= l_header_rec.booked_date;
640: OE_ORDER_UTIL.g_header_rec.flow_status_code:=l_header_rec.flow_status_code;
641: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
642: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
643: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
644: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;

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

637: OE_ORDER_UTIL.g_old_header_rec.booked_date := NULL;
638: OE_ORDER_UTIL.g_header_rec.booked_flag := l_header_rec.booked_flag;
639: OE_ORDER_UTIL.g_header_rec.booked_date:= l_header_rec.booked_date;
640: OE_ORDER_UTIL.g_header_rec.flow_status_code:=l_header_rec.flow_status_code;
641: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
642: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
643: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
644: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
645: OE_ORDER_UTIL.g_header_rec.operation:= l_header_rec.operation;

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

638: OE_ORDER_UTIL.g_header_rec.booked_flag := l_header_rec.booked_flag;
639: OE_ORDER_UTIL.g_header_rec.booked_date:= l_header_rec.booked_date;
640: OE_ORDER_UTIL.g_header_rec.flow_status_code:=l_header_rec.flow_status_code;
641: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
642: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
643: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
644: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
645: OE_ORDER_UTIL.g_header_rec.operation:= l_header_rec.operation;
646:

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

639: OE_ORDER_UTIL.g_header_rec.booked_date:= l_header_rec.booked_date;
640: OE_ORDER_UTIL.g_header_rec.flow_status_code:=l_header_rec.flow_status_code;
641: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
642: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
643: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
644: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
645: OE_ORDER_UTIL.g_header_rec.operation:= l_header_rec.operation;
646:
647: IF l_debug_level > 0 THEN

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

640: OE_ORDER_UTIL.g_header_rec.flow_status_code:=l_header_rec.flow_status_code;
641: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
642: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
643: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
644: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
645: OE_ORDER_UTIL.g_header_rec.operation:= l_header_rec.operation;
646:
647: IF l_debug_level > 0 THEN
648: oe_debug_pub.add( 'JYOTHI:GLOBAL HDR REC BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG , 1 ) ;

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

641: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
642: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
643: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
644: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
645: OE_ORDER_UTIL.g_header_rec.operation:= l_header_rec.operation;
646:
647: IF l_debug_level > 0 THEN
648: oe_debug_pub.add( 'JYOTHI:GLOBAL HDR REC BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG , 1 ) ;
649: END IF;

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

644: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
645: OE_ORDER_UTIL.g_header_rec.operation:= l_header_rec.operation;
646:
647: IF l_debug_level > 0 THEN
648: oe_debug_pub.add( 'JYOTHI:GLOBAL HDR REC BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG , 1 ) ;
649: END IF;
650: IF l_debug_level > 0 THEN
651: oe_debug_pub.add( 'GLOBAL HDR BOOKED_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_DATE , 1 ) ;
652: END IF;

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

647: IF l_debug_level > 0 THEN
648: oe_debug_pub.add( 'JYOTHI:GLOBAL HDR REC BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG , 1 ) ;
649: END IF;
650: IF l_debug_level > 0 THEN
651: oe_debug_pub.add( 'GLOBAL HDR BOOKED_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_DATE , 1 ) ;
652: END IF;
653: IF l_debug_level > 0 THEN
654: oe_debug_pub.add( 'GLOBAL HDR FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;
655: END IF;

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

650: IF l_debug_level > 0 THEN
651: oe_debug_pub.add( 'GLOBAL HDR BOOKED_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_DATE , 1 ) ;
652: END IF;
653: IF l_debug_level > 0 THEN
654: oe_debug_pub.add( 'GLOBAL HDR FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;
655: END IF;
656:
657: END IF ; /* global entity index null check */
658:

Line 671: OE_ORDER_UTIL.Update_Global_Picture

667: IF l_debug_level > 0 THEN
668: oe_debug_pub.add( 'JFC: IN BOOKING LINES , L_LOOP_INDEX= '||L_LOOP_INDEX , 1 ) ;
669: END IF;
670: -- call notification framework to get this line's index position
671: OE_ORDER_UTIL.Update_Global_Picture
672: (p_Upd_New_Rec_If_Exists =>FALSE
673: , p_line_rec => l_line_tbl(l_loop_index)
674: , p_line_id => l_line_tbl(l_loop_index).line_id
675: , x_index => l_notify_index

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

689: END IF;
690:
691: IF l_notify_index is not null then
692: -- modify Global Picture
693: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index):= l_old_line_tbl(l_loop_index);
694: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
695: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index).booked_flag:='N';
696:
697: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id:= l_line_tbl(l_loop_index).line_id;

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

690:
691: IF l_notify_index is not null then
692: -- modify Global Picture
693: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index):= l_old_line_tbl(l_loop_index);
694: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
695: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index).booked_flag:='N';
696:
697: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id:= l_line_tbl(l_loop_index).line_id;
698: OE_ORDER_UTIL.g_line_tbl(l_notify_index).booked_flag:= l_line_tbl(l_loop_index).booked_flag;

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

691: IF l_notify_index is not null then
692: -- modify Global Picture
693: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index):= l_old_line_tbl(l_loop_index);
694: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
695: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index).booked_flag:='N';
696:
697: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id:= l_line_tbl(l_loop_index).line_id;
698: OE_ORDER_UTIL.g_line_tbl(l_notify_index).booked_flag:= l_line_tbl(l_loop_index).booked_flag;
699: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(l_loop_index).flow_status_code;

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

693: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index):= l_old_line_tbl(l_loop_index);
694: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
695: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index).booked_flag:='N';
696:
697: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id:= l_line_tbl(l_loop_index).line_id;
698: OE_ORDER_UTIL.g_line_tbl(l_notify_index).booked_flag:= l_line_tbl(l_loop_index).booked_flag;
699: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(l_loop_index).flow_status_code;
700: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(l_loop_index).last_updated_by;
701: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(l_loop_index).last_update_login;

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

694: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
695: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index).booked_flag:='N';
696:
697: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id:= l_line_tbl(l_loop_index).line_id;
698: OE_ORDER_UTIL.g_line_tbl(l_notify_index).booked_flag:= l_line_tbl(l_loop_index).booked_flag;
699: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(l_loop_index).flow_status_code;
700: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(l_loop_index).last_updated_by;
701: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(l_loop_index).last_update_login;
702: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(l_loop_index).last_update_date;

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

695: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index).booked_flag:='N';
696:
697: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id:= l_line_tbl(l_loop_index).line_id;
698: OE_ORDER_UTIL.g_line_tbl(l_notify_index).booked_flag:= l_line_tbl(l_loop_index).booked_flag;
699: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(l_loop_index).flow_status_code;
700: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(l_loop_index).last_updated_by;
701: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(l_loop_index).last_update_login;
702: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(l_loop_index).last_update_date;
703: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(l_loop_index).lock_control;

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

696:
697: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id:= l_line_tbl(l_loop_index).line_id;
698: OE_ORDER_UTIL.g_line_tbl(l_notify_index).booked_flag:= l_line_tbl(l_loop_index).booked_flag;
699: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(l_loop_index).flow_status_code;
700: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(l_loop_index).last_updated_by;
701: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(l_loop_index).last_update_login;
702: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(l_loop_index).last_update_date;
703: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(l_loop_index).lock_control;
704: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation:=l_line_tbl(l_loop_index).operation;

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

697: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id:= l_line_tbl(l_loop_index).line_id;
698: OE_ORDER_UTIL.g_line_tbl(l_notify_index).booked_flag:= l_line_tbl(l_loop_index).booked_flag;
699: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(l_loop_index).flow_status_code;
700: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(l_loop_index).last_updated_by;
701: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(l_loop_index).last_update_login;
702: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(l_loop_index).last_update_date;
703: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(l_loop_index).lock_control;
704: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation:=l_line_tbl(l_loop_index).operation;
705:

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

698: OE_ORDER_UTIL.g_line_tbl(l_notify_index).booked_flag:= l_line_tbl(l_loop_index).booked_flag;
699: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(l_loop_index).flow_status_code;
700: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(l_loop_index).last_updated_by;
701: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(l_loop_index).last_update_login;
702: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(l_loop_index).last_update_date;
703: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(l_loop_index).lock_control;
704: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation:=l_line_tbl(l_loop_index).operation;
705:
706: IF l_debug_level > 0 THEN

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

699: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(l_loop_index).flow_status_code;
700: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(l_loop_index).last_updated_by;
701: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(l_loop_index).last_update_login;
702: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(l_loop_index).last_update_date;
703: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(l_loop_index).lock_control;
704: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation:=l_line_tbl(l_loop_index).operation;
705:
706: IF l_debug_level > 0 THEN
707: oe_debug_pub.add( 'IN BOOKING , AFTER UPDATE LINE GLOBAL PICTURE' ) ;

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

700: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(l_loop_index).last_updated_by;
701: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(l_loop_index).last_update_login;
702: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(l_loop_index).last_update_date;
703: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(l_loop_index).lock_control;
704: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation:=l_line_tbl(l_loop_index).operation;
705:
706: IF l_debug_level > 0 THEN
707: oe_debug_pub.add( 'IN BOOKING , AFTER UPDATE LINE GLOBAL PICTURE' ) ;
708: END IF;

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

706: IF l_debug_level > 0 THEN
707: oe_debug_pub.add( 'IN BOOKING , AFTER UPDATE LINE GLOBAL PICTURE' ) ;
708: END IF;
709: IF l_debug_level > 0 THEN
710: oe_debug_pub.add( 'GLOBAL LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;
711: END IF;
712: IF l_debug_level > 0 THEN
713: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
714: END IF;

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

709: IF l_debug_level > 0 THEN
710: oe_debug_pub.add( 'GLOBAL LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;
711: END IF;
712: IF l_debug_level > 0 THEN
713: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
714: END IF;
715: IF l_debug_level > 0 THEN
716: oe_debug_pub.add( 'GLOBAL OLD LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;
717: END IF;

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

712: IF l_debug_level > 0 THEN
713: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
714: END IF;
715: IF l_debug_level > 0 THEN
716: oe_debug_pub.add( 'GLOBAL OLD LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;
717: END IF;
718: IF l_debug_level > 0 THEN
719: oe_debug_pub.add( 'GLOBAL LINE OPERATION IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OPERATION , 1 ) ;
720: END IF;

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

715: IF l_debug_level > 0 THEN
716: oe_debug_pub.add( 'GLOBAL OLD LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;
717: END IF;
718: IF l_debug_level > 0 THEN
719: oe_debug_pub.add( 'GLOBAL LINE OPERATION IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OPERATION , 1 ) ;
720: END IF;
721: END IF ; /* global entity index null check */
722:
723: -- bug 2821129

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

724:
725: oe_debug_pub.add('p_header_id is '|| p_header_id);
726: oe_debug_pub.add('line_id is '|| l_line_tbl(l_loop_index).line_id);
727:
728: oe_debug_pub.add('in OEXUBOKB start g line adj tbl count is '|| OE_ORDER_UTIL.g_line_adj_tbl.count);
729:
730: OE_LINE_ADJ_UTIL.Query_Rows
731: (
732: p_line_id => l_line_tbl(l_loop_index).line_id

Line 744: OE_ORDER_UTIL.Update_Global_Picture

740: l_in_loop_index := l_line_adj_tbl.FIRST;
741:
742: While l_in_loop_index is not NULL LOOP
743:
744: OE_ORDER_UTIL.Update_Global_Picture
745: (p_Upd_New_Rec_If_Exists =>FALSE
746: , p_line_adj_id => l_line_adj_tbl(l_in_loop_index).price_adjustment_id
747: , x_index => l_notify_index
748: , x_return_status => l_return_status);

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

746: , p_line_adj_id => l_line_adj_tbl(l_in_loop_index).price_adjustment_id
747: , x_index => l_notify_index
748: , x_return_status => l_return_status);
749:
750: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index) := l_line_adj_tbl(l_in_loop_index);
751: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation := OE_GLOBALS.G_OPR_CREATE;
752: 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);
753: oe_debug_pub.add('in OEXUBOKB after insert into global table, operation is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation);
754:

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

747: , x_index => l_notify_index
748: , x_return_status => l_return_status);
749:
750: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index) := l_line_adj_tbl(l_in_loop_index);
751: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation := OE_GLOBALS.G_OPR_CREATE;
752: 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);
753: oe_debug_pub.add('in OEXUBOKB after insert into global table, operation is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation);
754:
755: l_in_loop_index := l_line_adj_tbl.NEXT(l_in_loop_index);

Line 752: 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);

748: , x_return_status => l_return_status);
749:
750: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index) := l_line_adj_tbl(l_in_loop_index);
751: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation := OE_GLOBALS.G_OPR_CREATE;
752: 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);
753: oe_debug_pub.add('in OEXUBOKB after insert into global table, operation is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation);
754:
755: l_in_loop_index := l_line_adj_tbl.NEXT(l_in_loop_index);
756:

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

749:
750: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index) := l_line_adj_tbl(l_in_loop_index);
751: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation := OE_GLOBALS.G_OPR_CREATE;
752: 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);
753: oe_debug_pub.add('in OEXUBOKB after insert into global table, operation is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation);
754:
755: l_in_loop_index := l_line_adj_tbl.NEXT(l_in_loop_index);
756:
757: END LOOP;

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

755: l_in_loop_index := l_line_adj_tbl.NEXT(l_in_loop_index);
756:
757: END LOOP;
758:
759: oe_debug_pub.add('in OEXUBOKB at end g line adj tbl count is '|| OE_ORDER_UTIL.g_line_adj_tbl.count);
760:
761: l_loop_index := l_line_tbl.NEXT(l_loop_index);
762:
763: END LOOP outer; -- over each line to update global picture

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

1186: );
1187:
1188: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1189: OE_Header_Scredit_Util.Redefault_Sales_Group(p_header_id=>p_header_id,
1190: p_date=> nvl(OE_ORDER_UTIL.g_header_rec.booked_date,SYSDATE));
1191: END IF;
1192:
1193: -- if unexpected error, then go to exception handler. If there
1194: -- were validation failures, then it is expected error therefore

Line 1487: l_nameVal_tbl OE_ORDER_UTIL.nameVal_Tbl_Type; -- added for 13536089

1483: l_change_sequence VARCHAR2(50);
1484: l_source_document_type_id NUMBER;
1485: l_source_document_id NUMBER;
1486: l_event_name VARCHAR2(100); -- added for 13536089
1487: l_nameVal_tbl OE_ORDER_UTIL.nameVal_Tbl_Type; -- added for 13536089
1488: l_count NUMBER; -- added for 13536089
1489: l_flow_status_code VARCHAR2(100); --added for 13536089. modified for 14352532
1490: CURSOR book_eligible IS
1491: SELECT 'Y'

Line 1615: OE_ORDER_UTIL.Lock_Order_Object

1611: -- This will prevent another user from working on the same order
1612: -- and needs to be done before calling the wf_engine as the workflow
1613: -- engine will hang if another user is trying to book the same order
1614:
1615: OE_ORDER_UTIL.Lock_Order_Object
1616: (p_header_id => p_header_id
1617: ,x_return_status => x_return_status
1618: );
1619: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1712: oe_order_util.raise_business_event( p_header_id => p_header_id,

1708:
1709: l_nameVal_tbl(l_count).name := 'PROCESS_NAME';
1710: l_nameVal_tbl(l_count).value := 'BOOK_ORDER';
1711:
1712: oe_order_util.raise_business_event( p_header_id => p_header_id,
1713: p_status=>l_flow_status_code,
1714: p_event_name => 'oracle.apps.ont.oip.processfailure.update',
1715: p_nameVal_tbl => l_nameVal_tbl);
1716: -- END OF FIX 13536089