DBA Data[Home] [Help]

APPS.FA_VENDORMERGE_GRP dependencies on FA_MAINT_SCHEDULE_DTL

Line 172: -- Updating FA_MAINT_SCHEDULE_DTL : VENDOR_ID, VENDOR_NAME

168: set VENDOR_ID = p_vendor_id
169: where VENDOR_ID = p_dup_vendor_id;
170:
171: -- **********************************************************
172: -- Updating FA_MAINT_SCHEDULE_DTL : VENDOR_ID, VENDOR_NAME
173: -- **********************************************************
174: l_location := 'FA_MAINT_SCHEDULE_DTL';
175: update FA_MAINT_SCHEDULE_DTL
176: set VENDOR_ID = p_vendor_id

Line 174: l_location := 'FA_MAINT_SCHEDULE_DTL';

170:
171: -- **********************************************************
172: -- Updating FA_MAINT_SCHEDULE_DTL : VENDOR_ID, VENDOR_NAME
173: -- **********************************************************
174: l_location := 'FA_MAINT_SCHEDULE_DTL';
175: update FA_MAINT_SCHEDULE_DTL
176: set VENDOR_ID = p_vendor_id
177: , VENDOR_NAME = decode(VENDOR_NAME, NULL, NULL, l_vendor_name)
178: , VENDOR_NUMBER = decode(VENDOR_NUMBER, NULL, NULL, p_segment1)

Line 175: update FA_MAINT_SCHEDULE_DTL

171: -- **********************************************************
172: -- Updating FA_MAINT_SCHEDULE_DTL : VENDOR_ID, VENDOR_NAME
173: -- **********************************************************
174: l_location := 'FA_MAINT_SCHEDULE_DTL';
175: update FA_MAINT_SCHEDULE_DTL
176: set VENDOR_ID = p_vendor_id
177: , VENDOR_NAME = decode(VENDOR_NAME, NULL, NULL, l_vendor_name)
178: , VENDOR_NUMBER = decode(VENDOR_NUMBER, NULL, NULL, p_segment1)
179: where VENDOR_ID = p_dup_vendor_id;