DBA Data[Home] [Help]

APPS.OE_LINE_FULLFILL dependencies on FND_GLOBAL

Line 736: l_user NUMBER := NVL(OE_STANDARD_WF.G_USER_ID, FND_GLOBAL.USER_ID); --3169637

732: l_fulfilled_quantity NUMBER;
733: l_fulfilled_quantity2 NUMBER; -- 5126873
734: l_line_rec OE_Order_Pub.Line_Rec_Type; /* 2048753 */
735: l_notify_index NUMBER;
736: l_user NUMBER := NVL(OE_STANDARD_WF.G_USER_ID, FND_GLOBAL.USER_ID); --3169637
737: -- Changes for AFD
738: l_ordered_date date;
739: l_actual_fulfillment_date date;
740: l number;

Line 914: l_line_tbl(1).last_update_login := FND_GLOBAL.LOGIN_ID;

910:
911: l_line_tbl(1).fulfillment_date := SYSDATE;
912: l_line_tbl(1).last_update_date := SYSDATE;
913: l_line_tbl(1).last_updated_by := l_user; -- 3169637
914: l_line_tbl(1).last_update_login := FND_GLOBAL.LOGIN_ID;
915: l_line_tbl(1).lock_control := l_line_tbl(1).lock_control + 1;
916: /* next two lines: 2048753 */
917: l_line_tbl(1).service_start_date := l_line_rec.service_start_date;
918: l_line_tbl(1).service_end_date := l_line_rec.service_end_date;

Line 968: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;

964:
965: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := SYSDATE;
966: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
967: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
968: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
969: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
970: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;
971: /* changes for AFD */
972: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;

Line 990: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

986: FULFILLED_QUANTITY2 = l_fulfilled_quantity2, -- 5126873
987: FULFILLMENT_DATE = SYSDATE,
988: LAST_UPDATE_DATE = SYSDATE,
989: LAST_UPDATED_BY = l_user, -- 3169637
990: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
991: /* next two lines: 2048753 */
992: SERVICE_START_DATE = l_line_rec.service_start_date,
993: SERVICE_END_DATE = l_line_rec.service_end_date,
994: ACTUAL_FULFILLMENT_DATE = l_actual_fulfillment_date,

Line 1154: l_line_tbl(l_index).last_update_login := FND_GLOBAL.LOGIN_ID;

1150: END IF;
1151: l_line_tbl(l_index).fulfillment_date := p_line_tbl(l_index).fulfillment_date;
1152: l_line_tbl(l_index).last_update_date := SYSDATE;
1153: l_line_tbl(l_index).last_updated_by := l_user; -- 3169637
1154: l_line_tbl(l_index).last_update_login := FND_GLOBAL.LOGIN_ID;
1155: l_line_tbl(l_index).lock_control := l_line_tbl(l_index).lock_control + 1;
1156:
1157: -- Changes for AFD
1158: l_line_tbl(l_index).actual_fulfillment_date := l_actual_fulfillment_date;

Line 1222: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;

1218: END IF;
1219: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := p_line_tbl(l_index).fulfillment_date;
1220: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
1221: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
1222: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
1223: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
1224: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;
1225: -- Changes for AFD
1226: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;

Line 1275: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

1271: FULFILLED_QUANTITY2 = p_line_tbl(l_index).fulfilled_quantity2, -- 5126873
1272: FULFILLMENT_DATE = p_line_tbl(l_index).fulfillment_date,
1273: LAST_UPDATE_DATE = SYSDATE,
1274: LAST_UPDATED_BY = l_user, -- 3169637
1275: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1276: SERVICE_START_DATE = l_line_rec.service_start_date,
1277: SERVICE_END_DATE = l_line_rec.service_end_date,
1278: ACTUAL_FULFILLMENT_DATE = l_actual_fulfillment_date,
1279: LOCK_CONTROL = LOCK_CONTROL+1

Line 1338: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

1334: FULFILLED_QUANTITY2 = p_line_tbl(l_index).fulfilled_quantity2, -- 5126873
1335: FULFILLMENT_DATE = p_line_tbl(l_index).fulfillment_date,
1336: LAST_UPDATE_DATE = SYSDATE,
1337: LAST_UPDATED_BY = l_user, -- 3169637
1338: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1339: ACTUAL_FULFILLMENT_DATE = l_actual_fulfillment_date,
1340: LOCK_CONTROL = LOCK_CONTROL+1
1341: WHERE LINE_ID = p_line_tbl(l_index).line_id;
1342: