782: THEN
783: IF g_debug_call > 0 THEN
784: G_DEBUG_MSG := G_DEBUG_MSG || '22,';
785: END IF;
786: OE_ORDER_UTIL.Update_Global_Picture
787: (p_Upd_New_Rec_If_Exists =>False,
788: p_header_id => l_line_rec.header_id,
789: p_old_line_rec => l_old_line_tbl(1),
790: p_line_rec => l_line_tbl(1),
809:
810: --update Global Picture directly
811:
812:
813: OE_ORDER_UTIL.g_old_line_tbl(l_index)
814: := l_old_line_tbl(1);
815: OE_ORDER_UTIL.g_line_tbl(l_index)
816: := OE_ORDER_UTIL.g_old_line_tbl(l_index);
817: OE_ORDER_UTIL.g_line_tbl(l_index).line_id
811:
812:
813: OE_ORDER_UTIL.g_old_line_tbl(l_index)
814: := l_old_line_tbl(1);
815: OE_ORDER_UTIL.g_line_tbl(l_index)
816: := OE_ORDER_UTIL.g_old_line_tbl(l_index);
817: OE_ORDER_UTIL.g_line_tbl(l_index).line_id
818: := l_line_tbl(1).line_id;
819: OE_ORDER_UTIL.g_line_tbl(l_index).header_id
812:
813: OE_ORDER_UTIL.g_old_line_tbl(l_index)
814: := l_old_line_tbl(1);
815: OE_ORDER_UTIL.g_line_tbl(l_index)
816: := OE_ORDER_UTIL.g_old_line_tbl(l_index);
817: OE_ORDER_UTIL.g_line_tbl(l_index).line_id
818: := l_line_tbl(1).line_id;
819: OE_ORDER_UTIL.g_line_tbl(l_index).header_id
820: := l_line_tbl(1).header_id;
813: OE_ORDER_UTIL.g_old_line_tbl(l_index)
814: := l_old_line_tbl(1);
815: OE_ORDER_UTIL.g_line_tbl(l_index)
816: := OE_ORDER_UTIL.g_old_line_tbl(l_index);
817: OE_ORDER_UTIL.g_line_tbl(l_index).line_id
818: := l_line_tbl(1).line_id;
819: OE_ORDER_UTIL.g_line_tbl(l_index).header_id
820: := l_line_tbl(1).header_id;
821: OE_ORDER_UTIL.g_line_tbl(l_index).flow_status_code
815: OE_ORDER_UTIL.g_line_tbl(l_index)
816: := OE_ORDER_UTIL.g_old_line_tbl(l_index);
817: OE_ORDER_UTIL.g_line_tbl(l_index).line_id
818: := l_line_tbl(1).line_id;
819: OE_ORDER_UTIL.g_line_tbl(l_index).header_id
820: := l_line_tbl(1).header_id;
821: OE_ORDER_UTIL.g_line_tbl(l_index).flow_status_code
822: := l_line_tbl(1).flow_status_code;
823: OE_ORDER_UTIL.g_line_tbl(l_index).shipped_quantity
817: OE_ORDER_UTIL.g_line_tbl(l_index).line_id
818: := l_line_tbl(1).line_id;
819: OE_ORDER_UTIL.g_line_tbl(l_index).header_id
820: := l_line_tbl(1).header_id;
821: OE_ORDER_UTIL.g_line_tbl(l_index).flow_status_code
822: := l_line_tbl(1).flow_status_code;
823: OE_ORDER_UTIL.g_line_tbl(l_index).shipped_quantity
824: := l_line_tbl(1).shipped_quantity;
825: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date
819: OE_ORDER_UTIL.g_line_tbl(l_index).header_id
820: := l_line_tbl(1).header_id;
821: OE_ORDER_UTIL.g_line_tbl(l_index).flow_status_code
822: := l_line_tbl(1).flow_status_code;
823: OE_ORDER_UTIL.g_line_tbl(l_index).shipped_quantity
824: := l_line_tbl(1).shipped_quantity;
825: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date
826: := SYSDATE;
827: OE_ORDER_UTIL.g_line_tbl(l_index).last_updated_by
821: OE_ORDER_UTIL.g_line_tbl(l_index).flow_status_code
822: := l_line_tbl(1).flow_status_code;
823: OE_ORDER_UTIL.g_line_tbl(l_index).shipped_quantity
824: := l_line_tbl(1).shipped_quantity;
825: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date
826: := SYSDATE;
827: OE_ORDER_UTIL.g_line_tbl(l_index).last_updated_by
828: := FND_GLOBAL.USER_ID;
829: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_login
823: OE_ORDER_UTIL.g_line_tbl(l_index).shipped_quantity
824: := l_line_tbl(1).shipped_quantity;
825: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date
826: := SYSDATE;
827: OE_ORDER_UTIL.g_line_tbl(l_index).last_updated_by
828: := FND_GLOBAL.USER_ID;
829: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_login
830: := FND_GLOBAL.LOGIN_ID;
831:
825: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date
826: := SYSDATE;
827: OE_ORDER_UTIL.g_line_tbl(l_index).last_updated_by
828: := FND_GLOBAL.USER_ID;
829: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_login
830: := FND_GLOBAL.LOGIN_ID;
831:
832: IF l_debug_level > 0 THEN
833: oe_debug_pub.add
831:
832: IF l_debug_level > 0 THEN
833: oe_debug_pub.add
834: ('global flow status code after update: '
835: || OE_ORDER_UTIL.G_LINE_TBL( L_INDEX ).FLOW_STATUS_CODE ,1);
836: END IF;
837:
838: END IF; -- if index is not null
839:
5920: END IF;
5921: WHILE I is not NULL
5922: LOOP
5923:
5924: OE_ORDER_UTIL.Update_Global_Picture
5925: (p_Upd_New_Rec_If_Exists => False,
5926: p_header_id => l_line_tbl(I).header_id,
5927: p_old_line_rec => l_old_line_tbl(I),
5928: p_line_rec => l_line_tbl(I),
5942:
5943: IF J IS NOT NULL THEN
5944:
5945: --update Global Picture directly
5946: OE_ORDER_UTIL.g_old_line_tbl(J) := l_old_line_tbl(I);
5947: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_tbl(I).line_id;
5948: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_tbl(I).header_id;
5949:
5950: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5943: IF J IS NOT NULL THEN
5944:
5945: --update Global Picture directly
5946: OE_ORDER_UTIL.g_old_line_tbl(J) := l_old_line_tbl(I);
5947: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_tbl(I).line_id;
5948: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_tbl(I).header_id;
5949:
5950: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5951: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5944:
5945: --update Global Picture directly
5946: OE_ORDER_UTIL.g_old_line_tbl(J) := l_old_line_tbl(I);
5947: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_tbl(I).line_id;
5948: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_tbl(I).header_id;
5949:
5950: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5951: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5952: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5946: OE_ORDER_UTIL.g_old_line_tbl(J) := l_old_line_tbl(I);
5947: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_tbl(I).line_id;
5948: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_tbl(I).header_id;
5949:
5950: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5951: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5952: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5953:
5954: OE_ORDER_UTIL.g_line_tbl(J)
5947: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_tbl(I).line_id;
5948: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_tbl(I).header_id;
5949:
5950: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5951: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5952: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5953:
5954: OE_ORDER_UTIL.g_line_tbl(J)
5955: := OE_ORDER_UTIL.g_old_line_tbl(J);
5948: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_tbl(I).header_id;
5949:
5950: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5951: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5952: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5953:
5954: OE_ORDER_UTIL.g_line_tbl(J)
5955: := OE_ORDER_UTIL.g_old_line_tbl(J);
5956: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code
5950: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5951: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5952: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5953:
5954: OE_ORDER_UTIL.g_line_tbl(J)
5955: := OE_ORDER_UTIL.g_old_line_tbl(J);
5956: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code
5957: := l_line_tbl(I).flow_status_code;
5958: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity
5951: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5952: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5953:
5954: OE_ORDER_UTIL.g_line_tbl(J)
5955: := OE_ORDER_UTIL.g_old_line_tbl(J);
5956: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code
5957: := l_line_tbl(I).flow_status_code;
5958: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity
5959: := l_line_tbl(I).shipped_quantity;
5952: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5953:
5954: OE_ORDER_UTIL.g_line_tbl(J)
5955: := OE_ORDER_UTIL.g_old_line_tbl(J);
5956: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code
5957: := l_line_tbl(I).flow_status_code;
5958: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity
5959: := l_line_tbl(I).shipped_quantity;
5960: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity2 -- INVCONV
5954: OE_ORDER_UTIL.g_line_tbl(J)
5955: := OE_ORDER_UTIL.g_old_line_tbl(J);
5956: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code
5957: := l_line_tbl(I).flow_status_code;
5958: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity
5959: := l_line_tbl(I).shipped_quantity;
5960: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity2 -- INVCONV
5961: := l_line_tbl(I).shipped_quantity2;
5962:
5956: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code
5957: := l_line_tbl(I).flow_status_code;
5958: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity
5959: := l_line_tbl(I).shipped_quantity;
5960: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity2 -- INVCONV
5961: := l_line_tbl(I).shipped_quantity2;
5962:
5963:
5964: IF l_debug_level > 0 THEN
5963:
5964: IF l_debug_level > 0 THEN
5965: oe_debug_pub.add
5966: ('AFTER UPDATE GLOBAL FLOW_STATUS_CODE IS: '
5967: || OE_ORDER_UTIL.G_LINE_TBL( J ).FLOW_STATUS_CODE ,1);
5968: END IF;
5969:
5970: END IF; -- if index is not null
5971: