APPS.JE_PT_CERTIFICATES_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 13

      p_last_updated_by                  IN   NUMBER,
      p_last_update_date                 IN   DATE,
      p_last_update_login                IN   NUMBER
   )
   IS
   l_count NUMBER;

Line: 21

   SELECT count(1)
   INTO l_count
   FROM JE_PT_CERTIFICATES
   WHERE apps_version = p_apps_version
   AND   key_version = p_key_version;

Line: 29

	   INSERT INTO JE_PT_CERTIFICATES
			( APPS_VERSION
			,KEY_VERSION
			,PRIVATE_KEY
			,CERTIFICATION_APPLICATION_DATE
			,CERTIFICATION_ISSUE_DATE
			,CERTIFICATION_NUMBER
			,CREATED_BY
			,CREATION_DATE
			,LAST_UPDATED_BY
			,LAST_UPDATE_DATE
			,LAST_UPDATE_LOGIN
			) VALUES
				(  P_APPS_VERSION
				, P_KEY_VERSION
				, P_PRIVATE_KEY
				, P_CERTIFICATION_APP_DATE
				, P_CERTIFICATION_ISSUE_DATE
				, P_CERTIFICATION_NUMBER
				, P_CREATED_BY
				, P_CREATION_DATE
				, P_LAST_UPDATED_BY
				, P_LAST_UPDATE_DATE
				, P_LAST_UPDATE_LOGIN
				);