[Home] [Help]
297:
298: -- Translate char last_update_date to date
299: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
300: BEGIN
301: l_operation_plan_id := fnd_number.canonical_to_number(x_operation_plan_id);
302: select LAST_UPDATED_BY,LAST_UPDATE_DATE
303: INTO db_luby,db_ludate
304: from wms_op_plans_B where
305: operation_plan_id = l_operation_plan_id ;
643: UPDATE wms_op_plans_b SET
644: last_update_date = Sysdate,
645: last_updated_by = Decode(x_owner, 'SEED', 1, 0),
646: last_update_login = 0
647: WHERE operation_plan_id = fnd_number.canonical_to_number(x_operation_plan_id);
648: */
649: BEGIN
650: -- Test for customization and version
651: select LAST_UPDATED_BY,LAST_UPDATE_DATE
650: -- Test for customization and version
651: select LAST_UPDATED_BY,LAST_UPDATE_DATE
652: INTO db_luby,db_ludate
653: from wms_op_plans_B where
654: operation_plan_id = fnd_number.canonical_to_number(x_operation_plan_id);
655: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
656: db_ludate, x_custom_mode)) then
657:
658: -- Update translations for this language
662: last_update_date = f_ludate,
663: last_updated_by = f_luby,
664: last_update_login = 0,
665: source_lang = userenv('LANG')
666: WHERE operation_plan_id = fnd_number.canonical_to_number(x_operation_plan_id) AND userenv('LANG') IN (language, source_lang);
667: END IF;
668: exception
669: when no_data_found then
670: -- Do not insert missing translations, skip this row