DBA Data[Home] [Help]

APPS.OE_SHIPPING_INTEGRATION_PVT dependencies on OE_ORDER_UTIL

Line 786: OE_ORDER_UTIL.Update_Global_Picture

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),

Line 813: OE_ORDER_UTIL.g_old_line_tbl(l_index)

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

Line 815: OE_ORDER_UTIL.g_line_tbl(l_index)

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

Line 816: := OE_ORDER_UTIL.g_old_line_tbl(l_index);

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;

Line 817: OE_ORDER_UTIL.g_line_tbl(l_index).line_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

Line 819: OE_ORDER_UTIL.g_line_tbl(l_index).header_id

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

Line 821: OE_ORDER_UTIL.g_line_tbl(l_index).flow_status_code

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

Line 823: OE_ORDER_UTIL.g_line_tbl(l_index).shipped_quantity

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

Line 825: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date

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

Line 827: OE_ORDER_UTIL.g_line_tbl(l_index).last_updated_by

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:

Line 829: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_login

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

Line 835: || OE_ORDER_UTIL.G_LINE_TBL( L_INDEX ).FLOW_STATUS_CODE ,1);

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:

Line 5924: OE_ORDER_UTIL.Update_Global_Picture

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),

Line 5946: OE_ORDER_UTIL.g_old_line_tbl(J) := l_old_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;

Line 5947: OE_ORDER_UTIL.g_line_tbl(J).line_id := l_line_tbl(I).line_id;

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;

Line 5948: OE_ORDER_UTIL.g_line_tbl(J).header_id:= l_line_tbl(I).header_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;

Line 5950: OE_ORDER_UTIL.g_line_tbl(J).last_update_date := SYSDATE;

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)

Line 5951: OE_ORDER_UTIL.g_line_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;

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);

Line 5952: OE_ORDER_UTIL.g_line_tbl(J).last_update_login:= FND_GLOBAL.LOGIN_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);
5956: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code

Line 5954: OE_ORDER_UTIL.g_line_tbl(J)

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

Line 5955: := OE_ORDER_UTIL.g_old_line_tbl(J);

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;

Line 5956: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code

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

Line 5958: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity

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:

Line 5960: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity2 -- INVCONV

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

Line 5967: || OE_ORDER_UTIL.G_LINE_TBL( J ).FLOW_STATUS_CODE ,1);

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: