DBA Data[Home] [Help]

APPS.OE_ORDER_CLOSE_UTIL dependencies on FND_GLOBAL

Line 227: l_header_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637;

223: l_header_rec.flow_status_code := 'CANCELLED';
224: ELSE
225: l_header_rec.flow_status_code := 'CLOSED';
226: END IF;
227: l_header_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637;
228: l_header_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
229: l_header_rec.last_update_date := SYSDATE;
230: l_header_rec.lock_control := l_header_rec.lock_control + 1;
231:

Line 228: l_header_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

224: ELSE
225: l_header_rec.flow_status_code := 'CLOSED';
226: END IF;
227: l_header_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637;
228: l_header_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
229: l_header_rec.last_update_date := SYSDATE;
230: l_header_rec.lock_control := l_header_rec.lock_control + 1;
231:
232: UPDATE oe_order_headers

Line 655: , last_updated_by = NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID)

651: IF l_pending_acceptance = 'Y' THEN
652:
653: UPDATE oe_order_lines
654: SET flow_status_code = 'POST-BILLING_ACCEPTANCE'
655: , last_updated_by = NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID)
656: , last_update_login = FND_GLOBAL.LOGIN_ID
657: , last_update_date = SYSDATE
658: , lock_control = l_old_line_tbl(1).lock_control + 1
659: WHERE line_id = p_line_id;

Line 656: , last_update_login = FND_GLOBAL.LOGIN_ID

652:
653: UPDATE oe_order_lines
654: SET flow_status_code = 'POST-BILLING_ACCEPTANCE'
655: , last_updated_by = NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID)
656: , last_update_login = FND_GLOBAL.LOGIN_ID
657: , last_update_date = SYSDATE
658: , lock_control = l_old_line_tbl(1).lock_control + 1
659: WHERE line_id = p_line_id;
660:

Line 677: , last_updated_by = NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID) -- 3169637

673: SET open_flag = 'N'
674: , calculate_price_flag = 'N'
675: , flow_status_code = DECODE(l_old_line_tbl(1).cancelled_flag,'Y',
676: 'CANCELLED','CLOSED')
677: , last_updated_by = NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID) -- 3169637
678: , last_update_login = FND_GLOBAL.LOGIN_ID
679: , last_update_date = SYSDATE
680: , lock_control = l_old_line_tbl(1).lock_control + 1
681: WHERE line_id = p_line_id;

Line 678: , last_update_login = FND_GLOBAL.LOGIN_ID

674: , calculate_price_flag = 'N'
675: , flow_status_code = DECODE(l_old_line_tbl(1).cancelled_flag,'Y',
676: 'CANCELLED','CLOSED')
677: , last_updated_by = NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID) -- 3169637
678: , last_update_login = FND_GLOBAL.LOGIN_ID
679: , last_update_date = SYSDATE
680: , lock_control = l_old_line_tbl(1).lock_control + 1
681: WHERE line_id = p_line_id;
682:

Line 702: l_line_tbl(1).last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID);

698: IF l_pending_acceptance= 'Y' THEN
699:
700: l_line_tbl(1) := l_old_line_tbl(1);
701: l_line_tbl(1).flow_status_code := 'POST-BILLING_ACCEPTANCE';
702: l_line_tbl(1).last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID);
703: l_line_tbl(1).last_update_login := FND_GLOBAL.LOGIN_ID;
704: l_line_tbl(1).last_update_date := SYSDATE;
705: l_line_tbl(1).lock_control := l_line_tbl(1).lock_control + 1;
706: ELSE

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

699:
700: l_line_tbl(1) := l_old_line_tbl(1);
701: l_line_tbl(1).flow_status_code := 'POST-BILLING_ACCEPTANCE';
702: l_line_tbl(1).last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID);
703: l_line_tbl(1).last_update_login := FND_GLOBAL.LOGIN_ID;
704: l_line_tbl(1).last_update_date := SYSDATE;
705: l_line_tbl(1).lock_control := l_line_tbl(1).lock_control + 1;
706: ELSE
707: --Customer Acceptance End

Line 716: l_line_tbl(1).last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID);

712: l_line_tbl(1).flow_status_code := 'CANCELLED';
713: ELSE
714: l_line_tbl(1).flow_status_code := 'CLOSED';
715: END IF;
716: l_line_tbl(1).last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID);
717: l_line_tbl(1).last_update_login := FND_GLOBAL.LOGIN_ID;
718: l_line_tbl(1).last_update_date := SYSDATE;
719: l_line_tbl(1).lock_control := l_line_tbl(1).lock_control + 1;
720: END IF;

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

713: ELSE
714: l_line_tbl(1).flow_status_code := 'CLOSED';
715: END IF;
716: l_line_tbl(1).last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID);
717: l_line_tbl(1).last_update_login := FND_GLOBAL.LOGIN_ID;
718: l_line_tbl(1).last_update_date := SYSDATE;
719: l_line_tbl(1).lock_control := l_line_tbl(1).lock_control + 1;
720: END IF;
721: