780: THEN
781: IF g_debug_call > 0 THEN
782: G_DEBUG_MSG := G_DEBUG_MSG || '22,';
783: END IF;
784: OE_ORDER_UTIL.Update_Global_Picture
785: (p_Upd_New_Rec_If_Exists =>False,
786: p_header_id => l_line_rec.header_id,
787: p_old_line_rec => l_old_line_tbl(1),
788: p_line_rec => l_line_tbl(1),
807:
808: --update Global Picture directly
809:
810:
811: OE_ORDER_UTIL.g_old_line_tbl(l_index)
812: := l_old_line_tbl(1);
813: OE_ORDER_UTIL.g_line_tbl(l_index)
814: := OE_ORDER_UTIL.g_old_line_tbl(l_index);
815: OE_ORDER_UTIL.g_line_tbl(l_index).line_id
809:
810:
811: OE_ORDER_UTIL.g_old_line_tbl(l_index)
812: := l_old_line_tbl(1);
813: OE_ORDER_UTIL.g_line_tbl(l_index)
814: := OE_ORDER_UTIL.g_old_line_tbl(l_index);
815: OE_ORDER_UTIL.g_line_tbl(l_index).line_id
816: := l_line_tbl(1).line_id;
817: OE_ORDER_UTIL.g_line_tbl(l_index).header_id
810:
811: OE_ORDER_UTIL.g_old_line_tbl(l_index)
812: := l_old_line_tbl(1);
813: OE_ORDER_UTIL.g_line_tbl(l_index)
814: := OE_ORDER_UTIL.g_old_line_tbl(l_index);
815: OE_ORDER_UTIL.g_line_tbl(l_index).line_id
816: := l_line_tbl(1).line_id;
817: OE_ORDER_UTIL.g_line_tbl(l_index).header_id
818: := l_line_tbl(1).header_id;
811: OE_ORDER_UTIL.g_old_line_tbl(l_index)
812: := l_old_line_tbl(1);
813: OE_ORDER_UTIL.g_line_tbl(l_index)
814: := OE_ORDER_UTIL.g_old_line_tbl(l_index);
815: OE_ORDER_UTIL.g_line_tbl(l_index).line_id
816: := l_line_tbl(1).line_id;
817: OE_ORDER_UTIL.g_line_tbl(l_index).header_id
818: := l_line_tbl(1).header_id;
819: OE_ORDER_UTIL.g_line_tbl(l_index).flow_status_code
813: OE_ORDER_UTIL.g_line_tbl(l_index)
814: := OE_ORDER_UTIL.g_old_line_tbl(l_index);
815: OE_ORDER_UTIL.g_line_tbl(l_index).line_id
816: := l_line_tbl(1).line_id;
817: OE_ORDER_UTIL.g_line_tbl(l_index).header_id
818: := l_line_tbl(1).header_id;
819: OE_ORDER_UTIL.g_line_tbl(l_index).flow_status_code
820: := l_line_tbl(1).flow_status_code;
821: OE_ORDER_UTIL.g_line_tbl(l_index).shipped_quantity
815: OE_ORDER_UTIL.g_line_tbl(l_index).line_id
816: := l_line_tbl(1).line_id;
817: OE_ORDER_UTIL.g_line_tbl(l_index).header_id
818: := l_line_tbl(1).header_id;
819: OE_ORDER_UTIL.g_line_tbl(l_index).flow_status_code
820: := l_line_tbl(1).flow_status_code;
821: OE_ORDER_UTIL.g_line_tbl(l_index).shipped_quantity
822: := l_line_tbl(1).shipped_quantity;
823: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date
817: OE_ORDER_UTIL.g_line_tbl(l_index).header_id
818: := l_line_tbl(1).header_id;
819: OE_ORDER_UTIL.g_line_tbl(l_index).flow_status_code
820: := l_line_tbl(1).flow_status_code;
821: OE_ORDER_UTIL.g_line_tbl(l_index).shipped_quantity
822: := l_line_tbl(1).shipped_quantity;
823: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date
824: := SYSDATE;
825: OE_ORDER_UTIL.g_line_tbl(l_index).last_updated_by
819: OE_ORDER_UTIL.g_line_tbl(l_index).flow_status_code
820: := l_line_tbl(1).flow_status_code;
821: OE_ORDER_UTIL.g_line_tbl(l_index).shipped_quantity
822: := l_line_tbl(1).shipped_quantity;
823: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date
824: := SYSDATE;
825: OE_ORDER_UTIL.g_line_tbl(l_index).last_updated_by
826: := FND_GLOBAL.USER_ID;
827: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_login
821: OE_ORDER_UTIL.g_line_tbl(l_index).shipped_quantity
822: := l_line_tbl(1).shipped_quantity;
823: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date
824: := SYSDATE;
825: OE_ORDER_UTIL.g_line_tbl(l_index).last_updated_by
826: := FND_GLOBAL.USER_ID;
827: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_login
828: := FND_GLOBAL.LOGIN_ID;
829:
823: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date
824: := SYSDATE;
825: OE_ORDER_UTIL.g_line_tbl(l_index).last_updated_by
826: := FND_GLOBAL.USER_ID;
827: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_login
828: := FND_GLOBAL.LOGIN_ID;
829:
830: IF l_debug_level > 0 THEN
831: oe_debug_pub.add
829:
830: IF l_debug_level > 0 THEN
831: oe_debug_pub.add
832: ('global flow status code after update: '
833: || OE_ORDER_UTIL.G_LINE_TBL( L_INDEX ).FLOW_STATUS_CODE ,1);
834: END IF;
835:
836: END IF; -- if index is not null
837:
5895: END IF;
5896: WHILE I is not NULL
5897: LOOP
5898:
5899: OE_ORDER_UTIL.Update_Global_Picture
5900: (p_Upd_New_Rec_If_Exists => False,
5901: p_header_id => l_line_tbl(I).header_id,
5902: p_old_line_rec => l_old_line_tbl(I),
5903: p_line_rec => l_line_tbl(I),
5917:
5918: IF J IS NOT NULL THEN
5919:
5920: --update Global Picture directly
5921: OE_ORDER_UTIL.g_old_line_tbl(J) := l_old_line_tbl(I);
5922: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_tbl(I).line_id;
5923: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_tbl(I).header_id;
5924:
5925: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5918: IF J IS NOT NULL THEN
5919:
5920: --update Global Picture directly
5921: OE_ORDER_UTIL.g_old_line_tbl(J) := l_old_line_tbl(I);
5922: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_tbl(I).line_id;
5923: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_tbl(I).header_id;
5924:
5925: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5926: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5919:
5920: --update Global Picture directly
5921: OE_ORDER_UTIL.g_old_line_tbl(J) := l_old_line_tbl(I);
5922: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_tbl(I).line_id;
5923: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_tbl(I).header_id;
5924:
5925: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5926: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5927: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5921: OE_ORDER_UTIL.g_old_line_tbl(J) := l_old_line_tbl(I);
5922: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_tbl(I).line_id;
5923: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_tbl(I).header_id;
5924:
5925: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5926: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5927: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5928:
5929: OE_ORDER_UTIL.g_line_tbl(J)
5922: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_tbl(I).line_id;
5923: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_tbl(I).header_id;
5924:
5925: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5926: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5927: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5928:
5929: OE_ORDER_UTIL.g_line_tbl(J)
5930: := OE_ORDER_UTIL.g_old_line_tbl(J);
5923: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_tbl(I).header_id;
5924:
5925: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5926: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5927: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5928:
5929: OE_ORDER_UTIL.g_line_tbl(J)
5930: := OE_ORDER_UTIL.g_old_line_tbl(J);
5931: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code
5925: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;
5926: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5927: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5928:
5929: OE_ORDER_UTIL.g_line_tbl(J)
5930: := OE_ORDER_UTIL.g_old_line_tbl(J);
5931: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code
5932: := l_line_tbl(I).flow_status_code;
5933: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity
5926: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
5927: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5928:
5929: OE_ORDER_UTIL.g_line_tbl(J)
5930: := OE_ORDER_UTIL.g_old_line_tbl(J);
5931: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code
5932: := l_line_tbl(I).flow_status_code;
5933: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity
5934: := l_line_tbl(I).shipped_quantity;
5927: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_ID;
5928:
5929: OE_ORDER_UTIL.g_line_tbl(J)
5930: := OE_ORDER_UTIL.g_old_line_tbl(J);
5931: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code
5932: := l_line_tbl(I).flow_status_code;
5933: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity
5934: := l_line_tbl(I).shipped_quantity;
5935: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity2 -- INVCONV
5929: OE_ORDER_UTIL.g_line_tbl(J)
5930: := OE_ORDER_UTIL.g_old_line_tbl(J);
5931: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code
5932: := l_line_tbl(I).flow_status_code;
5933: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity
5934: := l_line_tbl(I).shipped_quantity;
5935: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity2 -- INVCONV
5936: := l_line_tbl(I).shipped_quantity2;
5937:
5931: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code
5932: := l_line_tbl(I).flow_status_code;
5933: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity
5934: := l_line_tbl(I).shipped_quantity;
5935: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity2 -- INVCONV
5936: := l_line_tbl(I).shipped_quantity2;
5937:
5938:
5939: IF l_debug_level > 0 THEN
5938:
5939: IF l_debug_level > 0 THEN
5940: oe_debug_pub.add
5941: ('AFTER UPDATE GLOBAL FLOW_STATUS_CODE IS: '
5942: || OE_ORDER_UTIL.G_LINE_TBL( J ).FLOW_STATUS_CODE ,1);
5943: END IF;
5944:
5945: END IF; -- if index is not null
5946: