687: );
688: end if;
689:
690: -- Set the WHO Columns
691: l_created_by := fnd_global.user_id;
692: l_creation_date := l_sysdate;
693: l_last_update_date := l_sysdate;
694: l_last_updated_by := fnd_global.user_id;
695: l_last_update_login := fnd_global.login_id;
690: -- Set the WHO Columns
691: l_created_by := fnd_global.user_id;
692: l_creation_date := l_sysdate;
693: l_last_update_date := l_sysdate;
694: l_last_updated_by := fnd_global.user_id;
695: l_last_update_login := fnd_global.login_id;
696:
697: IF P_OWNER_APPL_SHORT_NAME IS NOT NULL THEN
698: OPEN C_APPL;
691: l_created_by := fnd_global.user_id;
692: l_creation_date := l_sysdate;
693: l_last_update_date := l_sysdate;
694: l_last_updated_by := fnd_global.user_id;
695: l_last_update_login := fnd_global.login_id;
696:
697: IF P_OWNER_APPL_SHORT_NAME IS NOT NULL THEN
698: OPEN C_APPL;
699: FETCH C_APPL INTO l_appl_id;
794: ,p_user_id => -1
795: );
796: end if;
797: --
798: l_last_updated_by := fnd_global.user_id;
799: l_last_update_login := fnd_global.login_id;
800: l_last_update_date := sysdate;
801: --
802:
795: );
796: end if;
797: --
798: l_last_updated_by := fnd_global.user_id;
799: l_last_update_login := fnd_global.login_id;
800: l_last_update_date := sysdate;
801: --
802:
803: UPDATE pay_upgrade_definitions_tl