DBA Data[Home] [Help]

APPS.OE_SHIPPING_INTEGRATION_PVT dependencies on OE_ORDER_UTIL

Line 784: OE_ORDER_UTIL.Update_Global_Picture

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

Line 811: OE_ORDER_UTIL.g_old_line_tbl(l_index)

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

Line 813: OE_ORDER_UTIL.g_line_tbl(l_index)

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

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

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;

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

Line 817: OE_ORDER_UTIL.g_line_tbl(l_index).header_id

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

Line 819: OE_ORDER_UTIL.g_line_tbl(l_index).flow_status_code

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

Line 821: OE_ORDER_UTIL.g_line_tbl(l_index).shipped_quantity

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

Line 823: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date

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

Line 825: OE_ORDER_UTIL.g_line_tbl(l_index).last_updated_by

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:

Line 827: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_login

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

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

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:

Line 5899: OE_ORDER_UTIL.Update_Global_Picture

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

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

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

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;

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

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

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)

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

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

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

Line 5929: OE_ORDER_UTIL.g_line_tbl(J)

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

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

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;

Line 5931: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code

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

Line 5933: OE_ORDER_UTIL.g_line_tbl(J).shipped_quantity

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:

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

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

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

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: