DBA Data[Home] [Help]

APPS.PSA_MFAR_UTILS dependencies on PSA_MF_DISTRIBUTIONS_LOG

Line 733: l_last_updated_by PSA_MF_DISTRIBUTIONS_LOG.LAST_UPDATED_BY%TYPE;

729: p_error_message IN VARCHAR2) AS
730:
731: PRAGMA AUTONOMOUS_TRANSACTION;
732:
733: l_last_updated_by PSA_MF_DISTRIBUTIONS_LOG.LAST_UPDATED_BY%TYPE;
734: l_last_update_login PSA_MF_DISTRIBUTIONS_LOG.LAST_UPDATE_LOGIN%TYPE;
735:
736: BEGIN
737:

Line 734: l_last_update_login PSA_MF_DISTRIBUTIONS_LOG.LAST_UPDATE_LOGIN%TYPE;

730:
731: PRAGMA AUTONOMOUS_TRANSACTION;
732:
733: l_last_updated_by PSA_MF_DISTRIBUTIONS_LOG.LAST_UPDATED_BY%TYPE;
734: l_last_update_login PSA_MF_DISTRIBUTIONS_LOG.LAST_UPDATE_LOGIN%TYPE;
735:
736: BEGIN
737:
738: l_last_updated_by := FND_GLOBAL.USER_ID;

Line 750: INSERT INTO PSA_MF_DISTRIBUTIONS_LOG ( ERROR_ID,

746: IF l_last_update_login IS NULL THEN
747: l_last_update_login := -1;
748: END IF;
749:
750: INSERT INTO PSA_MF_DISTRIBUTIONS_LOG ( ERROR_ID,
751: ACTIVITY,
752: CUSTOMER_TRX_ID,
753: LAST_UPDATE_DATE,
754: LAST_UPDATED_BY,